Excel Level 5 BI

Price: £550.00 (£660.00 incl. VAT). 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 –

Description

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

Sharing Visualizations


Power Maps

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

Creating Video

Adding Scenes
Playing a Tour
Adding Music
Playing within PowerPoint

Prerequisites

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. 

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. 

Similar courses

Price: £550.00 (£660.00 incl. VAT). Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one. Let's make one for your business too.

More Information

Price: £300.00 (£360.00 incl. VAT). Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

More Information

Price: £300.00 (£360.00 incl. VAT). To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula;

More Information

Price: £300.00 (£360.00 incl. VAT). On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! You'll be looking at the Advanced Data Management features and how you can use them; You'll use Goal Seek and Solver to show how to answer business questions; We will look at what macros are, best practise and create a simple macro in our session.

More Information

Price: £550.00 (£660.00 incl. VAT). A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

More Information