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 2013 is used. Also suitable for 2010 users.

Cost

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

Registration

Visit our Registration page to learn about registering, withdrawing and our cancellation policy.

Dates, times and venues for 2017

July - September 2017

Friday 21 July 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Tuesday 15 August 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Wednesday 27 September 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

October - December 2017

Wednesday 1 November 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Friday 24 November 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus