MS Office
MS Excel Power Pivot — Part 2
Tuesday 27 October 2026 · 09:00–12:00 (GMT+2) · Online Live Stream
Booking, payment and your CPD record are handled on the CPD Sorted platform.
About this session
Power Pivot extends Excels standard PivotTable functionality by enabling the creation of sophisticated data models establishing relationships between different tables and performing complex calculations using the DAX formula language. |
What you'll cover
- This introductory course covers:
- A brief review of PivotTables
- Activating Power Pivot and loading data into the data model
- Working with multiple tables
- Creating calculated columns
- Working with time-dependant data
- Using measures and DAX functions