Excel Power Query Course - On-site and Online

Power Query & Power Pivot Microsoft Excel Training Course

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

Our Power Pivot and Power Query course introduces working with Power Query in conjunction with Pivot Tables, Power Pivot and Power Pivot Measures in order to harness powerful and expansive data analysis techniques with Excel when working with large datasets from multiple and/ or external data sources.

In this respect, the course places the Power Query ETL tool into its proper context within the Microsoft Excel data analysis lifecycle and provides the breadth of knowledge you need to get the best insights possible from diverse data sources.

Email us or call 0844 493 3699 to find out more about booking MS Excel training for your team.

Our closed, private Microsoft Excel courses offer a flexible teaching approach and your allocated trainer will call you before the event to discuss your exact 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 are looking to further your data analysis skills beyond Power Query, then the logical next step would be to dip your toes into Power BI.

Microsoft Excel Power Query can be taught on the following versions: Excel 365, MS Excel 2021, MS Excel 2019 and MS Excel 2016. 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 courses for your learners offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your particular learning needs.

Excel is one of the most powerful and useful of the traditional Microsoft Office applications, but also often the one with which people can struggle the most, and that they find the most frustrating to work with. In fact, having team members and colleagues that are confident and proficient with Microsoft's Excel software can not only increase productivity and efficiency in the workplace, it can even be good for morale.

Our mobile trainers understand that helping their students to work more effectively is not just a business-oriented goal, it is also empowering for the individual students themselves. As such, our trainers are not just educators, they also champions of the software who endeavour to promote enthusiastic adoption of Excel among those they teach. Before the start date they will discuss with you the goals and objectives of the training and those skill-sets that your team need the most whether they are starting 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 regardless of whether you are in a major city such as London, Manchester, Birmingham or Leeds, or anywhere else. This offers a really 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 have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Microsoft Excel Power Query courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These Online instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

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

Our virtual learning Microsoft Excel Power Query courses cater for groups of up to ten people and your learners benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

Our realtime virtual classroom Microsoft Excel Power Query courses are charged out at £550.00 plus VAT per day inclusive up to 5 delegates. Further learners can be added up to a maximum of 10 charged out at £50.00 plus VAT per person per day. Courseware will be provided electronically.

You can find out how to set up Microsoft Teams for a live Online virtual course here (Virtual Learning with MS Teams).

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

Our Microsoft Excel Trainers are:

Specialist educators with a wealth of experience and expertise, 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 18,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 Microsoft Excel Power Query Courses?

Whilst the number of people who attend our private Microsoft Excel courses is essentially up to you and dependant upon the number of learners you have who need to receive the training (up to our ten delegate per course maximum), we encourage all of our clients to keep your class sizes small where possible. This provides a more personable and effective learning experience for you and allows the trainer to give more individual attention to each and every student.

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

The teaching method for our private Excel courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive, and thereby facilitate more effective learning and information retention. With this participatory learning method your staff will retain information better, whether they are studying Excel in-person or via live virtual classroom. And, whilst we are happy to provide lectures, demonstrations and show-and-tells for larger groups (plus drop-in surgeries for ad hoc technical advice and explanation), the instructor-led training approach is by far the most reliable teaching methodology to bring your Excel know-how to life in a small-class-size setting.

More About Our Excel Power Query Training Delivery Method for Closed Courses

• Instructor-led Excel Power Query training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Dynamic and interactive Excel Power Query courses with plenty of time for questions and answers.
  
  
• The personal touch: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Microsoft Excel functions, features, resources and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Private, corporate Excel Power Query training for small group sizes with a maximum of 10 learners on any course.
  
  
• Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level 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.

We specialise in delivering flexible training programmes and the actual course content, topics and syllabus taught will often vary depending upon your learning requirements and upon the version of the software taught.

• 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 your Pivot Table data with the click of a button. Slicers give you more control and precision than Excel filters and they can be connected to multiple pivot tables and charts.

2) Excel Data Models enable 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 functionality within a workbook which historically would have required building a database in an application such as Microsoft Access.

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 Microsoft 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. This gives you a level of control within Excel which you could otherwise only expect with applications and languages such as Microsoft Query, SQL and Power BI.

5) Power Pivot is an Excel add-on which enables you to import data from multiple sources in really significant quantities of data which are in the millions (rather than thousands) of rows. It enables you to create data relationships between diverse sources that might otherwise be incongruous with each other 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 have 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

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 in conjunction with Pivot Tables, Power Pivot and Power Pivot Measures

Back to top