For Excel and Google Sheets
Spreadsheet formulas, five minutes a day.
Short daily lessons on a live sheet in your browser. Write real formulas, see the cells recalculate, get checked instantly, and keep a streak going. From your first =B2*C2 to XLOOKUP and SUMIFS.
Free, no account needed for the first 9 lessons.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Sold | Price | Total |
| 2 | Sourdough loaf | 14 | $6.50 | $91.00 |
| 3 | Croissant | 32 | $2.80 | $89.60 |
| 4 | Cinnamon bun | 21 | $3.20 | $67.20 |
| 5 | Baguette | 18 | $3.00 | $54.00 |
| 6 | Rye loaf | 9 | $7.00 | $63.00 |
This is a real sheet. Edit the formula in D2 and the whole column recalculates.
A lesson is a few minutes of doing, not watching.
- 1
See the idea work
Each lesson opens with one idea and a Try it button that types the formula into a real cell, so you see it calculate before you read on.
- 2
Write the formula yourself
Type in the formula bar or tap cells to insert references. The sheet recalculates as you type, with hints for every function.
- 3
Get checked, cell by cell
Wrong? You'll see exactly which cell is off and what it should show. Right? XP, a streak day and the next step.
From first formula to job-ready.
16 units, 55 lessons and 275 exercises on realistic sheets: a plant shop's orders, a sales team's quarter, a household budget, a project plan.
- 1
Cells and formulas
Free=A2*B2, operators, fill down, $A$1
- Your first formula
- Divide, brackets and percentages
- Copy a formula down
- Lock it with $
- 2
Ranges and functions
FreeSUM, AVERAGE, COUNT, MIN, MAX, ROUND
- Ranges and SUM
- AVERAGE, MAX and MIN
- COUNT and COUNTA
- Shares and percent change
- ROUND, and functions inside functions
- 3
Decisions
ProIF, AND, OR, nested IF, IFERROR
- TRUE, FALSE and IF
- More than two outcomes
- AND and OR
- IFS and SWITCH
- Errors and blank cells
- 4
Lookups
ProVLOOKUP, INDEX/MATCH, XLOOKUP
- VLOOKUP
- INDEX and MATCH
- XLOOKUP
- 5
Conditional totals
ProSUMIFS, COUNTIFS, AVERAGEIFS, wildcards
- SUMIF and criteria
- SUMIFS
- COUNTIF, AVERAGEIFS and MAXIFS
- Wildcards
- 6
Text and dates
ProTRIM, LEFT, FIND, TEXT, DATE, NETWORKDAYS
- Tidy text: TRIM and PROPER
- Cut text: LEFT, RIGHT and MID
- Find a position: FIND and LEN
- Join text and TEXT()
- Dates
- 7
Dates and time maths
ProDATEDIF, YEARFRAC, WORKDAY, hours
- Years, months and tenure
- Weekdays and working days
- Hours and times
- 8
Cleaning text at scale
ProSUBSTITUTE, CLEAN, split names, VALUE
- SUBSTITUTE, CLEAN and invisible spaces
- Split names and codes
- Numbers stored as text
- 9
Data quality
ProDuplicates, type checks, IFS, SWITCH
- Find duplicates
- Check and convert types
- 10
Advanced lookups
ProTwo-way, tiers, multiple criteria
- Two-way lookups
- Tiers and brackets
- Lookups on several conditions
- 11
Dynamic arrays
ProFILTER, UNIQUE, SORT, SEQUENCE, #
- FILTER
- UNIQUE and SORT
- SEQUENCE and spill ranges
- 12
LET and LAMBDA
ProLET, LAMBDA, MAP, BYROW, REDUCE
- LET
- LAMBDA
- 13
Statistics
ProMEDIAN, PERCENTILE, STDEV.S, CORREL
- Typical values and spread
- Ranks, percentiles and bands
- 14
Money and finance
ProPMT, FV, NPER, NPV, IRR
- Simple and compound interest
- Loan payments
- Amortization schedule
- Savings, NPV and IRR
- 15
Reporting patterns
ProSUMIFS grids, growth, running totals, top N
- Summary grids and SUMPRODUCT
- Running totals and growth
- Top N and rankings
- 16
Job test pack
ProTimed, original job-test problems
- Warm-up round
- Core round
- Final round
- Case study
Built so the skill actually sticks.
- Checked as a real formulaAnswers must start with = and use the sheet's cells. We also re-run them on changed data, so a typed-in number never passes. That's the habit your future spreadsheets need.
- Excel and Google Sheets, honestlyEverything taught works in both. Where they differ (XLOOKUP in older Excel, IFS, Sheets-only functions), the lesson says so.
- A streak, not a guilt tripA daily goal you pick, streak backups for busy days, and a daily review that brings back exactly the exercises you're about to forget.
Free guides with live sheets.
The formulas people search for most, explained with examples you can edit right on the page.
- LookupsVLOOKUP vs XLOOKUPHow VLOOKUP and XLOOKUP differ, when each one breaks, and which to use in Excel and Google Sheets. Live examples you can edit in your browser.5 sections · live examples →
- LookupsINDEX MATCH, explainedHow INDEX and MATCH work alone and together, how to look up to the left, and how to do two-way lookups. Live, editable examples for Excel and Google Sheets.4 sections · live examples →
- Totals and reportsSUMIFS: totals with conditionsHow SUMIF and SUMIFS add up only the rows that match: text, numbers, dates, criteria from cells and wildcards. Editable examples for Excel and Google Sheets.5 sections · live examples →
- Logic and errorsIF with AND and ORHow to combine IF with AND, OR and nested IFs (or IFS) for multiple conditions in Excel and Google Sheets, with live examples you can edit.4 sections · live examples →
- BasicsAbsolute and relative referencesWhat $A$1, A$1 and $A1 mean, why formulas break when you fill them down, and how to fix them. Live examples for Excel and Google Sheets.4 sections · live examples →
- Logic and errorsIFERROR and IFNAHow IFERROR and IFNA catch formula errors, when to use IF instead, and why hiding errors can hide mistakes. Editable examples for Excel and Google Sheets.5 sections · live examples →
Free formula tools, no account needed.
For Excel and Google Sheets. They run in your browser and send nothing you paste to anyone.
Formula explainer
Paste any formula and read it in plain English, with nested functions broken down step by step.
Explain a formulaExcel error decoder
What each error means, the usual causes, and how to fix it.
- #N/AThe formula couldn't find what it was asked to look for.
- #SPILL!A formula returns several values, but Excel can't put them in the cells it needs.
Questions
Do I need Excel or Google Sheets installed?+
No. Every lesson runs on a live sheet in your browser, on your phone or computer. What you learn works the same when you open Excel or Google Sheets at work.
Is it for Excel or for Google Sheets?+
Both. The course teaches formulas that behave the same in each, and points out the few differences, such as XLOOKUP needing Excel 2021 or Microsoft 365.
How are answers checked?+
On our server, against an answer key built from the official solution. Your formula must use the sheet's cells, and it's re-run on changed data, so typing in the result doesn't pass.
What does it cost?+
Units 1 and 2 are free, with no time limit and no card. Pro, which opens soon, unlocks the rest for $6 a month, $40 a year or $99 once.
Your first formula takes about a minute.
No account, no card, no install. Just a sheet and a blinking cursor.