1. Beginner
Your first formulas: totals, averages, simple decisions and text.
0 of 38 done
1 Your first formula Not done yet4 Fill a formula and lock a cell Not done yet10 A week at the café Not done yet11 Questions about a staff list Not done yet12 Stock check Not done yet13 Beginner test Not done yet
2 Add up with SUM Not done yet
3 Average, highest, lowest and how many Not done yet
5 Make decisions with IF Not done yet
6 Round numbers Not done yet
7 Combine tests with AND, OR and NOT Not done yet
8 Make a sheet easy to read Not done yet
- Make a sheet easy to read Not done yet
- Make the header bold Not done yet
- Show figures as money Not done yet
- Show shares as percentages Not done yet
- Strike out a cancelled order Not done yet
- Work out growth as a percentage Not done yet
- See the value behind a format Not done yet
- Tidy a table for a report Not done yet
9 Whole numbers, remainders and roots Not done yet
2. Intermediate
The conditions, lookups and dates that offices run on.
0 of 63 done
1 Count, sum and average with a condition Not done yet
2 Look things up with XLOOKUP Not done yet
3 Join and tidy text Not done yet
4 Several conditions at once Not done yet
5 Dates are numbers Not done yet
6 Many outcomes: IFS and SWITCH Not done yet
7 Catch errors with IFERROR Not done yet
8 INDEX and MATCH Not done yet
9 VLOOKUP, the older lookup Not done yet
10 Take text apart Not done yet
11 Clean up messy text Not done yet
12 Show numbers and dates as text Not done yet
13 Working days and month ends Not done yet
14 Rank a list and measure it Not done yet
15 Build dates and use today Not done yet
16 Search text and split it Not done yet
3. Advanced
Arrays that spill, and the maths of money.
0 of 43 done
1 Formulas that spill Not done yet
2 The maths of a loan Not done yet
3 Multiply then add: SUMPRODUCT Not done yet
4 Name the parts: LET and LAMBDA Not done yet
5 Reshape a table Not done yet
6 Is the project worth it? NPV and IRR Not done yet
7 Point at cells by position Not done yet
8 Ask a loan other questions Not done yet
9 Returns when the dates are uneven Not done yet
10 Row by row, and lists stacked Not done yet
4. Real projects
A budget report, a loan schedule and a valuation, built part by part. Then the final test.
0 of 4 done
Keyboard shortcuts
Optional. The keys that make Excel fast.
0 of 38 done