Top 100 Excel Functions to Learn:
✅ Math & Basic Arithmetic
• SUM
• SUMIF
• SUMIFS
• PRODUCT
• QUOTIENT
• MOD
• ROUND
• ROUNDUP
• ROUNDDOWN
• INT
• TRUNC
• ABS
• SIGN
• POWER
• SQRT
✅ Logical Functions
• IF
• IFS
• IFERROR
• AND
• OR
• NOT
• XOR
• SWITCH
✅ Lookup & References
• VLOOKUP
• HLOOKUP
• XLOOKUP
• INDEX
• MATCH
• LOOKUP
• FILTER
• SORT
• SORTBY
• UNIQUE
• CHOOSE
• OFFSET
• ROW
• ROWS
• COLUMN
• COLUMNS
• FORMULATEXT
• HYPERLINK
✅ Date & Time
• TODAY
• NOW
• DATE
• TIME
• DAY
• MONTH
• YEAR
• WEEKDAY
• WEEKNUM
• HOUR
• MINUTE
• SECOND
• EDATE
• EOMONTH
• DATEDIF
• NETWORKDAYS
• WORKDAY
• ISOWEEKNUM
✅ Information & Error Handling
• ISBLANK
• ISNUMBER
• ISTEXT
• ISERROR
• ISNA
• N
• TYPE
• ERROR.TYPE
• NA
✅ Text Functions
• TEXT
• CONCAT
• TEXTJOIN
• LEFT
• RIGHT
• MID
• LEN
• TRIM
• PROPER
• UPPER
• LOWER
• REPLACE
• SUBSTITUTE
• REPT
• CHAR
• CODE
• CLEAN
✅ Statistical & Data Analysis
...
Suggested Credits
Tags, Events, and Projects