Excel Pivot Tables

Pivot tables are the single most powerful tool in Excel for financial reporting, budgeting, and data analysis.  

Learn to create a pivot table to summarise data and streamline the process of formatting and printing the results.  

Key content

  • Create PivotTables or PivotCharts
  • Use functions other than SUM to analyse your data
  • Group numbers, dates and even text labels to streamline the table
  • Use filtering effectively to display only the data you want
  • Adding custom formulas to your pivot table summary
  • Modify the presentation of your pivot table with cell format, and table styles

Objectives

  • Learn to create a PivotTable to summarise data the way you want it
  • Streamline the process of formatting and printing the results

Prerequisite

Excel Intermediate

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.

Notes

PC and Mac computers are available on a first-come, first-served basis. If you require a Mac, please contact us so that we can make the necessary arrangements. Excel 2016 is used. Also suitable for 2013 users.

Cost

Free for University of Auckland and UniServices staff

Registration

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

For all others, please see our Registration page for more information.

Dates, times and venues for scheduled workshops 2018

Wednesday 24 January 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Monday 12 March 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Tuesday 10 April 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Friday 25 May 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Thursday 7 June 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 18 July 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Monday 13 August 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Thursday 13 September 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Friday 12 October 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 7 November 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland