Module 02
Excel — Formulas & Functions
The working core of Excel. Lookups, conditions, text, dates and error-hunting: the functions that appear in almost every real workbook.
7 topics ~28 h estimated learning time
Comes after01. Excel — First Steps
Unlocks03. Excel — Analysis
Sign in to keep your progress.
Ready to start
- 2.1 Relative, absolute and mixed references
Core · 3 h
- 2.2 IF and the logical family
Core · 4 h
- 2.3 Lookups: XLOOKUP, INDEX/MATCH and VLOOKUP
Core · 5 h
- 2.4 Counting and summing with conditions
Core · 4 h
- 2.5 Text functions and cleaning up strings
Core · 4 h
- 2.6 Dates and time arithmetic
Core · 4 h
- 2.7 Errors, auditing and trusting a spreadsheet
Core · 4 h