Skip to content

All-Access: every lesson, no ads. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41 a month, billed yearly. Free to start. Cancel any time

See plans
All-Access, no ads: every lesson, course and template. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41 a month.See the plans →
Foundations
Band 1 · FoundationsEssentials exam 1 of 4

The Foundations exam

Questions from every Foundations module, none of them seen in a lesson. Pass it for the Foundations certificate, a record of what you can do.

  • Every question is worked on its own module's workbook, like real work.
  • Marked on the result, so any correct formula counts.
  • Nothing teaches during it. Trust what you have practised.
One moment...
What it covers

5 modules. One paper.

01
The WorksheetWorkbook, worksheet, cell: how Excel stores what you see · Entering, editing and filling data · Data types: text, number, date, boolean · Navigating and selecting at speed
Workbook, worksheet, cell: how Excel stores what you see · Entering, editing and filling data · Data types: text, number, date, boolean · Navigating and selecting at speed4 lessons
02
Formula FoundationsWriting your first formulas · Order of operations and parentheses · Relative references and copying · Absolute and mixed references
Writing your first formulas · Order of operations and parentheses · Relative references and copying · Absolute and mixed references4 lessons
03
Named ReferencesCreating and scoping names · Using names in formulas · Name Manager and auditing names · Table names and structured references
Creating and scoping names · Using names in formulas · Name Manager and auditing names · Table names and structured references4 lessons
04
PresentationNumber and date formatting · Worksheet formatting and cell styles · Custom number formats · Printing and page setup
Number and date formatting · Worksheet formatting and cell styles · Custom number formats · Printing and page setup4 lessons
05
Structure and SafetyConverting ranges to Tables · Data validation rules · Protecting cells and sheets · Workbook design: inputs, calculations, outputs
Converting ranges to Tables · Data validation rules · Protecting cells and sheets · Workbook design: inputs, calculations, outputs4 lessons
F1Foundations
What a pass gets you

A Foundations certificate with your name, score and date.

It is one of 4. Pass all 4 Essentials exams and you get the Essentials Certificate.

See your certificates