Curriculum
Beginner to advanced Excel — practised, not watched.
10 courses, 56 lessons and 326 graded tasks, each mapped to the skills employers test. Every lesson is a real workbook with instant, specific feedback.
Course 1
Excel Foundations
BeginnerCells, formulas, copying, SUM and formatting — on realistic office data from the first minute.
Your first sales report
FreeWrite a formula, copy it down a column, total it with SUM and make it read like money.
8 min · 6 tasks
Cells, rows & columns
FreeFind your way around a sheet: cell addresses, entering and editing values, and clearing mistakes.
6 min · 6 tasks
Arithmetic & order of operations
FreeAdd, subtract, multiply and divide with cell references — and use brackets so Excel calculates in the right order.
8 min · 6 tasks
Copy formulas with the fill handle
FreeWrite one formula, copy it down and across a timesheet, and see how relative references adjust.
8 min · 5 tasks
SUM and AutoSum
FreeTotal rows, columns, several ranges and a whole block with SUM — and let AutoSum write it for you.
8 min · 6 tasks
Number, currency & percent formats
FreeMake numbers read correctly — money, percentages, thousands and dates — without changing their values.
8 min · 6 tasks
Make a report readable
FreeTurn a raw table into a clean monthly summary: headers, money, percentages and a totals row.
7 min · 5 tasks
Build a worksheet from scratch
FreePlan a team offsite budget end to end: enter inputs, write formulas, total it and work out the cost per person.
9 min · 6 tasks
Course 2
Essential Functions
BeginnerAVERAGE, MIN, MAX, COUNT, rounding, percentages, growth and variance — the everyday toolkit.
SUM, AVERAGE, MIN, MAX, COUNT
FreeSummarise a week of store orders with the functions you'll use every day — and see why MEDIAN exists.
9 min · 6 tasks
Completeness checks: COUNT, COUNTA, COUNTBLANK
MembersAudit an onboarding tracker: how many people, how many records are complete, and what's missing.
7 min · 5 tasks
ROUND, ROUNDUP & ROUNDDOWN
MembersSet clean prices, ship whole boxes and quote round numbers — choosing the right rounding for each job.
9 min · 6 tasks
Percentages: shares, discounts & tax
MembersWork out a channel's share, apply a discount and VAT on an invoice, and back out a pre-tax price.
8 min · 6 tasks
Growth in percent
FreeCalculate year-over-year growth by region and for the whole company, then set next year's target.
8 min · 5 tasks
Variance: budget vs actual
MembersCalculate variance in dollars and percent, find the biggest misses with ABS, MAX and MIN, and forecast the year.
10 min · 6 tasks
Course 3
References & Formula Control
BeginnerRelative, absolute and mixed references, reusable assumptions and fixing broken formulas.
Lock it with $
MembersUse absolute references so commission and bonus rates stay fixed when you copy formulas.
9 min · 6 tasks
A1, $A$1, A$1, $A1: the F4 cycle
MembersChoose between relative, absolute and mixed references — and fix a formula that locked the wrong thing.
12 min · 6 tasks
Build a rate table with one formula
MembersFill an entire price-by-quantity grid and a discounted quote grid from a single mixed-reference formula.
10 min · 5 tasks
Reusable assumptions
MembersDrive a quarterly forecast from one block of assumptions, so a single change updates the whole model.
12 min · 6 tasks
Debug broken formulas
MembersFind and fix the six classic spreadsheet bugs in an inherited commission report.
12 min · 6 tasks
Course 4
Logic & Error Handling
IntermediateIF, nested tiers, AND / OR / NOT and IFERROR for real eligibility and status rules.
IF: hit or miss
FreeMake formulas decide: target status, bonuses, shortfalls and next steps for a sales team.
10 min · 5 tasks
IF with calculations: payroll & shipping
MembersSplit regular and overtime pay, apply free-shipping thresholds and keep blank rows blank.
12 min · 5 tasks
Tiers with nested IF and IFS
MembersGrade support agents into bands, assign bonuses by grade, and fix a nested IF that tests in the wrong order.
12 min · 6 tasks
AND, OR & IFERROR
MembersCombine conditions into real hiring rules and handle errors gracefully.
12 min · 5 tasks
Business rules: salary review eligibility
MembersTurn an HR policy into formulas with AND, OR and NOT — eligibility, increase %, approvals and a budget check.
15 min · 7 tasks
Course 5
Conditional Aggregation
IntermediateCOUNTIF(S), SUMIF(S) and AVERAGEIF(S) on tables big enough that formulas matter.
COUNTIF & SUMIF
FreeCount and total only the rows that match — then build a region summary that reconciles to the total.
11 min · 6 tasks
Criteria like a pro
MembersUse operators, cell-driven thresholds, wildcards, blanks and dates as criteria on a support-ticket log.
12 min · 7 tasks
SUMIFS & COUNTIFS
MembersAnswer business questions that need two, three or a date range of conditions at once.
12 min · 6 tasks
AVERAGEIF(S), MAXIFS & MINIFS
MembersAnalyse pay by department, level and location — the questions every HR business partner gets asked.
12 min · 7 tasks
Build a two-way summary table
MembersTurn 36 orders into a region × category revenue grid, an order-count grid and average order values.
15 min · 6 tasks
Course 6
Lookups & Relationships
IntermediateXLOOKUP, VLOOKUP and INDEX/MATCH — exact, approximate and error-proof lookups across tables.
XLOOKUP
MembersPull matching information from a 30-person employee table by ID — forwards, backwards and safely.
12 min · 6 tasks
VLOOKUP (and why FALSE matters)
MembersPrice an order list from a product catalog with VLOOKUP, fix an approximate-match bug and learn its limits.
12 min · 5 tasks
INDEX & MATCH
MembersFind positions with MATCH, return values with INDEX, then combine them into two-way lookups on a sales matrix.
12 min · 5 tasks
Handle missing matches
MembersDiagnose #N/A — missing IDs, stray spaces and numbers stored as text — and fix or label each one.
12 min · 5 tasks
Tiered lookups: bands & brackets
MembersUse approximate-match lookups for commission bands, shipping weights and grade scales — the right way.
12 min · 5 tasks
Combine tables
MembersJoin an order log to customer and price tables, apply a discount by customer type and summarise by region.
15 min · 6 tasks
Course 7
Text & Data Cleaning
IntermediateClean, split and rebuild messy employee and customer data with text functions.
Clean messy text
MembersFix names, normalise department codes and pull invoice codes apart with TRIM, PROPER, UPPER, MID, RIGHT and LEN.
11 min · 5 tasks
Clean a customer list
MembersStandardise names, emails, postcodes and notes, then spot duplicates that only differed by case and spacing.
12 min · 5 tasks
Extract codes with LEFT, MID, RIGHT & LEN
MembersSplit structured SKUs into category, item, number and market — and turn the number back into a real number.
11 min · 7 tasks
FIND, SEARCH & SUBSTITUTE
MembersSplit “Last, First” names, pull email domains, strip phone formatting and flag urgent notes.
14 min · 5 tasks
Build text: &, CONCAT, TEXTJOIN & TEXT
MembersCreate full names, email addresses, padded employee codes and readable summary sentences from separate fields.
12 min · 5 tasks
Course 8
Dates & Time
IntermediateDate arithmetic, month ends, working days, invoice aging and length of service.
Dates are numbers
MembersCalculate durations, follow-up dates, days remaining and overdue flags on a project tracker.
10 min · 5 tasks
YEAR, MONTH, DAY & DATE
MembersBreak transaction dates into years, months, quarters and weekdays, rebuild month starts and report by month.
12 min · 7 tasks
TODAY & invoice aging
MembersBuild an accounts-receivable aging report: days overdue, aging buckets and outstanding totals.
14 min · 5 tasks
EOMONTH, EDATE & working days
MembersSet payment due dates, renewal dates and working-day deadlines the way finance and operations teams do.
13 min · 5 tasks
Tenure & service periods
MembersCalculate length of service in years and months, assign service bands and find upcoming anniversaries.
13 min · 6 tasks
Course 9
Data Analysis & Reporting
AdvancedSort, filter, validate, rank and chart data — then turn it into KPIs a manager can act on.
Sort data
MembersSort a sales team by revenue, region, hire date and name — and build a running total that follows the order.
11 min · 6 tasks
Filter & SUBTOTAL
MembersFilter 36 orders by region and category, and use SUBTOTAL so totals follow what's visible.
12 min · 6 tasks
Data validation & dropdowns
MembersStop bad data at the door with dropdown lists, then use a dropdown as the selector for a live report.
11 min · 5 tasks
Business KPIs
MembersTurn a marketing funnel into conversion rates, average order value, CAC, ROAS and growth — and find the best month.
14 min · 7 tasks
Rank, LARGE & SMALL: top performers
MembersRank a sales team, pull the top three names and values, and flag who is above average.
13 min · 5 tasks
Chart your results
MembersSummarise orders by region, month and category, then pick and build the right chart for each question.
13 min · 6 tasks
Course 10
Advanced Workplace Excel
AdvancedMixed-skill challenges that combine logic, lookups, dates, text and conditional analysis.
Commission plan with multiple rules
MembersApply a real commission plan: attainment tiers, role multipliers, an accelerator bonus and a payout cap.
18 min · 7 tasks
Weekly payroll check
MembersRun a weekly payroll: look up pay rates, total hours, split overtime, apply tax bands and reconcile by department.
18 min · 8 tasks
Accounts receivable aging report
MembersCombine customer lookups, payment terms, date maths and SUMIFS into a month-end aging report.
20 min · 7 tasks
Clean and match two systems
MembersReconcile a messy CRM export against the billing system: clean the keys, match records and size the gap.
18 min · 6 tasks
Build a one-cell interactive report
MembersDrive a whole summary from two dropdowns: totals, counts, averages, share of total and top product.
18 min · 7 tasks
Curriculum
Zero to advanced, one skill at a time.
10 courses and 56 hands-on lessons mapped to the skills employers test. Mastery is earned from repeated, independent evidence — not from ticking off videos.
- 1
Excel Foundations
Beginner8 lessonsCells, formulas, copying, SUM and formatting — on realistic office data from the first minute.
- 2
Essential Functions
Beginner6 lessonsAVERAGE, MIN, MAX, COUNT, rounding, percentages, growth and variance — the everyday toolkit.
- 3
References & Formula Control
Beginner5 lessonsRelative, absolute and mixed references, reusable assumptions and fixing broken formulas.
- 4
Logic & Error Handling
Intermediate5 lessonsIF, nested tiers, AND / OR / NOT and IFERROR for real eligibility and status rules.
- 5
Conditional Aggregation
Intermediate5 lessonsCOUNTIF(S), SUMIF(S) and AVERAGEIF(S) on tables big enough that formulas matter.
- 6
Lookups & Relationships
Intermediate6 lessonsXLOOKUP, VLOOKUP and INDEX/MATCH — exact, approximate and error-proof lookups across tables.
- 7
Text & Data Cleaning
Intermediate5 lessonsClean, split and rebuild messy employee and customer data with text functions.
- 8
Dates & Time
Intermediate5 lessonsDate arithmetic, month ends, working days, invoice aging and length of service.
- 9
Data Analysis & Reporting
Advanced6 lessonsSort, filter, validate, rank and chart data — then turn it into KPIs a manager can act on.
- 10
Advanced Workplace Excel
Advanced5 lessonsMixed-skill challenges that combine logic, lookups, dates, text and conditional analysis.
Your first formula is 60 seconds away.
Free foundations. Real spreadsheets. Feedback on every keystroke that matters.
Start learning free