Practice
New here?
Get a plan in 60 seconds, then start your first exercise.
Projects
Lessons
Sheet basics
Cells, rows and cell addresses
0 of 3 done
Simple formulas
+ − × ÷, cell references, copying a formula down
0 of 9 done
SUM, AVERAGE, COUNT, MIN and MAX
Full planTotals, averages, counts, the biggest and smallest value
0 of 7 done
Percentages and fixed references
Full plan% of total, % change, $ references, ROUND, ROUNDUP, IFERROR
0 of 7 done
IF, AND, OR, IFS
Full planYes/no checks, nested IF, IFS and SWITCH
0 of 8 done
COUNTIF and SUMIF
Full planCOUNTIF(S), SUMIF(S), AVERAGEIFS, MAXIFS, MINIFS
0 of 11 done
Lookups
Full planXLOOKUP, VLOOKUP, INDEX + MATCH, IFNA, not-found values
0 of 8 done
Text extraction
Full planLEN, LEFT, RIGHT, MID, FIND, SEARCH
0 of 7 done
Joining text
Full plan&, CONCAT, TEXTJOIN, UPPER, LOWER, PROPER, SUBSTITUTE
0 of 6 done
Data cleaning
Full planTRIM, CLEAN, VALUE, TEXT, IS functions, text dates
0 of 9 done
Dates
Full planDATE, YEAR, MONTH, WEEKDAY, EOMONTH, date maths
0 of 7 done
Workdays and date gaps
Full planEDATE, DAYS, DATEDIF, NETWORKDAYS, WORKDAY
0 of 6 done
Statistics and ranking
Full planMEDIAN, LARGE, SMALL, RANK, PERCENTILE, QUARTILE, STDEV
0 of 8 done
Summary tables
Full planPivot-style tables with SUMIFS and COUNTIFS grids
0 of 10 done
Lookups II
Full planBands, two-way INDEX/MATCH, combined keys, CHOOSE
0 of 7 done
SUMPRODUCT and conditions
Full planWeighted averages and multi-condition maths
0 of 6 done
Broken sheets
Full planFix #N/A, #VALUE!, #DIV/0!, #REF! and rule columns
0 of 7 done
Finance and what-if
Full planPMT, FV, PV, NPER, NPV, IRR, scenarios
0 of 8 done
Dynamic arrays
Full planFILTER, SORT, SORTBY, UNIQUE, SEQUENCE, TAKE
0 of 10 done
Summary tables II
Full planSummaries that grow with UNIQUE and E2# references
0 of 6 done
LET
Full planName the steps of a long formula
0 of 4 done