Microsoft Excel III

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 Excel
  • Use functions and formatting to prepare data so that it’s fit for analysis and reporting
  • Pull information from other worksheets using the Vlookup, Match and Index functions
  • Pull information from other data sources using external data links
  • Use the Table feature to create a dynamic data range
  • Create reports using Pivot Tables and Pivot Charts
Date:
Friday, 8th September, 2017
Time:
9:00 a.m. to 3:30 p.m.
Location:
Level 1, 90 Symonds Street, Grafton, Auckland 1010
Single Ticket (Member) incl GST:
$316.25
Single Ticket (Non-Member) incl GST:
$431.25

Step 1 of 5 - Event Details

Membership

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

Event


Total (incl GST)

Need Assistance? Please email events@chamber.co.nz 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 Vital Training no less than seven 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.