Power Query – Basic: Difference between revisions
Jump to navigation
Jump to search
Created page with "{{Cat|Power Query|001}} = 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 dat..." |
|||
| Line 13: | Line 13: | ||
== Course Modules == | == Course Modules == | ||
* [[Power Query – Introduction|Module 1: Introduction to Power Query]] | * [[Power Query – Introduction|Module 1: Introduction to Power Query]] | ||
* [[Power Query – Importing Data|Module 2: Importing and Managing Data]] | * [[Power Query – Importing and Managing Data|Module 2: Importing and Managing Data]] | ||
* [[Power Query – Data Transformation|Module 3: Data Transformation Techniques]] | * [[Power Query – Data Transformation|Module 3: Data Transformation Techniques]] | ||
* [[Power Query – Automation and Parameters|Module 4: Automation and Parameters]] | * [[Power Query – Automation and Parameters|Module 4: Automation and Parameters]] | ||
* [[Power Query – Power Pivot Overview|Module 5: Power Pivot Overview]] | * [[Power Query – Power Pivot Overview|Module 5: Power Pivot Overview]] | ||
* [[Power Query – Summary and Exercises|Module 6: Summary and Final Exercises]] | * [[Power Query – Summary and Exercises|Module 6: Summary and Final Exercises]] | ||
Latest revision as of 17:48, 18 June 2025
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
