Skip to content

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

Beginner

Cells, formulas, copying, SUM and formatting — on realistic office data from the first minute.

Your first sales report

Free

Write a formula, copy it down a column, total it with SUM and make it read like money.

8 min · 6 tasks

Cells, rows & columns

Free

Find your way around a sheet: cell addresses, entering and editing values, and clearing mistakes.

6 min · 6 tasks

Arithmetic & order of operations

Free

Add, 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

Free

Write one formula, copy it down and across a timesheet, and see how relative references adjust.

8 min · 5 tasks

SUM and AutoSum

Free

Total 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

Free

Make numbers read correctly — money, percentages, thousands and dates — without changing their values.

8 min · 6 tasks

Make a report readable

Free

Turn a raw table into a clean monthly summary: headers, money, percentages and a totals row.

7 min · 5 tasks

Build a worksheet from scratch

Free

Plan 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

Beginner

AVERAGE, MIN, MAX, COUNT, rounding, percentages, growth and variance — the everyday toolkit.

SUM, AVERAGE, MIN, MAX, COUNT

Free

Summarise 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

Members

Audit an onboarding tracker: how many people, how many records are complete, and what's missing.

7 min · 5 tasks

ROUND, ROUNDUP & ROUNDDOWN

Members

Set clean prices, ship whole boxes and quote round numbers — choosing the right rounding for each job.

9 min · 6 tasks

Percentages: shares, discounts & tax

Members

Work 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

Free

Calculate 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

Members

Calculate 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

Beginner

Relative, absolute and mixed references, reusable assumptions and fixing broken formulas.

Lock it with $

Members

Use 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

Members

Choose 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

Members

Fill an entire price-by-quantity grid and a discounted quote grid from a single mixed-reference formula.

10 min · 5 tasks

Reusable assumptions

Members

Drive a quarterly forecast from one block of assumptions, so a single change updates the whole model.

12 min · 6 tasks

Debug broken formulas

Members

Find and fix the six classic spreadsheet bugs in an inherited commission report.

12 min · 6 tasks

Course 4

Logic & Error Handling

Intermediate

IF, nested tiers, AND / OR / NOT and IFERROR for real eligibility and status rules.

IF: hit or miss

Free

Make formulas decide: target status, bonuses, shortfalls and next steps for a sales team.

10 min · 5 tasks

IF with calculations: payroll & shipping

Members

Split regular and overtime pay, apply free-shipping thresholds and keep blank rows blank.

12 min · 5 tasks

Tiers with nested IF and IFS

Members

Grade 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

Members

Combine conditions into real hiring rules and handle errors gracefully.

12 min · 5 tasks

Business rules: salary review eligibility

Members

Turn 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

Intermediate

COUNTIF(S), SUMIF(S) and AVERAGEIF(S) on tables big enough that formulas matter.

COUNTIF & SUMIF

Free

Count 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

Members

Use operators, cell-driven thresholds, wildcards, blanks and dates as criteria on a support-ticket log.

12 min · 7 tasks

SUMIFS & COUNTIFS

Members

Answer business questions that need two, three or a date range of conditions at once.

12 min · 6 tasks

AVERAGEIF(S), MAXIFS & MINIFS

Members

Analyse pay by department, level and location — the questions every HR business partner gets asked.

12 min · 7 tasks

Build a two-way summary table

Members

Turn 36 orders into a region × category revenue grid, an order-count grid and average order values.

15 min · 6 tasks

Course 6

Lookups & Relationships

Intermediate

XLOOKUP, VLOOKUP and INDEX/MATCH — exact, approximate and error-proof lookups across tables.

XLOOKUP

Members

Pull matching information from a 30-person employee table by ID — forwards, backwards and safely.

12 min · 6 tasks

VLOOKUP (and why FALSE matters)

Members

Price an order list from a product catalog with VLOOKUP, fix an approximate-match bug and learn its limits.

12 min · 5 tasks

INDEX & MATCH

Members

Find 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

Members

Diagnose #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

Members

Use approximate-match lookups for commission bands, shipping weights and grade scales — the right way.

