Skill path · BeginnerNew
Excel Foundations and Formula Fluency
Practise references, summaries and lookups, then reconcile a sales file.
Native Excel tables, pivots and charts are self-reviewed labs.
27 exercises · 3 h · 56 checked cells
6 of 27 exercises free, no account needed.
Before you start
Know Financial Numeracy and Business Economics first. You build: A formula-driven sales report with a traceable source and explicit lookup exceptions.
About 3 h; full access adds 21 exercises.
Loading the spreadsheet…
The route
- 1Find your way around a worksheetWorksheet and formula foundations3 exercises · 21 minFree
- 2Copy formulas without moving the wrong inputWorksheet and formula foundations3 exercises · 21 minFree
- 3Calculate, make a decision and expose errorsWorksheet and formula foundations3 exercises · 21 minFull access
- 4Summarize the rows that answer your questionSummaries, lookups and source types3 exercises · 21 minFull access
- 5Look up a value without trusting an ambiguous keySummaries, lookups and source types3 exercises · 21 minFull access
- 6Turn text and dates into dependable inputsSummaries, lookups and source types3 exercises · 21 minFull access
- 7Build an expandable, readable reportNative Excel and the sales case3 exercises · 21 minFull access
- 8Sort, pivot and chart in native ExcelNative Excel and the sales case3 exercises · 21 minFull access
- 9Case: turn an unfamiliar sales file into a checked reportNative Excel and the sales case3 exercises · 36 minFull access
What it ends in
A FinX certificate of completion, which anyone can verify by link.
Questions
- How long does Excel Foundations and Formula Fluency take?
- About 3 h: 27 exercises in 9 lessons, with 56 checked cells between them. Times are estimates from writing the lessons.
- What can I do for free?
- 6 of the 27 exercises are free, with no account: Find your way around a worksheet and Copy formulas without moving the wrong input. Full access opens the rest.
- Do I need Excel installed?
- No. Every exercise runs in a spreadsheet in your browser, and each answer is checked cell by cell, so you see exactly which cell is wrong.
- What do I get at the end?
- A FinX certificate of completion, which anyone can verify by link.