Endless practiceFresh problems every timeFriends & leaderboardCompete this weekCertificatesEarn proof of skill
The first course is free. Unlock all 87 lessons.
Keyboard mastery, advanced functions, power features, projects and unlimited practice. Plans from $5 a month.
Spreadsheet basics
Cells, formulas, SUM, references and percentages
- Cells, rows & columnsFind your way around a spreadsheet.5 steps
- Your first formulaType = and let the spreadsheet do the maths.5 steps
- SUM: adding things upYour first function and the most-used one in Excel.5 steps
- AVERAGE, MIN & MAXSummarise a list in one formula.5 steps
- Cell references & fill downWrite one formula, then copy it everywhere.5 steps
- Absolute references ($)Lock a cell so it never moves when you copy.5 steps
- Percentages & growthPercent of a total, percent change and discounts.5 steps
- COUNT, COUNTA & COUNTBLANKCount numbers, entries and gaps.5 steps
Keyboard essentials
Copy, navigate, select and format without the mouse
- Copy, paste & undoThe five shortcuts you will use every single day.Premium
- Jump around in secondsStop scrolling. Move across big sheets instantly.Premium
- Select like a proGrab columns, rows and whole tables without the mouse.Premium
- Format with your keyboardBold, currency, percent and more without touching the ribbon.Premium
- Edit & formula shortcutsEdit cells, auto-sum and toggle $ with one key.Premium
- Rows, columns & findInsert, delete, filter and search quickly.Premium
Keyboard mastery
Go To, selection, editing, the Alt ribbon and speed drills
- Navigate like a proGo To, jump to the active cell and move through data fast.Premium
- Selection masterySelect tables, regions and visible cells without dragging.Premium
- Edit without the mouseEdit, cancel, fill and add line breaks from the keyboard.Premium
- Formula bar & calculationShow formulas, recalculate and insert functions with keys.Premium
- Formatting shortcuts, round twoNumber formats, borders and dialogs.Premium
- Rows, columns & sheetsInsert, delete, hide and switch quickly.Premium
- The Alt key: the ribbon without a mousePress Alt, then follow the letters to reach any command.Premium
- Data & table shortcutsFilter, chart and tidy data from the keyboard.Premium
- Workbook & file shortcutsSave, find, replace, link and print.Premium
- Speed roundA mixed drill of everything you’ve learned.Premium
Essential functions
IF, COUNTIF, SUMIFS, text, dates and more
- IF: make decisionsReturn different results depending on a test.Premium
- AND & ORCombine several conditions in one test.Premium
- Nested IF & IFSHandle more than two outcomes, like grade bands.Premium
- COUNTIF: count with a ruleCount cells that meet a condition.Premium
- SUMIF: add with a ruleTotal only the rows that match.Premium
- SUMIFS & COUNTIFSMatch on more than one condition.Premium
- AVERAGEIF & MEDIANAverage a subset and find the middle value.Premium
- Rounding & remaindersROUND, ROUNDUP, ROUNDDOWN, INT and MOD.Premium
- LEFT, RIGHT, MID & LENPull pieces out of text.Premium
- Clean & fix textTRIM, UPPER, LOWER, PROPER and SUBSTITUTE.Premium
- Join text togetherCombine cells with &, CONCAT and TEXTJOIN.Premium
- Working with datesPull parts out of dates and measure gaps.Premium
- IFERROR: tame errorsReplace ugly errors with something useful.Premium
- LARGE, SMALL, RANK & SUMPRODUCTFind top performers and weighted totals.Premium
Advanced functions
Dynamic arrays, SUMPRODUCT, statistics and date maths
- MAXIFS, MINIFS & AVERAGEIFSConditional maximums, minimums and averages with several rules.Premium
- Logical helpers: IFNA, ISNUMBER & friendsTest what a cell contains and handle only the errors you expect.Premium
- SUMPRODUCT with conditionsAdd or count with several conditions, no helper columns.Premium
- Dynamic arrays: UNIQUE, SORT & FILTERFormulas that return whole lists (Excel 365 / 2021).Premium
- More text functionsSEARCH, TEXTBEFORE, TEXTAFTER, VALUE, REPT and EXACT.Premium
- Dates deep diveWEEKDAY, EOMONTH, EDATE, WORKDAY and NETWORKDAYS.Premium
- Statistics: spread, mode & correlationMODE, STDEV, PERCENTILE, QUARTILE and CORREL.Premium
- Rounding to multiplesCEILING, FLOOR, MROUND and QUOTIENT for prices and packs.Premium
- Nested logic that doesn’t breakCombine IFS, AND, OR and IFERROR into reliable formulas.Premium
- Array thinkingDo maths on whole ranges at once.Premium
Lookups
VLOOKUP, INDEX/MATCH and XLOOKUP
- VLOOKUP: find a matchThe most famous Excel function, explained simply.Premium
- Approximate match tablesGrade bands, tax brackets and commission tiers.Premium
- HLOOKUP: look acrossLike VLOOKUP, but for tables laid out horizontally.Premium
- INDEX & MATCHA more flexible lookup that can look left.Premium
- XLOOKUP: the modern waySimpler, safer and works in any direction.Premium
- Two-way lookupFind the value where a row and a column cross.Premium
Data tools
Pivot tables, charts, filters and cleaning
- Sort & filter dataOrder your data and see only what matters.Premium
- Pivot tables: the basicsSummarise thousands of rows in seconds.Premium
- Pivot tables: next levelAverages, percentages, grouping and slicers.Premium
- Conditional formattingMake important numbers jump out automatically.Premium
- Choosing the right chartPick a chart that tells the story clearly.Premium
- Data validation & drop-downsStop bad data before it gets in.Premium
- Clean messy data fastFlash Fill, Remove Duplicates and Text to Columns.Premium
- Tables, freeze panes & printingMake big sheets easier to read and share.Premium
Power features
Power Query, Solver, macros, validation and sharing
- Named rangesGive ranges readable names so formulas explain themselves.Premium
- Paste Special tricksPaste values, formats, widths, transposed data and quick maths.Premium
- Conditional formatting with formulasHighlight whole rows using your own TRUE/FALSE test.Premium
- Drop-downs & data validation, level upDependent lists, custom rules and friendly error messages.Premium
- Goal Seek & what-if analysisWork backwards from the result you want.Premium
- Scenarios & sensitivityCompare best, base and worst cases in one model.Premium
- Solver: optimise with constraintsFind the best mix when there are limits.Premium
- Power Query: import and clean dataRepeatable data cleaning that refreshes with one click.Premium
- Power Pivot & the Data ModelAnalyse millions of rows across related tables.Premium
- Macros & VBA basicsRecord repetitive steps and replay them with one key.Premium
- Sparklines, slicers & quick analysisTiny charts and one-click filters for dashboards.Premium
- Protect, share & collaborateLock formulas, co-author and track changes safely.Premium
- Tables, links & 3D referencesStructured references and formulas across sheets and files.Premium
Money maths
Margins, growth, loans, NPV and IRR
- Margins, markup & break-evenThe numbers every business owner needs.Premium
- Compound growth & CAGRSee how money, or anything, grows over time.Premium
- Loan payments with PMTWork out repayments before you sign.Premium
- NPV: is it worth it?Compare future cash with today’s money.Premium
- Saving for a goal with FVSee what regular deposits grow into.Premium
- Present value & payoff timeWhat a future sum is worth now, and how long a loan takes.Premium
- IRR: the return on a projectThe yearly return that makes NPV zero.Premium
- Budget variance analysisCompare actual against budget in dollars and percent.Premium
Real-world projects
Budget, sales report, gradebook and inventory
- Project: household budgetTotals, variances and flags on a real monthly budget.Premium
- Project: monthly sales reportRevenue by region, top rep and commission tiers.Premium
- Project: gradebookWeighted grades, bands, ranking and pass rates.Premium
- Project: inventory & reorderingStock alerts, restocking costs and stock value.Premium