List of most useful Excel functions
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.
- Sum
- Sumif
- Sumifs
- If
- Iferror
- Ifna
- Vlookup
- Index
- Match
- And
- Or
- Min
- Max
- Average
- Text
- Trim
- Abs
- Value
- Ceiling
- Round
- Roundup
- Rounddown
- Concatenate
- Indirect
- Istext
- Mod
- Len
- Rept
- Offset
- Lower
- Upper
- Proper
- Rand
- Randbetween
- Replace
- Search
- Cell
- Row
- Column
- Now
- 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.
