Module overview
Clean a sample data table, define the measures you want to report, and use spreadsheet formulas and pivot tables to validate the numbers. Build charts that explain changes and document what the data can support.
What you’ll learn
- Spreadsheet cleaning and validation
- Formulas, lookups and pivot tables
- Dashboard visualisations and reporting
- Present findings and document assumptions
Portfolio deliverables
An Excel workbook, a dashboard and a concise presentation of findings.
Practical assignment
Build a dashboard and present its findings.