Power Query Course

If you regularly work with Excel and often spend time combining spreadsheets, cleaning messy data, or preparing files for reporting, this Power Query course is designed for you.

On this 1 day course you’ll gain the practical skills to simplify complex data tasks, reduce errors, and save hours each week by using Power Query, a powerful data transformation tool built into Excel.

This hands-on, instructor-led Power Query training is focused on real-world applications and designed for professionals who want to improve the way they manage and prepare data.

You’ll learn how to connect to various data sources, reshape and clean your data, and create repeatable steps that automate your reporting process.

Power Query allows you to transform the way you work with data — but many Excel users don’t realise how powerful and accessible it is.

This Power Query class gives you a clear understanding of the tool and how it can be used in everyday business situations.

You’ll learn not just how Power Query works, but also why and when to use it.

By the end of the course, you'll be able to clean and reshape data without formulas, consolidate multiple files quickly, and automate recurring data prep tasks in Excel.

These skills not only save time but also help reduce manual errors and improve the reliability of your reporting.

The course is practical and designed for immediate use in the workplace, making it a smart investment for professionals and teams looking to boost efficiency.

By the end of this one-day Power Query course, you will be able to:

• Navigate the Power Query Editor confidently
• Import data from Excel, folders, and other sources
• Apply steps to clean and structure data
• Merge and append datasets
• Create calculated columns using logic or examples
• Automate data preparation and refresh processes
• Save time and reduce errors in your Excel workflows

Download the full Course Outline

This course is ideal for professionals who use Excel regularly and want to get more from their data. If your role involves reporting, analysis, finance, or operations—and you're often working with large or messy datasets—Power Query can make a real difference.

Whether you're aiming to cut down on manual tasks, improve the quality of your data, or create more consistent reports, this Power Query course will give you practical skills you can start using straight away.

You do not need any previous Power Query knowledge, but should be confident using Excel and regularly work with large datasets.

This course is a practical course with small class sizes, a maximum of 6 delegates, which allows for plenty of time to interact with the trainer and ask any questions!

These are held as in-person classroom courses or as live, online courses (over Zoom). All courses, run from 9:30 am to 4:30 pm, with plenty of breaks.

Scheduled Power Query Courses

Our scheduled public Power Query Courses are run in Manchester and Online. Dates for these can be found below and information about the venues can be found on the Timing & Venue Info tab.

Private / Bespoke Courses

We run private one to one and group Power Query Courses at our training centres, or at a location to suit you, anywhere in the UK. These can also be held Online.

See the Private Course tab further down the page for more information.

• Run by an experienced trainer
• This course is limited to 6 places so you are guaranteed personal support throughout the course
• From only £295 + VAT per delegate
• Convenient locations in central Manchester and Online
• Course notes and support material provided
• Lunch and refreshments provided
• Certificate of achievement
• 5 Star Rated in Google Reviews