⭐ 4.9 out of 5 • Trusted by over 100,000 learners since 2014

Excel functions

Array functions
SORT SORTBY UNIQUE FILTER SEQUENCE XMATCH RANDARRAY
Cell reference functions
VLOOKUP HLOOKUP MATCH, INDEX, CHOOSE INDIRECT OFFSET XLOOKUP
Count & Sum functions
COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS SUMIF SUMIFS SUMPRODUCT SUM
Date and Time functions
Date and Time Functions DATEDIF EOMONTH WEEKDAY WORKDAY NETWORKDAYS
Financial functions
PMT RATE NPER PV FV PPMT IPMT IRR NPV SLN SYD DB DDB VDB
Logical functions
IF AND & OR IFERROR
Rounding functions
ROUND ROUNDUP, ROUNDDOWN EVEN, ODD INT, TRUNC
Statistical functions
AVERAGE, AVERAGEIF MEDIAN, MODE LARGE, SMALL STDEV RAND RANDBETWEEN RANK PERCENTILE FORECAST QUARTILE
Text functions
EXACT LEN UPPER, LOWER, & PROPER TRIM, CLEAN LEFT, RIGHT & MID FIND, SEARCH SUBSTITUTE & REPLACE