Event Guide

Powered by:

Microsoft Excel III Advanced Course

Microsoft Excel III Advanced Course

Sorry this event has been and gone

When:

  • Fri 3 May, 9:00am – 3:30pm

Where:

Auckland Business Chamber, 90 Symonds St, Grafton

Restrictions:

All Ages

Ticket Information:

  • Single Ticket (Auckland Business Chamber Member): $339.25
  • Single Ticket (Non-Member): $454.25

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

Related Events

How to get your Event listed

To have your Event appear on NZHerald Events, go to www.eventfinda.co.nz who supply the event listings for this site.

Click here to add your Event now!
Powered by:

© Copyright 2019, NZME. Publishing Limited