Power Query Professional – Batch 1

Most professionals still spend hours every month cleaning Excel data, fixing formats, and manually updating the same reports again and again.

That’s exactly what this program was built to solve.

Power Query Professional – Batch 1 was a 5-session live paid training designed for working professionals who want to move beyond manual Excel work and start building automated, refreshable reporting systems.

Whether you work in finance, supply chain, sales, or operations — this program gave you the practical skills to work smarter, not harder.

What You Learned in This Program

🔷 Automate repetitive Excel and finance processes using Power Query
🔷 Transform raw data into clean, structured datasets ready for analysis
🔷 Merge and append data from multiple sources into one master table
🔷 Build refreshable reports and dashboards that update in one click
🔷 Write basic M code to customize your transformations
🔷 Create a real finance ETL pipeline from scratch

Program Details

📅 Duration — May 2 to May 24, 2025
🎓 Sessions — 5 live sessions, 2 to 2.5 hours each
👥 Format — Paid live training cohort
🎯 Audience — Finance professionals, analysts, Excel users, ACCA and CA students

Session Breakdown

📌 Session 01 — Power Query Foundations
Understanding what Power Query is, where it lives, connecting to Excel and CSV files, navigating the Query Editor, and understanding Applied Steps logic.

📌 Session 02 — Data Cleaning & Transformation
Removing errors, blanks and duplicates, fixing data types for finance data, splitting and trimming columns, and building conditional columns with real examples.

📌 Session 03 — Merging & Appending Queries
Stacking monthly reports using Append, joining GL with budget data using Merge, understanding join types simply, and building a master finance table.

📌 Session 04 — Advanced Transformations & M Code
Unpivoting and pivoting data for reporting, creating Group By summary tables, introduction to M language, and building dynamic date and parameter queries.

📌 Session 05 — Automation & Real-World Capstone Project
Auto-refreshing data from a folder, building a repeatable ETL pipeline, completing a live finance dashboard as a capstone, and Q&A with next steps.