Practice Excel formulas by doing them
Short, realistic exercises with instant feedback. Type real Excel formulas into a real spreadsheet and find out straight away whether they work, and why.
| A | B | |
|---|---|---|
| 1 | Coffee | 24 |
| 2 | Tea | 18 |
| 3 | Cake | 31 |
| 4 | Total | =SUM(B1:B3) |
Correct! Your formula is right on this data and on other data too.
Where would you like to start?
New to Excel
Cells, formulas, totals, percentages and your first IF. No experience needed.
Know the Basics
Conditional sums and counts, lookups, text and dates.
Ready for More
Two-way lookups, loans and investments, weighted figures and distinct counts.
Topic guides
How it works
- Read a short, realistic task and look at the data.
- Type your formula into the highlighted cell, just like in Excel.
- Check your answer. We test it against other data too, so only genuine solutions pass.
All exercises by topic
Excel basics
Percentages and rounding
Essential formulas
Logical functions
Text functions
Date functions
Conditional calculations
Lookup functions
Data analysis
Finance