With 500 built-in functions to choose from, Excel is not short of ways to help process data in your spreadsheet, and that’s before considering functions and datatypes associated with VBA. Many have been built for very specific use cases, but below are what could be considered the most used of those 500 and are worth getting to know a bit better.

The most used Excel Functions & Categories

Math functions

ABSINTMODRAND
RANDBETWEENROUNDROUNDDOWNROUNDUP
SQRTSUBTOTALSUMSUMIF
SUMIFSSUMPRODUCTTRUNC

Logical functions

ANDFALSEIFIFERROR
IFNAIFSNOTOR
SWITCHTRUEXOR

Lookup & Reference functions

ADDRESSCHOOSECOLUMNGETPIVOTDATA
HLOOKUPLOOKUPVLOOKUP
HYPERLINKINDEXINDIRECTMATCH
OFFSETROWTRANSPOSE

Date and Time functions

DATEDATEDIFDATEVALUEDAY
EDATEEOMONTHHOURISOWEEKNUM
MINUTEMONTHNOWSECOND
TODAYWEEKNUMWEEKDAYWORKDAY
YEAR

Engineering functions

DEC2BINDEC2HEXDEC2OCTCONVERT
HEX2BINHEX2DECHEX2OCT
OCT2BINOCT2DECOCT2HEX

Financial & Accounting functions

FVIRRNPVPMT
PVXIRRXNPVYIELD

Information & Validation functions

CELLISBLANKISERRISERROR
ISEVENISLOGICALISNAISNONTEXT
ISNUMBERISODDISREFISTEXT
NNA

Statistical functions

AVERAGEAVERAGEAAVERAGEIFAVERAGEIFS
COUNTCOUNTACOUNTIFCOUNTIFS
MAXMAXAMAXIFSCOUNTBLANKS
MINMINAMINIFS

Text Manipulation functions

CHARCLEANCONCATENATEEXACT
FIND, FINDBLEFT, LEFTBLEN, LENBLOWER
MID, MIDBPROPERREPLACE, REPLACEBREPT
RIGHT, RIGHTBSEARCH, SEARCHBSUBSTITUTETEXT
TRIMUPPERVALUE

016