View Details

Excel 365 Level 3 Power Query and the Data Model

Remote Corporate Training, Not a geographical location
Admin Contact
Corporate Training Mail Box (
Target Audience
All users
target audience
Course Types
Course categories
ICT & Digital Skills
Course description

Is this course for you?

You are familiar with creating simple Pivot Tables from Excel data.

You want to find ways of quickly cleaning up and merging data for use in a Pivot Table, or you have data in several different tables which you want to analyse in one Pivot Table.

This course includes topics from the Excel Advanced course


The course assumes that delegates are familiar with: creating Pivot Tables in Excel.

To take part in this course, delegates will need an internet-connected device with camera and microphone, and an internet connection which can stream video in reasonable quality.

Training objectives

At the end of the course, you will understand the Excel data model. You will be able to import data into Power Query and use tools to clean it up before saving the data in the Data Model.

You will be able to refresh your query when the data changes, and know how to create relationships between data tables, so you can build a Pivot Table using fields from multiple tables.

Learning outcomes

The Data Model

Advantages of using the Data Model
View and edit data in the Model
Importance of key fields

Pivot Tables

Create a Pivot Table using data in the Data Model
Use data from multiple tables
Create relationships between tables

Understand Excel data flow

See how Excel's data handling and analysis tools fit together

Get and Transform data

Import data from different sources
Load data into Power Query

Power Query

Use Power Query tools to prepare and clean your data
Merge data from multiple files in the same folder
Load the data into the Excel Data model
Refresh a query to automatically process changed data

Build a dashboard

Link a slicer to multiple Pivot Tables

Additional Information

The provider for this session is an external trainer.

Once your place has been confirmed look out for invitation to join the session from

ACCEPT the invitation (and be sure to check your spam folder as well in case it has slipped into that) and the session will drop into your Outlook calendar.

You will get an automatic reminder to JOIN MICROSOFT TEAMS MEETING (about) 15 minutes before the scheduled start.

Delegates' email addresses as registered on the portal will be provided to the trainer for the purpose of conducting this training only.

Delegates should ensure that their work (not personal) email addresses are recorded - check and update as necessary through 'My Profile and Bookings/Change Contact Details'.

This training will be delivered through Microsoft Teams.

Start Date
Wednesday 26 January 2022
End Date
Wednesday 26 January 2022
Closing Date
Tuesday 25 January 2022
10:00 - 11:30
Maximum Places
Login to view cost
Number of Sessions

Need more time?

For security reasons your session is about to expire. You will be automatically signed out in

To continue your session, select Stay Signed In.