Excel "Powers"

Excel "Powers" Masterclass

Course Content

Day 1: Power Pivot
Analyse more than 1 million rows of data
Analyse more than 1 million rows of data; 
Load data into PowerPivot; 
Filter data with Slicers; 
Easily create Relationships between tables of data; 
Create easy to use Dashboard view from PowerPivot; 
Learn the principles of the DAX formula language to create powerful new calculations; 
Create powerful new DAX measures in PivotTables; 
Create dashboards with PowerPivot data.

Day 2: Power Query and Interactive Dashboards
Introduction to Power Query; 
Benefits of Power Query; 
Loading data into Power Query (Microsoft Access Tables, CSV files, online data sources, modifying tables); 
Merging Data; 
Appending Data; 
Unpivoting Data; 
Using the Group function; 
Creating Custom Calculations. 
Creating Interactive Dashboards with Power Pivot Data; 
Advanced Dax Calculations.

Duration

Two days

Requirements

Good understanding of Excel and the principals of operating Excel, preferably working with data on a regular basis, with knowledge of compiling reports.
Your own laptop with Excel 2013 / 2016 with Power Pivot and Power Query.

Cost

Standard price £650 per person
No public courses are scheduled at this stage.

Onsite / In-House training available, please contact us to discuss your requirements.
Share by: