Stop relying on complex VBA and manual formulas—automate your data transformation workflows with the industry-standard tool for Excel and Power BI.
This course provides a comprehensive guide to using Power Query as a primary tool for data transformation, cleaning, and automation. It covers the transition from unstructured raw data sources to structured models, emphasizing the use of the M language, query optimization, and advanced data manipulation techniques. Learners will explore the differences between Power Query implementations in Excel and Power BI, including connector availability, AI insights, and query diagnostics. The curriculum focuses on building efficient, repeatable scripts that replace traditional manual processes and complex VBA programming.
12 activities • 67 videos • duration: 7h 59m

Power BI Consultant & Trainer
Microsoft Certified Trainer (MCT), Power Platform advisor and FMCG business consultant. For 10+ years I worked daily with Microsoft data tools across 70+ system implementations on Power BI, Fabric, Analysis Services and the Power Platform. Deep expertise in Power BI positioning, DAX and M programming, and data modeling - and an early adopter of AI/LLMs in modern data stacks.
Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.