International Knowledge Skills and Research Organization programm
MBA-Fi Curriculum

Module 6 · 15 hours

Excel, Data Analytics & Dashboards

Excel formulas, data cleaning, charts, reporting and PowerPoint.

Apply for MBA-Fi

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

  1. Spreadsheet cleaning and validation
  2. Formulas, lookups and pivot tables
  3. Dashboard visualisations and reporting
  4. 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.

Tools you’ll use

Apply for MBA-Fi