Microsoft Excel Power Query Course

Turn messy data into clean, reliable information.

Learn how to prepare data quickly and confidently with Excel Power Query.

Turn messy data into clean, reliable information. Learn how to prepare data quickly and confidently with Excel Power Query.

Microsoft Excel Power Query training course

Expert Trainers Experienced industry expert
Class Size 1–8 in person or 1–6 online
Support 28 days free helpdesk
Cancellation 7 day cancellation
Certificate Certificate of attendance
Volume Discounts Save with Learning Pots

Microsoft Excel Power Query Course

Our one-day Power Query training course provides a practical introduction to preparing data for analysis in Excel.

You'll learn how to import data from spreadsheets, CSV files, text files, websites and folders, then clean, restructure and transform it into a reliable dataset.

The course covers key Power Query features including removing and adding columns, splitting data, creating calculated columns, merging and appending datasets, and unpivoting data.

You'll also learn how to load data into Excel tables, create connections, work with the Data Model and refresh queries.

By the end of the day, you'll be able to prepare data quickly and confidently.

View course outline

Course Outline

Power Query Introduction

What Power Query is, and what it does

Understanding the Power Query interface

Connecting to different data sources

Overview of the import, transform and load process

Importing, loading and refreshing data

Finding and Importing Data

Importing data from Excel tables

Connecting to data in Excel workbooks

Importing CSV and text files

Extracting data from websites

Cleaning and Transforming Data

Removing unnecessary columns and rows

Adding new columns to datasets

Formatting and standardising data values

Replacing incorrect or unwanted content

Splitting data into separate fields

Creating calculated columns from existing data

Loading and Refreshing Data

Loading data into Excel tables

Creating connection-only queries

Adding data to the Data Model

Refreshing queries to update results

Additional Transformations

Merging data from multiple sources

Appending datasets into a single table

Unpivoting data for easier analysis

Who is this course for?

This course is ideal for anyone who wants a quicker way to clean and prepare in Excel for analysis. No Power Query experience is needed, but delegates should attend our Excel Intermediate course or have equivalent knowledge.