Excel Power Query Course - On-site and Online

Power Query & Power Pivot Microsoft Excel Training Course

This one-day Excel Power Query course provides everything you need to get started using Microsoft Excel to reveal 'deep dive' data insights for larger datasets.

You will learn data modelling with Power Query alongside Pivot Tables, Power Pivot and Measures, and discover how to harness powerful data analysis techniques (and gain meaningful insights) with Excel when working with larger datasets from multiple external sources.

The course places the Power Query ETL tool into its proper context within the Excel data analysis lifecycle and provides the breadth of knowledge needed to get the best insights possible from your data.

Our private Excel courses cost £450.00 plus VAT p/d inclusive up to 3 learners. Add more people at £50.00 plus VAT p/d up to a limit of 10. Trainer mileage costs apply for on-site courses.

Our closed, private Microsoft Excel courses offer a flexible teaching approach and your trainer will call you before the event to discuss your training needs. You can also combine this Power Query course with Intermediate and Advanced Excel training courses to create a blended training programme of up to four days in duration.

With our Excel Power Query course you can opt to have one of our Excel instructors come out to your premises on-site or we can deliver the course Online as live virtual classroom.

Excel Power Query Training Course Prerequisites

Learners should already be confident Excel users with either advanced knowledge or a high level of intermediate knowledge before undertaking this Power Query course. You will, however, need no prior experience working with Pivot Tables, Power Query, Power Pivot or Power Pivot Measures.

Where Next?: Beyond Excel Power Query

If you want to extend upon your Power Query knowledge, then the logical next step would be to look at Power BI. Whilst PQ is capable of handling large datasets, limitations can arise when attempting to visualise these in Excel dashboards. That's the point at which you may want to think about moving over to Power BI for richer visualisations and insights for bigger datasets.

Microsoft Excel Power Query can be taught on the following versions: Excel 365, 2024, 2021 and 2019. Power Query does go back as far as Excel 2010 but we would recommend a more up-to-date edition.

On-site Microsoft Excel Power Query Courses

Our closed courses for Microsoft Excel Power Query are delivered as private events for your learners offering more flexibility than off-the-peg courses and topics can often be tailored to meet your particular learning needs.

Excel is one of the most powerful and useful traditional Microsoft Office apps, but also often one with which people can struggle most, and that they find the most frustrating to work with. In fact, having staff who are confident and proficient with MS Excel doesn't only increase productivity and efficiency, it can even be good for morale.

Our trainers know that helping students to work more effectively isn't just a business goal, it's also empowering. They aren't just educators, they're also software champions who promote enthusiastic adoption of Excel amongst their trainees. Before the start date they'll discuss your team's training goals with you, whether they're setting off as novice, intermediate or advanced users.

With our on-site courses our regional Excel Power Query trainers come to your workplace throughout England, bringing the training to you whether you're in a major city such as London, Manchester, Birmingham, Leeds, or anywhere else.

This offers a cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Hampshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding and everywhere inbetween.

Live Virtual Classroom Excel Power Query Courses, UK & Beyond

If you'd rather that your team learns remotely, these small-group Microsoft Excel Power Query courses are also available as live virtual, interactive sessions from the comfort of your own office or workplace. These instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we've all become used to Online learning (and live virtual meetings) it is clear that this format has some advantages over traditional face-to-face learning.

If you're looking for local training, then you can't get closer to your doorstep than you can with virtual learning.

Our virtual learning Excel Power Query courses cater for classes of up to 10 and your learners benefit from full and immersive interaction with the trainer just as if they were in the classroom with you, with engaging hands-on training via live video conferencing that's enriched by features such as live chat, private chat, and sharing screens and documents.

Our virtual classroom Excel Power Query courses cost £550.00 plus VAT p/day inclusive up to 5 delegates. More learners can be added up to a limit of 10 charged at £50.00 plus VAT per person p/day. Courseware will be provided electronically.

We really ❤ helping UK organisations to master Excel Power Query. Our only question is: Will it be yours?

Our Microsoft Excel Trainers are:

