Excel Power Query

Excel Power Query is a data connection and data transformation application that enables users to import and reshape data from various sources, including Excel workbooks, databases, and online services, into a format suitable for analysis and reporting.
Built in to Excel 365 since 2016 it’s a powerful tool for extracting, transform and display using Excel Charts and Pivot tables.

One Day Course

Course Outline (PDF)

Main Topics:

  • What is Power Query?
  • Using the Power Query Editor
  • Data Transformation Tools
  • Advanced Data Transformations
  • Analysing Data
  • Project - Create an Excel Dashboard
Excel Green Logo Microsoft. Green book with white x in centre
Price: £175 + vat

Dates

  • Monday 20th October 2025
  • Tuesday 4th November 2025
  • Wednesday 3rd December 2025
  • Thursday 29th January 2026
  • Thursday 26th February 2026
  • Wednesday 11th March 2026
  • Thursday 9th April 2026
  • Thursday 7th May 2026
  • Thursday 4th June 2026
  • Thursday 2nd July 2026
  • Tuesday 11th August 2026
  • Wednesday 2nd September 2026
  • Thursday 8th October 2026
  • Wednesday 4th November 2026
  • Thursday 10th December 2026
Back to all Courses