Excel Power Tools & Power BI

Create a PowerPivot model by importing data from various sources
Understand and manage data relationships
Create and edit hierarchies
Insert calculated columns using Data Analysis Expression (DAX) formulas
Insert, modify, and format PivotTables and PivotCharts
Create and edit Measures (DAX aggregate functions)
Create report dashboards using slicers, timelines and KPIs
Use PowerView, PowerMaps and Power Query tools

It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops, or have equivalent experience.

It is expected that you have a good understanding of Excel functions such as IFs and VLookups as well as Defined Names, Importing Data and a basic understanding of PivotTables.

Our courses run from 9.30 am to approximately 4.15pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with us you get the following:

A full colour training manual/book.
The exercises that you have worked on during your course to allow you to practice afterwards.
USB stick to take the exercises away.
Certificate of attendance
Freshly prepared lunch.
Refreshments throughout the day.
Training in fully air conditioned facilities from an experienced instructor.