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

  • Thursday 2nd July 2026
  • Tuesday 11th August 2026
  • Wednesday 2nd September 2026
  • Thursday 8th October 2026
  • Wednesday 4th November 2026
  • Thursday 10th December 2026
  • Friday 22nd January 2027
  • Friday 19th February 2027
  • Thursday 18th March 2027
  • Monday 26th April 2027
  • Friday 21st May 2027
  • Friday 25th June 2027
  • Thursday 22nd July 2027
  • Thursday 19th August 2027
  • Thursday 23rd September 2027
  • Friday 29th October 2027
  • Monday 29th November 2027
  • Monday 20th December 2027
Back to all Courses