Spreadsheet Practice

Every lesson, in order

45 lessons and 127 graded exercises. Each one starts with a short walkthrough on sample data, then gives you a fresh sheet to solve yourself. The first 11 are free.

Foundations

Free

Formulas, the core functions, and the $ that trips everyone up.

#LessonFunctionsMinutesExercisesYour progress
1Your first formula+ − × ÷, ( )62
2SUM, AVERAGE, MIN, MAX & COUNTSUM, AVERAGE, MIN, MAX, COUNT, COUNTA73
3Relative vs absolute references$A$1, $A1, A$193
4Percentages & growth%, ^72

Logic & conditions

Free

IF, AND/OR, IFS, and counting or adding only the rows that match.

#LessonFunctionsMinutesExercisesYour progress
5The IF functionIF72
6AND, OR & IFSAND, OR, IFS93
7COUNTIF & SUMIFCOUNTIF, SUMIF83
8COUNTIFS, SUMIFS & AVERAGEIFSSUMIFS, COUNTIFS, AVERAGEIFS103

Data tools

Free

Conditional formatting, PivotTables and charts: the tools most Excel tests check.

#LessonFunctionsMinutesExercisesYour progress
9Conditional formatting with formulasConditional formatting, COUNTIF, $103
10PivotTablesPivotTable, Rows, Values, Filters124
11Charts: pick the right oneLine, Column, Pie, Scatter94

Lookups

Pro

VLOOKUP, XLOOKUP, INDEX/MATCH and tiered lookups.

#LessonFunctionsMinutesExercisesYour progress
12VLOOKUPVLOOKUP92
13XLOOKUPXLOOKUP93
14INDEX & MATCHINDEX, MATCH102
15Tiered lookups & IFERRORXLOOKUP, VLOOKUP, IFERROR92
16Lookups with several criteriaXLOOKUP, &, INDEX, MATCH103
17Last match, nearest value & wildcardsXLOOKUP, match_mode, search_mode103

Text cleanup

Pro

Split, join and clean messy imported text.

#LessonFunctionsMinutesExercisesYour progress
18LEFT, RIGHT, MID & LENLEFT, RIGHT, MID, LEN83
19Joining text&, CONCAT, TEXTJOIN73
20Cleaning messy dataTRIM, PROPER, LOWER, SUBSTITUTE83
21TEXTBEFORE, TEXTAFTER & FINDTEXTBEFORE, TEXTAFTER, FIND83
22Splitting and counting list cellsTEXTSPLIT, COUNTA, TRIM, SUBSTITUTE92

Dates

Pro

How Excel stores dates, and the math that follows.

#LessonFunctionsMinutesExercisesYour progress
23DATE, YEAR, MONTH & TEXTDATE, YEAR, MONTH, TEXT83
24EDATE, EOMONTH & NETWORKDAYSEDATE, EOMONTH, NETWORKDAYS93
25Tenure, quarters & weekdaysDATEDIF, WEEKDAY, MONTH, ROUNDUP103

Dynamic arrays

Pro

UNIQUE, SORT, FILTER and LET: one formula, many results.

#LessonFunctionsMinutesExercisesYour progress
26UNIQUE & SORTUNIQUE, SORT93
27FILTERFILTER103
28LETLET82
29SORTBY, TAKE & SEQUENCESORTBY, TAKE, SEQUENCE93
30VSTACK & HSTACKVSTACK, HSTACK93
31LAMBDA with BYROW, MAP & SCANLAMBDA, BYROW, MAP, SCAN123
32Self-building summary tablesUNIQUE, SUMIFS, SORTBY, SUMIF113

Analysis

Pro

Rounding, ranking and SUMPRODUCT.

#LessonFunctionsMinutesExercisesYour progress
33ROUND, ROUNDUP & ROUNDDOWNROUND, ROUNDUP, ROUNDDOWN73
34RANK, LARGE & SMALLRANK.EQ, LARGE, SMALL93
35SUMPRODUCTSUMPRODUCT93
36Running totals & share of totalSUM, $, Cumulative share93
37Median, quartiles & outliersMEDIAN, QUARTILE.INC, PERCENTILE.INC, STDEV114
38MAXIFS & MINIFS by groupMAXIFS, MINIFS82

Finance

Pro

Loan payments, time value of money, NPV and IRR.

#LessonFunctionsMinutesExercisesYour progress
39Loan payments with PMTPMT93
40Future & present valueFV, PV82
41NPV & IRRNPV, IRR102

Errors & checks

Pro

Handle errors on purpose, catch duplicates, and prove two lists agree.

#LessonFunctionsMinutesExercisesYour progress
42Handling errors on purposeIFNA, IFERROR, ISNUMBER103
43Duplicates & reconciliationCOUNTIF, $, Expanding range113

Capstones

Pro

Multi-step challenges like the ones in analyst interviews.

#LessonFunctionsMinutesExercisesYour progress
44Capstone: sales reportSUMIFS, SORT, UNIQUE, #153
45Capstone: analyst interview testXLOOKUP, IF, AND123