What You'll Learn

  • Advanced formulas: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH
  • Pivot tables, pivot charts, and data summarisation
  • Power Query for data cleaning and transformation
  • Data modelling with proper table structures and relationships
  • Creating professional dashboards and reports
  • Conditional formatting and data validation
  • Financial analysis and what-if scenarios

Course Modules

1

Excel Fundamentals & Advanced Formulas

Master Excel basics and advance to VLOOKUP, XLOOKUP, and complex formula construction.

2

Pivot Tables & Data Summarisation

Create pivot tables, pivot charts, and learn to slice and dice data for analysis.

3

Power Query & Data Transformation

Clean, transform, and load data from multiple sources using Power Query.

4

Dashboard Design & Visualisation

Build interactive dashboards and compelling visual reports for stakeholders.

Tools & Technologies

Microsoft Excel
Power Query
Data Model
Google Sheets

Career Relevance

Data Analyst

Essential for creating reports, dashboards, and presenting insights to business stakeholders.

Data Scientist

Useful for exploratory data analysis and quick data visualisations.

Data Engineer

Helpful for understanding end-user needs and data validation workflows.

Prerequisites

  • Basic familiarity with Excel (opening files, entering data)
  • Access to Microsoft Excel 365 or latest version
  • Windows or Mac computer with internet connection
  • No programming experience required

Ready to Master Excel?

Get access to this course, plus 13 more professional data & AI courses.

Get access for $34