About the Course
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 data cleaning steps
=> Beginners with basic familiarity of Excel/Power BI who want to build repeatable data flows
=> Anyone interested in learning ETL concepts without coding
What to expect
This 4–5 hour bootcamp takes you from zero to hero with hands‑on practice, sample datasets and clear explanations.
You will learn to:
=> Understand the ETL flow: Connect, Transform and Load data
=> Navigate the Power Query interface and applied steps
=> Import data from Excel, CSV and folders and choose the right load options
=> Clean messy datasets (handle blanks, standardize data types, remove duplicates)
=> Reshape data with pivot/unpivot, Group By, conditional and custom columns
=> Combine tables with append and merge operations, understanding join types
=> Build a reusable calendar table and perform basic M code tweaks
=> Complete a mini project that combines monthly sales data, enriches it with product attributes, and delivers a refreshable report in Excel or Power BI.
Prerequisites: Basic Excel or Power BI skills (entering data, simple formulas, sorting). No VBA or programming knowledge required. Just Excel 365, Power BI desktop and a willingness to learn something new.
Included: Practice dataset, full slide deck, and reusable .pbix/Excel template file.
Ready to EXCELIZE your workflow and learn something new? Then check this handout before enrolment.
Your Instructor
Mirzet Velagić
