Excel Business Intelligence

Course Overview

Intended for Advanced Excel users this one day exclusive course runs through an overview of how to use new tools – Power Query, Power Pivot and Power Maps.

On this One Day course you will learn how to clean, manipulate and refresh large amounts of data. Our training is in small groups with an experienced Microsoft approved trainer and it is ‘hands on’ exercises to give you practical experience to take back to your workplace. We also steer you towards further resources to help you after the class.

You’ll take a first look at the capability of the new Business Intelligence tools in Excel and see how they are used to take the data you have cleansed to create insights using Data Visualisations and Dashboards for Management Reports.

Further training on this topic, including creating DAX formulas and measures, is in the Excel Visualisations course.

Pre-requisite knowledge: Windows, Excel Secrets, Excel Ninjas and Excel Gurus or equivalent knowledge/skills.

Course Content

Your day with us will be crammed with delightful shortcuts and quicker ways to work!

Who is this for?

This course is specifically designed for office users, managers, accountants and data analysts. Delegates on this course should have existing advanced knowledge of Excel, and we will turn you into an Excel expert.

How much does it cost?

£450 + VAT per person