Microsoft Excel Power Query Course - Online

WHO IS THIS COURSE FOR?

Excel Power Query will allow you to transform the way you work with data. This will reduce the amount of Macros that need to be created and will show you how to shave hours off your day with practical examples, tips, and tricks. By the end of the course, you will be an expert at cleaning, transforming and reshaping your data so that it is ready to analyse.

PREREQUISITES - This course is perfect for existing users of Excel who spend a lot of time manually preparing data for analysis. Previous experience of Pivot Tables and Formulas would be needed.

COURSE CONTENT

Getting Started

• Introduction to Power Query

• Power Query User Interface – A Walkthrough

• Importing Data Rules and Best Practice

Data Preparation - Part 1

• Combine or Merge Multiple Files from a Folder

• Importing Data from the Web

• Merge Queries vs. Append Queries

• JOIN Types for Beginners

• Understanding JOIN Concept and its Types

• JOINS in Action – Basic Example

• Quick DOs and DONTs for Merge Queries

• Merging Queries with more than 1 KeyID Column

• Fuzzy Lookup

Data Preparation - Part 2

• Using First Rows as Header

• Cleaning Up Data with Case Change, TRIM, CLEAN

• Working with Data Types

• Removing Duplicates and Blank Rows Split Column

• Rectify Date Format using Data Type (Locale)

• Adding a Conditional Column

• Merge Columns (Concatenate)

Data Preparation (Re-Structuring) - Part 3

• Unpivot Column

• Group By

• Transpose

Duration: 1 day

Date: Monday 16th February 2026

Cost: Free to attend - Digital & Employment skills bitesize training fully funded by Welsh Government

Venue: Online

Course Delivery: This course will be delivered by PS Training.

Book online using the booking form below, call 01686 628778 or email sam@mwmg.org

If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org