← Training
AdultsALL LEVELSONLINE LIVE
Spreadsheets for Business
6 weeks • 2 sessions/week • 60 min/session
Free
The spreadsheet skills that actually come up in running a business: pricing, cash flow, stock, payroll summaries and the monthly report. Built around real business questions rather than a tour of every menu.
What you'll learn
- Write formulas that stay correct when the sheet grows
- Use lookups to combine data from different sheets
- Build a pivot table and read it correctly
- Produce charts that make a point rather than decorate
- Build a cash flow and a pricing model you keep using
- Protect a sheet so other people cannot break it
Curriculum
Module 1: Formulas that hold up
References, named ranges, conditional logic and error handling.
- 1.1 Absolute and relative referencesLIVE SESSION · 60 min · Free preview
- 1.2 Named ranges and tidy layoutsPRACTICAL · 45 min
- 1.3 IF, IFS and conditional logicPRACTICAL · 45 min
- 1.4 Handling errors with IFERRORPRACTICAL · 45 min
- 1.5 Formulas checkQUIZ · 15 min
- 1.6 Assignment: pricing sheetASSIGNMENT
Module 2: Combining and summarising
Lookups, pivot tables and reconciling two sources.
- 2.1 XLOOKUP and VLOOKUPLIVE SESSION · 60 min
- 2.2 Pivot tables and reading them correctlyPRACTICAL · 45 min
- 2.3 Reconciling two lists
Tracks
Formulas that hold up
2 weeks
References, named ranges, conditional logic and error handling.
Combining and summarising
2 weeks
Lookups, pivot tables and reconciling two sources.
Models and reporting
2 weeks
Cash flow, pricing, charts and a monthly report that builds itself.