Unit 1
Cells and formulas
Write your first formulas, then copy them down a column.
- 01Your first formulaMake a cell add, subtract and multiply for you.6 exercisesStart
- 02Divide, brackets and percentagesSplit values with /, control the order with brackets, and work with %.5 exercisesOpen
- 03Copy a formula downOne formula, every row.6 exercisesOpen
- 04Lock it with $Absolute and mixed references.5 exercisesOpen
Unit 2
Ranges and functions
Ranges, then SUM, AVERAGE, MAX, MIN, COUNT and ROUND.
- 05Ranges and SUMPoint at many cells at once, then add them all up.5 exercisesOpen
- 06AVERAGE, MAX and MINThe typical value and the extremes of a range.4 exercisesOpen
- 07COUNT and COUNTAHow many cells hold numbers, and how many aren't empty.3 exercisesOpen
- 08Shares and percent changePart of a whole, and how much something grew.6 exercisesOpen
- 09ROUND, and functions inside functionsChange the value itself, and combine two functions in one formula.4 exercisesOpen
Unit 3
Decisions
Comparisons, IF, nested IFs, AND, OR, IFS and IFERROR: formulas that choose.
- TRUE, FALSE and IFAsk a yes/no question, then choose a result.8 exercisesPro
- More than two outcomesPut an IF inside another IF.2 exercisesPro
- AND and ORCombine conditions.4 exercisesPro
- IFS and SWITCHMany outcomes without the nesting.3 exercisesPro
- Errors and blank cellsCatch errors and empty cells before they spread.5 exercisesPro
Unit 4
Lookups
VLOOKUP, INDEX/MATCH and XLOOKUP: pull data from another table.
Unit 5
Conditional totals
SUMIF, SUMIFS, COUNTIFS and AVERAGEIFS: totals for just the rows you want.
Unit 6
Text and dates
Clean up names, cut and join text, and calculate with dates.
- Tidy text: TRIM and PROPERExtra spaces out, capitals fixed.4 exercisesPro
- Cut text: LEFT, RIGHT and MIDTake characters from the start, the end or the middle.3 exercisesPro
- Find a position: FIND and LENWhere a character is, and how long a text is.4 exercisesPro
- Join text and TEXT()Build labels with &, TEXT and TEXTJOIN.5 exercisesPro
- DatesDate maths, DATE, MONTH and EOMONTH.6 exercisesPro
Unit 7
Dates and time maths
Ages, tenure, working days and hours worked.
Unit 8
Cleaning text at scale
Fix messy exports: stray characters, split names, numbers stored as text.
Unit 9
Data quality
Find duplicates and check types before you trust the data.
Unit 10
Advanced lookups
Two-way lookups, tiers and brackets, and lookups on several conditions.
Unit 11
Dynamic arrays
FILTER, UNIQUE, SORT and SEQUENCE: one formula, a whole spilled result.
Unit 12
LET and LAMBDA
Name parts of a formula, and build your own functions.
Unit 13
Statistics
Typical values, spread, ranks and percentiles.
Unit 14
Money and finance
Interest, loan payments, savings and project returns.
Unit 15
Reporting patterns
Summary grids, shares, running totals, growth and top-N.
Unit 16
Job test pack
Original, timed problems like the spreadsheet tests in job interviews.