Microsoft Excel® Power Query

Description

This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will be proficient in importing, reshaping, merging, and automating your data workflows, allowing you to work more efficiently and effectively with large datasets. You will also be able to create repeatable data processes that can be refreshed with ease, saving you time and effort.

Learning Objectives:

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

Understand what Power Query is and when to use it

Connect to and import data from various sources

Clean, reshape, and transform data

Combine data from multiple tables/files

Automate data preparation steps

Load data into Excel for analysis

Target Audience:

Excel users who regularly work with data

Analysts, accountants, project managers, and admin staff

Anyone who wants to automate and streamline data cleaning

Introduction
Overview of the workbook and course objectives
Section 1: Power Query Overview

Introduction to Power Query and its key benefits
Accessing Power Query in Excel
Comparison between Power Query and manual Excel methods
Section 2: Data Cleaning & Transformation
Tools and concepts for cleaning and transforming data
Common data cleaning tasks
Section 3: Combining Data
Merging and appending queries
Practical example of combining data from multiple sources
Section 4: Advanced Techniques & Automation
Creating custom columns
Grouping data
Using parameters for dynamic queries
Automating data refresh
Optimizing Power Query performance