Excel Level 6 Power BI - Visualise and Report 9th June 2026
| Event Date: | 9th June 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).
A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.
Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.
Prepare Reports for import
Import files
Importing text files
Creating DAX formulas =RELATED
Calculated columns
Fields for slicers
Creating Measures
Visualisations
Using Slicers to view data
To enrol on this course, delegates must either have completed our Excel Levels 1-4 training or demonstrate equivalent proficiency. This course builds on advanced Excel foundations, and assumes a high level of day-to-day use. It is specifically designed for professionals whose roles demand regular, in-depth use of Excel, and who are looking to apply power user techniques to enhance productivity, streamline complex tasks, and unlock greater value from Excel’s advanced features. If you're not confident in your current Excel capabilities at an advanced level, we recommend completing the earlier courses first to ensure you gain the most from this training.
Venue: Live online via Teams with recording available
A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.
Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.
Prepare Reports for import
Import files
Importing text files
Creating DAX formulas =RELATED
Calculated columns
Fields for slicers
Creating Measures
Visualisations
Using Slicers to view data
To enrol on this course, delegates must either have completed our Excel Levels 1-4 training or demonstrate equivalent proficiency. This course builds on advanced Excel foundations, and assumes a high level of day-to-day use. It is specifically designed for professionals whose roles demand regular, in-depth use of Excel, and who are looking to apply power user techniques to enhance productivity, streamline complex tasks, and unlock greater value from Excel’s advanced features. If you're not confident in your current Excel capabilities at an advanced level, we recommend completing the earlier courses first to ensure you gain the most from this training.
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=0d26f8324c5c4f97b48a66571d2d4e61
Connect and Succeed