Skip to content

Data analysis with Excel · Level 1 — Fundamentals

Data analysis with Excel — Level 1: Analysis & Business Data

Analysis & Business Data

5 intensive daysIn person, online or in-house

Programme content

  • M1 — Power Query: collecting, cleaning, combining and automating data (Excel, CSV, APIs)
  • M2 — Power Pivot & DAX: modelling, relationships, measures and advanced calculations
  • M3 — DataViz & dashboards: building professional dashboards

Expected outcomes

  • Automate the collection and cleaning of your data in Excel
  • Build a data model with DAX measures
  • Present a professional dashboard to your management

Hands-on case studies

Budget analysisSales trackingAdministrative reportingProject management

Who it is for

Accountants, managers, executive assistants, project leads — anyone who produces figures.