Excel Data Analysis

Learn to use options in Excel to summarise and analyse lists of data including subtotals, simple PivotTables, 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 plug in 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 PivotTables 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 for this workshop, it is your responsibility to ensure that you are competent with the topics covered in the prerequisite workshop. 

Facilitator

Jose Entrican

EVOLVE Capabilities

Scholarship / Professional Development

Leadership Framework dimension

Enabling People

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

Session dates for July onwards will be posted here in early June.

January - March 2017      

Registration is now open for the following sessions:

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

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

April - June 2017

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

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

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

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

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

To enrol (University of Auckland Staff Only)

You can enrol through Career Tools.

  1. Visit Career Tools.
  2. Enter the course title e.g. Word Intermediate in the search box in the top right hand corner.  
  3. Click on the title of the course you would like to attend from the list.
  4. Find the session you would like to attend in the list at the bottom and click on Request to register.

If you do not have access to Career Tools, please contact the Staff Service Centre at 86000 or email Staff Service Centre

If you can no longer attend this session, please withdraw immediately using Career Tools by clicking Withdraw under My Actions against the respective session or go to Learn > View Your Training Record and select Withdraw from the drop-down menu to the right of the respective session. No shows and late cancellations may incur a fee. Please see our Cancellation Policy for details.

To enrol (all others)

Please refer to the enrolment instructions on the How to enrol page.