Inspirational subject experts with a wealth of experience, proven track records and excellent feedback.

Our Closed Microsoft Excel Courses are:

Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.

Education is Our Passion:

Over 35,000 students trained across almost every industry, sector and background.

Commercial and Corporate Excel Power Query Courses for the Public and Private Sectors

How Many People Should Attend Our Private Excel Power Query Courses?

Whilst the number of people who attend our Microsoft Excel courses is essentially up to you and depends on the number of learners you have (up to our ten per course limit), we encourage clients to keep class sizes small. This provides a more personable and effective learning experience and allows the trainer to give individual attention to every student.

What is the Teaching Method for Our Microsoft Excel Power Query Courses?

The teaching methodology for our Excel courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive. With this participatory learning method your staff will retain information better, whether they're studying Excel in-person or via live virtual classroom.

And, whilst we're happy to provide lectures, show-and-tells and drop-in surgeries, the ILT approach is by far the most reliable way to bring your Excel know-how to life in a small-class-size setting.

Why Choose Our Power Query Courses?

• Reliability: We have a reputation built on trust and upon two decades worth of experience and expertise in the technology and training industries.
  
  
• Step-by-Step Courses: Instructor-led Excel Power Query training provided in-person with engaging step-by-step demos, lessons and hands-on exercises.
  
  
• Q&A Courses: Dynamic and interactive Excel Power Query courses with ample time for questions and answers.
  
  
• The Personal Touch: Expert tuition from experienced and trusted specialists, tailored to your team's knowledge level and learning needs, and covering the Microsoft Excel functions, features, resources and techniques that your trainees need most.
  
  
• Small Class Sizes: Private, corporate Excel Power Query training with a limit of 10 participants to ensure personalised attention.
  
  
• Flexible Courses: Can be run as one or more courses, or as a digital transformation training programme bringing entire departments and organisations up to the benchmark of Microsoft Excel knowledge that you require.

Microsoft Excel Power Query Training Course Topics

You can combine Beginners, Intermediate and Advanced Excel topics and agendas for a blended step-by-step training curriculum of up to four days in duration.

Actual course content may vary, depending upon your learning requirements.

• Module 1: Excel PivotTables
  1. What are Excel PivotTables?
  2. Using Slicers¹ to filter PivotTables
  3. Excel PivotTables tips and tricks
     
     
• Module 2: Excel Data Models
  1. What are Excel Data Models?²
  2. Integrating data from multiple tables
  3. Creating relationships between tables
  4. Displaying your information in PivotTables
     
     
• Module 3: Excel Power Query
  1. What is Excel Power Query?³
  2. Importing data from different sources
  3. Using the Power Query Editor to Transform data
  4. Adding calculated columns
  5. Loading data into the Data Model
     
     
• Module 4: Working with Dynamic Parameter Tables in Excel
  1. What are Dynamic Parameter Tables?⁴
  2. Using a Parameter Table to change the data source
  3. Using parameters to filter data
     
     
• Module 5: Introduction to Power Pivot
  1. What is Power Pivot?⁵
  2. Connecting Power Pivot to data sources
  3. Adding and removing imported Columns
  4. Using the Diagram View⁶ to create relationships
     
     
• Module 6: Using Measures⁷ in Excel Power Pivot
  1. What are Power Pivot Measures?
  2. Using Measures to create Calculated Fields
  3. Using DAX functions in Measures
     
     

Power Pivot and Power Query Terminology in Layman's Terms

1) Slicers provide a means of quickly filtering portions of Pivot Table data at the click of a button. They give you more control and precision than Excel filters and can be connected to multiple pivot tables and charts.

2) Excel Data Models allow you to pull in data from multiple tables, essentially enabling you to work with relational data. With Excel Data Models you have the power to work with relational data within the confines of a workbook. Historically this would have required building a whole separate database.

