Learn Excel
Draft. This page's introduction is a placeholder until the launch batch writes it.
Excel is easier to learn in order. Each level below builds on the one before it: Foundations gets you moving around the grid and writing your first formulas, Intermediate covers what office jobs and hiring tests ask for, and Advanced is for people who build the sheets everyone else uses.
Not sure where you fit? Take the short check first. Each level then lists free pages to read in order, and the matching course in the practice app has graded drills for every step.
Where should you start?
Six quick questions, getting harder as you go. Say what each formula returns on the sheet. It stops at your first miss.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item ID | Item | Category | Qty | Unit Value |
| 2 | I01 | Boxer cartridge | Tools | 12 | 3.5 |
| 3 | I02 | Briar pipe | Smoking | 7 | 4.25 |
| 4 | I03 | Candle | Household | 20 | 2 |
| 5 | I04 | Cigar | Smoking | 5 | 10 |
| 6 | I05 | Clay pipe | Smoking | 15 | 1.75 |
| 7 | I06 | Commonplace book | Papers | 9 | 6 |
This only suggests a starting point. In the app, a level is earned by passing its timed exam, and each course opens once you hold the level before it.
Three levels, one path
- 1
Foundations
Levels A1 · A2
Find your way around the grid and handle everyday sheets on your own.
Moving around, typing data in, SUM and friends, percentages, $ references, IF and COUNTIF.
Read free, in this order
Start the Foundations course First lessons free - 2
Intermediate
Levels B1 · B2
Do the spreadsheet side of an office job without asking for help.
Lookups, multi-condition sums, cleaning text, dates, drop-down lists and the job-test favourites.
Read free, in this order
See the Intermediate course Opens once you hold A2 - 3
Advanced
Levels C1 · C2
Build sheets other people rely on, with formulas that do the heavy lifting.
Dynamic arrays, reshaping data, pattern matching and writing your own functions.
Read free, in this order
Advanced course coming soon Opens once you hold B2
Look something up
- Functions
Every function with its syntax, a worked example and what Excel really returned.
- How-to
Step-by-step answers to everyday jobs, from drop-down lists to locked cells.
- Shortcuts
The keyboard shortcuts worth learning first, grouped by task.
- Errors
What #N/A, #VALUE! and the rest mean, and how to clear each one.
- Features
The big tools from the start: pivot tables, formatting, validation.
More ways to learn
Practice it for real
Short drills in an Excel-style grid, checked the moment you press Enter.