Course outline
What you will learn
1
Spreadsheet foundations
Navigate Excel with confidence, format data properly, and set up tables that are easy to work with.
2
Formulas and functions
Use SUM, IF, lookup, text and date functions to calculate and answer questions automatically.
3
PivotTables and charts
Summarise thousands of rows in seconds and present the results in clear charts.
4
Data cleaning with Power Query
Import messy data, remove duplicates, fix formats and refresh everything with one click.
5
Dashboards and reporting
Combine PivotTables, charts and slicers into interactive dashboards for decision makers.
6
Capstone project
Analyse a realistic business dataset from start to finish and present your findings.
Who it is for
- Office professionals who work with figures and reports
- Students and graduates preparing for the job market
- Small business owners managing sales and records
- Anyone who wants to stop doing repetitive work by hand
Before you start
- Basic computer skills (or take our Basic Computer Skills course first)
- A laptop with Microsoft Excel installed
- No prior Excel experience needed
Course fee
[PRICE] per learner
Group and corporate rates are available on request.
Explore our other courses