Excel practice online,
in a real spreadsheet.
Short interactive exercises, right in your browser. You type the formula, it's checked instantly, and when it's wrong you see why. No install, no sign-up, no 40-minute videos.
Mike bought a Latte. In E2, write a formula that looks up its price in the menu.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Price | Order | Paid | |
| 2 | Espresso | 3.00 | Latte | 4.50 | |
| 3 | Latte | 4.50 | |||
| 4 | Cappuccino | 4.25 | |||
| 5 | Mocha | 5.00 | |||
| 6 | Flat white | 4.75 |
✓ Correct. FALSE asks for an exact match, so a typo gives #N/A instead of a wrong price.
A real spreadsheet
Formulas are evaluated like in Excel: cell references, ranges, $ locking, errors such as #N/A and #DIV/0!. What you practice here works the same in your own files.
Feedback that explains
Wrong column number, a range that isn't locked, text without quotes, approximate match by accident: it tells you what went wrong, not just "incorrect".
No shortcuts
Typing the answer in doesn't pass: the exercise checks that your formula points at the cells, so it keeps working when the data changes.
Excel exercises, by topic
The skills test and the two beginner lessons are free. The rest is one payment: $19 for the Excel lessons, or $29 for Pro, which adds the SQL and finance lessons.
Lesson
What you practice
ExercisesAccessExcel skills test
10 questions in a real spreadsheet, from SUM to INDEX/MATCH. Get your level at the end
10FreeExcel practice for beginners
The grid, cell addresses, SUM, AVERAGE and MAX
6FreeExcel IF function practice
IF with text and numbers, AND, OR, nested IF
7FreeVLOOKUP practice exercises
Column number, the first-column rule, IFERROR, $ locking
6ProXLOOKUP practice exercises
Look up in any direction, if_not_found, XLOOKUP inside IF and math
6ProSUMIFS and COUNTIFS practice
COUNTIF, SUMIF, SUMIFS, COUNTIFS, AVERAGEIFS, criteria from a cell
7ProINDEX MATCH practice exercises
Look up to the left, two-way lookups, IFERROR
7ProExcel date functions practice
Days between dates, EOMONTH, NETWORKDAYS, TEXT labels
7ProExcel keyboard shortcuts practice
Jump, select, AutoSum, F4, fill down, Ctrl+Enter, F2, pressed for real
9ProExcel pivot table practice
Rows, Columns, Values, Filters: totals, a grid, counts, months, % of total, Refresh
9Pro