Microsoft Excel Power Query Course

Turn messy data into clean, reliable information.

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

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.

One Day

10:00 - 16:30 UK Time

Private Options

Key Learning Points

Key Learning Points
Import data from multiple sources
Clean up messy data quickly
Reshape data for easier analysis
Combine and organise different datasets
Load and refresh data with confidence

If attending an online course you must have a licensed copy of any software required and access to a suitable computer.

You'll need to have attended our Excel Intro and Intermediate courses or have equivalent working knowledge before joining this class. This course isn't suitable for Mac users.

Microsoft Excel : Intermediate

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.

Expert Trainers

Course leader is an experienced industry expert

Class Size

1 - 10 in person or 1 - 6 online

Support

28 days free helpdesk support with all courses

Cancellation

Cancel before 7 days for 100% refund

Certificate

Earn a certificate of attendance on completion

Volume Discounts

Save money by using our Learning Pots scheme

Private & team training. This course is not on our public schedule at the moment. You can still request a bespoke quote below — we’ll contact you with dates and pricing.

Request a quote for Microsoft Excel : Power Query

This course is offered as private, bespoke or team training at our centre, live online or at your venue.

You can customise the outline, have a group where it's just your team or enjoy a one-to-one session with an expert.

Fill in the form below and our team will get in touch with pricing and helpful advice.

Course Dates

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 attends?

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Explore Careers

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Explore Careers

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Explore Careers

Learn Your Way

Face To Face

Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.

Explore Courses

Live Online

Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.

Explore Courses

Team Training

Upskill your team together. Build your team and develop consistency, and collective confidence.

Explore Team Training

Three Steps To Success

Identify Your Path

Define your direction with purpose, aligning your learning journey to personal and career goals.

Learn With Experts

Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.

Earn Certification

Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.

Microsoft Excel Power Query Course