Power Query – Basic

From Training Material
Jump to navigation Jump to search

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