Excel Level 5 Business Intelligence - 10/3/22 (AM)&17/3/22 (AM)

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 Business Intelligence 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 the tools – Get & Transform, Power Pivot, Power Maps and Desktop BI Visualisations.

Get & Transform (formerly Power Query)

Identify Data Sources Internally
Search for data publicly available
Previewing data
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

Sharing Visualizations

Power Maps
Launching Power Map
Creating New Maps with Layers
Geography and Map Level
Types of Map Themes
Adding Map Labels

Creating Videos
Adding Scenes
Playing a Tour
Adding Music
Playing within PowerPoint

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. You must have completed Level 5 BI Part 1.
Please note - Excel BI features are only available within Excel 2013 or above. In Excel 2016 they are built in. We also look at Desktop Power BI App.

Delivery: Online (live)
Level: Expert
Exam Required
Voucher Incuded
Guaranteed Pass
Practice test
On-site exam
Course Dates : 10/3/22 (AM)&17/3/22 (AM)
Day & Time:
Week Days
What is included:
Digital courseware
Digital Recording
Printed courseware
Extra revision sessions
Training Instructor accredited by: Microsoft (MCT)
Starts: March 2022
Duration: 1 day or less

Public discussion (0)

You must log in to send a new comment.