Power Query – Basic

Power Query – Basic Level

This beginner-level course introduces Power Query, a powerful data transformation and automation tool available in Microsoft Excel. It is designed for analysts and Excel users who want to streamline data preparation tasks without using complex formulas or macros.

Learning Objectives

By the end of this course, participants will be able to:

• Import and combine data from various sources
• Perform essential data cleaning and transformation
• Automate repetitive steps using queries and parameters
• Create a basic data model using Power Pivot

Course Modules

• Module 1: Introduction to Power Query
• Module 2: Importing and Managing Data
• Module 3: Data Transformation Techniques
• Module 4: Automation and Parameters
• Module 5: Power Pivot Overview
• Module 6: Summary and Final Exercises