About this course
Aim
By the end of the course, you will be confident in using PowerPivot to manipulate large data sets
Requirements
Delegates must have a good working knowledge of Microsoft Excel, including having used Pivot tables and familiarity with slicers.
What you will learn
Introduction to PowerPivot
The PowerPivot environment
- Connecting to different data sources
- Using an Excel worksheet as a data source
Working with Multiple Table Data Sources
- Managing data in PowerPivot
Working with Relationships & Tables
- Working in the PowerPivot Diagram View
- Managing relationships and tables
- Working with Hierarchies
Calculations and KPIs
- Create a Calculated Column
- Creating a Measure
- Working with dates in PowerPivot
- Creating a KPI
- Adding a KPI to a PivotTable
Creating DAX (Data Analysis Expressions) Functions
- Overview of DAX Functions
- Writing DAX Functions
Slicers
- Using Slicers with PivotTables or PivotCharts
- Locking a Slicer to a PivotTable or PivotChart
- Adding a Timeline to a PivotTable or PivotChart
Recent reviews
Really informative learnt lots of new interesting features on excel
Ceri e17 May 19
Paul was very good and he took time to go through slowly with me as I am slow learner.
Anita P17 May 19
It was really beneficial for us to now go back and think how we can use it in our day to day.
Nisha S16 May 19