30 Excel Functions in 30 Days: Conclusion

Icon30DayThanks for participating in the 30XL30D challenge, that ended yesterday. My favourite Excel function in the series was INDEX — I learned a few useful tricks while researching that one! How about you?

As I promised, here is a list of the 30 functions, with their rank in your voting.

NOTE: You can have all of the 30 Functions content in an easy-to-use single reference file — the 30 Excel Functions in 30 Days eBook Kit ($10).

30 Excel Functions Ranking

  1. VLOOKUP
  2. ADDRESS
  3. INDIRECT
  4. INDEX
  5. OFFSET
  6. MATCH
  7. CHOOSE
  8. AREAS
  9. LOOKUP
  10. CELL
  11. FIND
  12. HLOOKUP
  13. TRANSPOSE
  14. ERROR.TYPE
  15. EXACT
  16. SUBSTITUTE
  17. CLEAN
  18. REPLACE
  19. SEARCH
  20. CODE
  21. T
  22. INFO
  23. N
  24. COLUMNS
  25. HYPERLINK
  26. TYPE
  27. TRIM
  28. CHAR
  29. FIXED
  30. REPT

Buy the 30XL30D eBook Kit

If you want all of the 30XL30D content in an easy-to-use single reference file, you can buy the 30 Excel Functions in 30 Days eBook kit. Learn more about the 30 Excel functions in:

  • a 150 page written lesson guide
  • links to all the Excel video tutorials
  • an Excel file with 100 function examples

For more details, please go to the 30 Excel Functions in 30 Days eBook kit page on the Contextures website.

30 Excel Functions in 30 Days

Save

You may also like...

5 Responses

  1. Luke Wisbey says:

    For me INDEX is undoubtedly the most versatile function available in Excel and for that reason alone should really be #1 !

  2. Thanks Luke, and thanks for all your contributions during the series.

  3. Doug Glancy says:

    Thanks for doing this Debra. It’s quite an undertaking!
    I’d like to second Luke’s comment. As I was looking at the rankings I was thinking that Index is my #1. My appreciation of it has grown hugely in the last few months, especially in the area of replacing VLookups with Index/Match.

  4. Thanks Doug! It was a big task, and rewarding to learn all the new formula tips and tricks.

  5. Francisco Javier Romero Romo says:

    Thanks a lot Debra.
    The whole series of 30 detailed Functions was marvellous documented. Eventhough there are over 3xx functions in total, ther were in my humble opinion the most commonly used.

    Carry on with these ideas

    Regards

    Francisco Romero

Leave a Reply to Francisco Javier Romero Romo Cancel reply

Your email address will not be published. Required fields are marked *