Excel Data Analysis

Learn to use options in Excel to summarise and analyse lists of data including subtotals, simple pivot tables, statistical functions and Excel’s powerful analysis tools. Excel has a number of features that can help you manage large lists of data. A variety of methods of summarising and analysing data are also explored.

Key content

  • Extracting sets of data including unique records using the advanced filter
  • Using tables to format, organise and summarise data
  • Using pivot tables to analyse data
  • Adding subtotals where appropriate
  • Database functions as an alternate way to analyse data
  • Review of functions in the statistical category
  • Using the analysis tools plugin to create summary statistics or histograms
  • Regression analysis and trend lines – calculated and graphical
  • Review of functions in the statistical category

Objectives

  • Learn to summarise lists of data using subtotals, simple pivot tables and database functions
  • Access Excel's powerful analysis tools to provide statistical data at the click of a button

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 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

Registration

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

Dates, times and venues for 2017

July - September 2017

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

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

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

October - December 2017

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

Wednesday 8 November 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus