Excel Power Pivot

Learn to utilise the features of Power Pivot to summarise large amounts of data and streamline the process of presenting the results.

Power Pivot for Excel supports BI (Business Intelligence) functionality by allowing large amounts of data from various sources to be prepared and stored in an Excel workbook. Once there, data can be
integrated using relationships and analysed in a number of ways including the use of Pivot Tables and interactive displays such as Power Map or Power View (not the main focus of the course). 

Key content

  • Deal with large data sets from a variety of sources in Power Pivot
  • Review the Data Model to build relationships between tables of information
  • Begin to explore the Data Analysis Expressions (DAX) formulas Power Pivot uses


  • Learn to utilise aspects of Power Pivot as a BI tool       
  • Use the data model to create a series of Pivot Tables and Power View graphs


Excel Pivot Tables

Suitable for

This is an advanced level workshop which is suitable for those who have completed the prerequisite or who are competent with the topics covered in that workshop.

Before registering, it’s your responsibility to ensure that you are competent with the topics covered in the prerequisite workshop, including understanding how Pivot Tables are created, formatted and customised using filters and slicers. 


PC only. Mac Excel 2011 or 2016 does not support this feature. Excel 2016 is used. Also suitable for 2013 users.


Free for University of Auckland and UniServices staff
Free for University of Auckland postgraduate students
$125+GST for others


If you are University of Auckland staff, please visit Career Tools to view session availability and register on a session.

For all others, please see our Registration page for more information on how to register or withdraw and our Cancellation Policy.

Dates, times and venues for 2018

January - March 2018

Dates will be published here in the new year. Alternatively request a custom workshop.