3) In Microsoft Excel Power Query enables you to "get" (or connect to) data from external data sources and then sculpt and clean (i.e. "transform") that data. Your edited data can then be brought into Excel to produce reports and charts. Or, to put it another way, the Power Query addon is an ETL integration tool which means that it enables you to Extract external data from multiple sources and then Transform that data before Loading it into a data warehouse (in this instance Excel) for analysis and reporting.

4) There are a number of methods for customising query parameters in Excel. With Power Query you can parameterise your data by using the Power Query Editor to define your Dynamic Parameter Tables. This allows you to set parameterised controls upon things such as data sources, filters and even usage. As such, you get a degree of granular control from within Excel that you could otherwise only expect from apps and languages such as Microsoft Query, SQL and Power BI.

5) Power Pivot is an Excel add-on which can import data from multiple sources in really significant volumes of rows (millions rather than thousands). It enables you to create relationships between disparate data sources and combine them in one Excel Workbook or Worksheet. The data can then be manipulated with formulas to produce Pivot Tables and Charts.

6) With Power Pivot's Diagram View you can administrate the relational connections between the data tables that you've imported into your Excel Workbook.

7) Power Pivot Measures are simply what you would usually refer to as functions within the rest of Excel (SUM, COUNT, AVERAGE, VLOOKUP etc.). They can also be some of the more powerful formulas that you get with the DAX formulas language and its family of statistical and filtering functions for working with relational data.

Excel Course Levels: training courses are available for beginners, intermediate, and advanced users of Microsoft Excel.

Excel Training Reviews

Backed by almost 20 years of experience delivering first-class training to clients across the UK

Consistent & Outstanding Customer Satisfaction for our Excel Courses: 5-Star Rated

Out of students who completed our Excel course questionnaires over the past two years we have an aggregated customer satisfaction score of 4.86/5.0 based on our KPI feedback. Of these 96.36% of our clients would recommend us and 99.09% would recommend our Excel courses.

An excellent, clear and patient tutor who guided me through the course seamlessly.
M Menzies (Online Excel training 365 (virtual classroom))

Can I just pass on my thanks to your team for the training you provided in York. I've had lots of positive feedback from the staff involved.
J Whiley, NHS York and Selby (Excel training York, North Yorkshire)

Really useful. Really knowledgeable trainer.
A Ward, Aeromet (Advanced Excel Training Worcester, Worcestershire)

The trainer explained everything really well. I found the course easy to follow.
V Broxham, Baywa-re Operational Services (Intermediate Excel training Milton Keynes, Buckinghamshire)

Happy with everything.
M Aston, Bierce Surveying Ltd (Advanced Excel Training Aylesbury, Buckinghamshire)

We have had a few people over the years but the way the trainer picked up our business and requirements so quickly – all I can is you have a diamond there.
S Jenkins, Concorde Glass (Intermediate Excel Training Grimsby, Lincolnshire)

We all thoroughly enjoyed the course, we learned a great deal and thought Sara was a brilliant trainer, very patient with a fantastic way of teaching us, so thank you for that.
C Waldock, Darlington Borough Council (Intermediate Excel training Darlington, County Durham)

The content covered the exact content required after the beginners course. The information will allow me to improve the spreadsheets currently in use.
L Powell, Dudley Building Society (Intermediate Excel Training Dudley, West Midlands)

Great course!
V Franklin, E-Leather (Excel Beginners Training Peterborough, Cambridgeshire)

The training approach and style was great. Incredibly informative and supportive.
L Shier, One YMCA (Introduction to Excel Training Watford, Hertfordshire)

Great teacher!
J Smith, Fisher German (Intermediate Excel Training Canterbury, Kent)

Its an excellent course. I was impressed by the discovery of so many tools that will facilitate our working life. The trainer is excellent, everything was perfect.
S Green, HW Martin (Beginners Excel Training Cambridgeshire)

Very happy to learn so much.
O Chawishly, LM Information Delivery (Intermediate Excel Training Oxfordshire)

Covered all objectives. Wish We'd had two days.
B Hough, Homebase (VBA for Excel Training Milton Keynes, Buckinghamshire)