12 min · 5 tasks

Combine tables

Members

Join 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

Intermediate

Clean, split and rebuild messy employee and customer data with text functions.

Clean messy text

Members

Fix 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

Members

Standardise 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

Members

Split structured SKUs into category, item, number and market — and turn the number back into a real number.

11 min · 7 tasks

FIND, SEARCH & SUBSTITUTE

Members

Split “Last, First” names, pull email domains, strip phone formatting and flag urgent notes.

14 min · 5 tasks

Build text: &, CONCAT, TEXTJOIN & TEXT

Members

Create full names, email addresses, padded employee codes and readable summary sentences from separate fields.

12 min · 5 tasks

Course 8

Dates & Time

Intermediate

Date arithmetic, month ends, working days, invoice aging and length of service.

Dates are numbers

Members

Calculate durations, follow-up dates, days remaining and overdue flags on a project tracker.

10 min · 5 tasks

YEAR, MONTH, DAY & DATE

Members

Break transaction dates into years, months, quarters and weekdays, rebuild month starts and report by month.

12 min · 7 tasks

TODAY & invoice aging

Members

Build an accounts-receivable aging report: days overdue, aging buckets and outstanding totals.

14 min · 5 tasks

EOMONTH, EDATE & working days

Members

Set payment due dates, renewal dates and working-day deadlines the way finance and operations teams do.

13 min · 5 tasks

Tenure & service periods

Members

Calculate length of service in years and months, assign service bands and find upcoming anniversaries.

13 min · 6 tasks

Course 9

Data Analysis & Reporting

Advanced

Sort, filter, validate, rank and chart data — then turn it into KPIs a manager can act on.

Sort data

Members

Sort 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

Members

Filter 36 orders by region and category, and use SUBTOTAL so totals follow what's visible.

12 min · 6 tasks

Data validation & dropdowns

Members

Stop 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

Members

Turn 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

Members

Rank a sales team, pull the top three names and values, and flag who is above average.

13 min · 5 tasks

Chart your results

Members

Summarise 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

Advanced

Mixed-skill challenges that combine logic, lookups, dates, text and conditional analysis.

Commission plan with multiple rules

Members

Apply a real commission plan: attainment tiers, role multipliers, an accelerator bonus and a payout cap.

18 min · 7 tasks

Weekly payroll check

Members

Run 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

Members

Combine customer lookups, payment terms, date maths and SUMIFS into a month-end aging report.

20 min · 7 tasks

Clean and match two systems

Members

Reconcile 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

Members

Drive 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.

Browse the curriculum
  1. 1

    Excel Foundations

    Beginner8 lessons

    Cells, formulas, copying, SUM and formatting — on realistic office data from the first minute.

  2. 2

    Essential Functions

    Beginner6 lessons

    AVERAGE, MIN, MAX, COUNT, rounding, percentages, growth and variance — the everyday toolkit.

  3. 3

    References & Formula Control

    Beginner5 lessons

    Relative, absolute and mixed references, reusable assumptions and fixing broken formulas.

  4. 4

    Logic & Error Handling

    Intermediate5 lessons

    IF, nested tiers, AND / OR / NOT and IFERROR for real eligibility and status rules.

  5. 5

    Conditional Aggregation

    Intermediate5 lessons

    COUNTIF(S), SUMIF(S) and AVERAGEIF(S) on tables big enough that formulas matter.

  6. 6

    Lookups & Relationships

    Intermediate6 lessons

    XLOOKUP, VLOOKUP and INDEX/MATCH — exact, approximate and error-proof lookups across tables.

  7. 7

    Text & Data Cleaning

    Intermediate5 lessons

    Clean, split and rebuild messy employee and customer data with text functions.

  8. 8

    Dates & Time

    Intermediate5 lessons

    Date arithmetic, month ends, working days, invoice aging and length of service.

  9. 9

    Data Analysis & Reporting

    Advanced6 lessons

    Sort, filter, validate, rank and chart data — then turn it into KPIs a manager can act on.

  10. 10

    Advanced Workplace Excel

    Advanced5 lessons

    Mixed-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