Curriculum

Excel Essentials — practised, not watched.

Ten hands-on lessons across five units, each mapped to the skills employers test. Every lesson is a real workbook with instant, specific feedback.

Start the free lessons

Unit 1 · Formulas from zero

Your first sales report

Write a formula, copy it down a column, and total it with SUM.

Free
6 min · 4 tasksWriting formulasRelative referencesFill handleSUM

Lock it with $

Use an absolute reference so a rate stays fixed when you copy a formula.

Free
6 min · 3 tasksAbsolute referencesFill handleCurrency format

Unit 2 · Essential functions

SUM, AVERAGE, MIN, MAX, COUNT

Summarise a week of orders with the five functions you'll use every day.

Free
7 min · 4 tasksSUMAVERAGEMIN & MAXCOUNT & COUNTA

Growth in percent

Calculate year-over-year growth and format it as a percentage.

Free
6 min · 3 tasksPercent changeFill handlePercent format

Unit 3 · Logic

IF: hit or miss

Make a formula decide between two outcomes based on a condition.

Free
8 min · 3 tasksIFFill handle

AND, OR & IFERROR

Combine conditions into real eligibility rules and handle errors gracefully.

Pro
10 min · 3 tasksAND & ORIFIFERROR

Unit 4 · Conditional aggregation

COUNTIF & SUMIF

Count and total only the rows that match a condition.

Free
9 min · 3 tasksCOUNTIFSUMIFAbsolute references

SUMIFS & COUNTIFS

Answer business questions that need two or more conditions at once.

Pro
9 min · 3 tasksSUMIFS & COUNTIFSAVERAGEIFS

Unit 5 · Lookup & text

XLOOKUP

Pull matching information from a table by ID — the modern way.

Pro
8 min · 3 tasksXLOOKUP

Clean messy text

Fix names and pull codes apart with TRIM, PROPER, MID and RIGHT.

Pro
9 min · 3 tasksTRIM & PROPERLEFT, MID & RIGHT

Curriculum

Zero to advanced, one skill at a time.

Twelve levels mapped to an explicit skill graph. Mastery is earned from repeated evidence — not just ticking off videos.

Browse the curriculum
  1. 0

    Orientation

    Cells & ranges · Formula bar · Fill handle

  2. 1

    Foundations

    Operators · Relative & absolute refs · Number formats

  3. 2

    Essential functions

    SUM · AVERAGE · MIN/MAX · COUNT

  4. 3

    Data handling

    Coming soon

    Sort & filter · Tables · Validation

  5. 4

    Logic

    IF · AND/OR · IFERROR

  6. 5

    Conditional aggregation

    SUMIF(S) · COUNTIF(S) · AVERAGEIFS

  7. 6

    Lookup & reference

    XLOOKUP · INDEX/MATCH · VLOOKUP

  8. 7

    Text & dates

    TRIM/PROPER · LEFT/MID/RIGHT · EOMONTH

  9. 8

    Dynamic arrays

    Coming soon

    FILTER · SORT · UNIQUE

  10. 9

    PivotTables & charts

    Coming soon

    Pivots · Slicers · Dashboards

  11. 10

    Advanced formulas

    Coming soon

    LET · LAMBDA · Auditing

  12. 11

    Analysis

    Coming soon

    Scenarios · Goal Seek · Sensitivity

Your first formula is 60 seconds away.

Free foundations. Real spreadsheets. Feedback on every keystroke that matters.

Start learning free