The course was excellent, covering more in a single day of training than I anticipated would be possible with a high degree of clarity.
Unsigned, New Economy, (VBA for Excel training Manchester, North West)

Very informative, easy to follow. Trainer was clear with his explanations
S Nottingham, Denney O'Hara (Microsoft Excel training Leeds, West Yorkshire)

Excellent day!
L McLachlan, Grange School (Excel training Rochdale, Greater Manchester)

Brilliant Training, went at the right speed [and] was made relevant to work
Kathryn Strong, Tennants Distribution (Excel training Manchester, North West)

Fantastic course, not too much information overload. Explained simple. Exactly what I needed. Many thanks.
K Stobbs, Depuy Spine - A Jonson and Jonson Company (Introductory Excel training Leeds, West Yorkshire)

The flexibility of the course was ideal.
S Walsh, Progress Rail (Advanced Excel training Edinburgh, Midlothian)

The guys who came to the course this week were very impressed with the whole set up and are now eager to attend the next level up.
E Dixon, Connaught PLC (Beginners Excel training Leeds, West Yorkshire)

The course has improved my knowledge of Microsoft Excel and was a good pace so easily understandable. Gerry was very patient and helped each of us where we needed it.
L Muir, Filtronic Broadband (Microsoft Excel training Newcastle Upon Tyne)

Although a total beginner on Excel, I found the course to be extremely helpful.
S Antonie, Filtronic (Excel training Shipley)

Made what I thought was going to be completely foreign to me easy to understand. I can actually see where I can use Excel in my day job now. Max was very good and took the time to make sure we understood. [...] Nothing could be improved.
C Elsmore, Elmwood Design (Excel training Leeds, West Yorkshire)

Very Useful.
J Collins, Cooper Research Technology Ltd (Advanced MS Excel Training Ripley, Derbyshire)

Enjoyable and informative.
N. Bell, Cosalt PLC (Excel advanced training Grimsby, Lincolnshire)

The training session went very well and I have had a lot of good feedback from the participants.
P Ogden, InterfaceFLOR (Microsoft Excel Training Halifax West Yorkshire)

Course exceeded expectations.
K. Richards, Ashfield Homes (Microsoft Excel Training Sutton-in-Ashfield, Nottinghamshire)

The day was very well constructed and presented.
D. Coulthand, Crossgates Shopping Centre, Leeds (Intermediate Microsoft Excel Training Leeds, West Yorkshire)

Training very clear. Never felt rushed or pressured to complete tasks. Each item explained and demonstrated very well. Easy to follow
S. Hope, Lear Corporation (Advanced Microsoft Excel Training Coventry, West Midlands)

Good course, good information, good trainer and at a nice tempo
A. Webster, BE Aerospace (Advanced Microsoft Excel Training Hinckley, Leicestershire)

Excellent, the best Excel course I have ever been on. Trainer gave time and patience to us all.
D. Gill, Persimmon Homes (Beginners Microsoft Excel Training Malmesbury, Wiltshire)

A very robust day's training.
T. Camp, Ideal Shopping (Beginners Microsoft Excel Training Peterborough, Cambridgeshire)

The course in Edinburgh was incredible
C. Rowley (Beginners Microsoft Excel Training Edinburgh, Midlothian)

Back to top

MS Excel Course Levels:

Beginners Excel

- introductory topics for working with Excel spreadsheets

Intermediate Excel

- conditional formatting, VLOOKUP, IF, apply formulas across worksheets, database features, security and conditional formatting etc.

Advanced Excel

- What-If Analysis, PivotTables, PivotCharts, Goal Seek, Sparklines, protecting workbooks, formula auditing etc.

Masterclass Excel

- 'zero to hero' three-day intensive Excel course

Excel for VBA beginners

- one or two day introduction to programming with VBA

Excel Power Query course

- Introduction to using Excel Power Query along with Pivot Tables, Power Pivot and Power Pivot Measures

Copilot Integration with Microsoft Excel for Power Users course

- Enterprise Microsoft Excel course to accelerate data analysis, automation and reporting using Copilot's native Excel integrations

Back to top