Learn Excel formulas
One function per lesson, each with a live spreadsheet that checks your formula as you type it. Equivalent formulas count, so you are not marked wrong for writing it your own way.
No signup, no ads. Progress is saved in your browser only.
VLOOKUP
Find a value in a table by its first column
5 practice tasks
XLOOKUP
Find a value in one column and return it from another
5 practice tasks
INDEX MATCH
Look up values in any direction with INDEX and MATCH
5 practice tasks
IF
Return one result or another depending on a condition
5 practice tasks
SUMIF and SUMIFS
Add up only the values that meet a condition
5 practice tasks
COUNTIF and COUNTIFS
Count the cells that meet a condition
5 practice tasks
Percentages
Share of a total, percentage change, add or take off a percent
5 practice tasks