Learn Excel formulas by doing them
Each lesson explains one function in plain words, then gives you a real spreadsheet to practise in. Your formulas are checked as you type them, and tested on changed data so the answer has to come from the formula.
No signup, no ads, no tracking. Progress is saved in your browser only.
Excel formulas
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