Skip to content

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

Talk to a person

Not sure where to start? Neither were most of our clients.

Fifteen minutes with someone who does this every day.

Not sure where to start?