Excel Pivot Tables

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

PivotTables are the single most powerful tool in Excel for financial reporting, budgeting, and data analysis. A PivotTable is a great reporting tool for financial assistants and management to sort and sum data independently from the original spreadsheet.

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 PivotTable summary
  • Modify the presentation of your PivotTable 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 for this workshop, it is 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. 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

Dates, times and venues for 2017

January - March 2017      

Thursday 23 February 2017, 1-4pm 
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Thursday 9 March 2017, 1-4pm 
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

April - June 2017

Thursday 27 April 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

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

Monday 12 June 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

July - September 2017

Registration is now open for all University of Auckland and UniServices staff.

Registration for all others opens in early June 2017. Please contact us from this date to request registration. Please note registrations will be processed on a first come first served basis.

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