Microsoft Excel III - May

Building on what you have learnt in Excel I and II, this course introduces the features used to save time formatting, referencing and reporting on large data lists, and aims to give you a good grounding in the more advanced data manipulation tools. Especially pertinent for people who work with large data lists, you will learn to work with data imported into Excel from an external source and prepare it for analysis and reporting using Pivot Tables and Pivot Charts.

You will be able to:

  • Control how delimited files are imported into and exported from Excel
  • Use functions and data cleaning features to prepare data so that it’s fit for analysis and reporting
  • Pull information from other worksheets using the Vlookup, Match and Index functions
  • Quickly summarize and report on data pulled from multiple worksheets
  • Create and use dynamic data ranges in formulas and Pivot Tables
  • Create dynamic reports using Pivot Tables and Pivot Charts

Certificates received upon completion.

There are several parking garages in the area. A couple of options include the Wilsons carpark 100 Symonds Street, or Wilsons on Whittaker Place.


Friday, 3rd May, 2019
9:00 a.m. to 3:30 p.m.
Level 1, 90 Symonds Street, Grafton, Auckland 1010
Single Ticket (Member) incl GST:
Single Ticket (Non-Member) incl GST:

Step 1 of 5 - Event Details


Choose if you are booking as a member or non-member

First time here? If you’re a current Chamber member and this is your first time registering for an event on our new website, please click here and enter your email address to be sent your password.
Forgotten Password


Total (incl GST)

Need Assistance? Please email or call 309 6100 for further information or help booking events.

Cancellations and Refunds: Cancellations and Refunds: Any cancellation and/or changes must be made in writing to Auckland Business Chamber no less than ten working days prior to the course in order to receive a full refund/credit. No refund or credit will be given for cancellations made after this time or for non-attendance at the course.