List of most useful Excel functions

Excel functions list:

Excel functions list


The following list represents the most useful Excel functions you will need in normal excel usage, that usage might include _but not limited to_ Accounting, Engineering, bookkeeping, or making simple database.

  1. Sum
  2. Sumif
  3. Sumifs
  4. If
  5. Iferror
  6. Ifna
  7. Vlookup
  8. Index
  9. Match
  10. And
  11. Or
  12. Min
  13. Max
  14. Average
  15. Text
  16. Trim
  17. Abs
  18. Value
  19. Ceiling
  20. Round
  21. Roundup
  22. Rounddown
  23. Concatenate
  24. Indirect
  25. Istext
  26. Mod
  27. Len
  28. Rept
  29. Offset
  30. Lower
  31. Upper
  32. Proper
  33. Rand
  34. Randbetween
  35. Replace
  36. Search
  37. Cell
  38. Row
  39. Column
  40. Now
  41. Today

This list may be updated from time to time.
If you wish to understand excel from scratches and learn Excel basics you can Start here >>

Thank you for your time.