Excel Data Analysis

Learn to transform, load and analyse lists of data using Excel’s powerful analysis tools.

Excel has a number of features that can help you manage large lists of data. Built into Office 2016 is the enormously flexible and powerful Get and Transform which replaces the Power Query add in from earlier versions. Methods of summarising and analysing data are also explored.

Key content

  • Extracting sets of data including unique records using the Advanced Filter
  • Filtering and transforming data – text, dates, numbers using Get and Transform
  • ‘Unpivoting’ data into a normalised format suitable for Pivot Table analysis
  • Combining data from a number of files in the same folder into a single table
  • Combining data from a number of sheets in the same workbook
  • Using Pivot Tables to analyse loaded data 
  • Using the Analysis Tools plug in to create summary statistics
  • Regression analysis and trend lines - calculated and graphical

Objectives

  • Be able to load transformed data into Excel for analysis and refresh it
  • Work with the Query Editor to refine the process
  • 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. 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.

All others, please see our Registration page for more information.

Dates, times and venues for scheduled workshops 2018

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

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

Thursday 19 July 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

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

Wednesday 12 September 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Thursday 25 October 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

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