In this hands-on bootcamp, you’ll learn Power Query — the ETL engine inside both Excel and Power BI — through step-by-step exercises with real files.

Who is this course for?

=> Excel and Power BI users who want to streamline data preparation

=> Business analysts, finance professionals and data enthusiasts looking to reduce manual cleaning steps

=> Beginners with basic Excel or Power BI familiarity who want to build repeatable data flows

=> Anyone interested in learning practical ETL concepts without traditional coding

What to expect

You’ll work with sample datasets and clear, guided exercises that take you from importing raw files to delivering a reusable, refreshable output. The focus is on understanding why each transformation is needed and how to build queries that remain reliable when new data arrives.

You will learn to:

=> Understand the ETL flow: Connect, Transform and Load data

=> Navigate the Power Query interface, query settings and applied steps

=> Import data from Excel, CSV and folders and choose appropriate load options

=> Clean messy datasets by handling blanks, standardising data types and removing duplicates

=> Reshape data with pivot, unpivot, Group By, conditional columns and custom columns

=> Combine tables with append and merge operations and understand common join types

=> Build a reusable calendar table and make basic M-code adjustments

=> Complete a mini project that combines monthly sales files, enriches them with product attributes and delivers a refreshable result in Excel or Power BI

Prerequisites: Basic Excel or Power BI skills, such as entering data, using simple formulas and sorting, are helpful. No VBA or programming knowledge is required. Bring Excel 365 or Power BI Desktop and a willingness to learn.

Additionally Included

✓ Private live 1:1 session

✓ Worked examples

✓ Questions based on your reporting context

✓ Follow-up summary

✓ Practice dataset

Ready to EXCELIZE your workflow and learn something new? Then check this handout before enrolment.