Excel Mastery: Using Power Query and Power Pivot 14th May 2026
| Event Date: | 14th May 2026 |
| Event Time: | 9:30am to 4:30pm |
Enjoy expert-led training live online via Microsoft Teams, delivered by a qualified Microsoft Certified Trainer. Join from your home office or your desk—no travel, no extra cost, no wasted time.
Save on all online bookings (Enter Promo Code: WINTER25 at checkout).
This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools.
Get & Transform (formerly Power Query)
Identify Data Sources Internally
Search for data publicly available
Previewing data
Security
Combining data from different sources
Sharing to collaborate with others
Power Pivot
Manipulating large amounts of data
Joining data from several tables
Creating & Editing
Relationships between files and Tables
Power PivotTables and PivotCharts
First look at Desktop BI Visualisations
Creating a new Dashboard of Visualisations
Using data from multiple sources
Types of Charts
Types of Tables
Using Slicers to filter data
Deleting & Editing
Visualization elements
Refreshing Data
This course requires completion of Level 3 (Advanced) Excel training or equivalent experience. For example, you should already be competent at creating Pivot Tables and Advanced Charts to take full advantage of this Advanced Features class. We also look at Desktop Power BI App.
Venue: Live online via Teams with recording available
This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools.
Get & Transform (formerly Power Query)
Identify Data Sources Internally
Search for data publicly available
Previewing data
Security
Combining data from different sources
Sharing to collaborate with others
Power Pivot
Manipulating large amounts of data
Joining data from several tables
Creating & Editing
Relationships between files and Tables
Power PivotTables and PivotCharts
First look at Desktop BI Visualisations
Creating a new Dashboard of Visualisations
Using data from multiple sources
Types of Charts
Types of Tables
Using Slicers to filter data
Deleting & Editing
Visualization elements
Refreshing Data
This course requires completion of Level 3 (Advanced) Excel training or equivalent experience. For example, you should already be competent at creating Pivot Tables and Advanced Charts to take full advantage of this Advanced Features class. We also look at Desktop Power BI App.
Venue: Live online via Teams with recording available
For more information and to book please follow the link below:
https://imaginetraining.arlo.co/register?sgid=997b0c0b645b4faab5af695ab30547d3
Connect and Succeed