Event Guide

Powered by:

Microsoft Excel Advanced Version 2010

Sorry this event has been and gone


  • Tue 24 Nov ’15, 9:00am – 12:30pm


Manukau Institute of Technology, Corner of Manukau Station Road & Davies Avenue, Manukau City



Ticket Information:

  • General Admission: $324.50

Who should attend?
Attendees will need to be competent in the content as listed for Microsoft Office Excel for Beginners & Intermediate or have equivalent experience to attend this course.

Core content

Advanced Functions
- Nesting functions
- v Lookups & H Lookups

Data Validation
- Data validation
- Create or Remove a drop-down list

Data Subtotals
- Creating data subtotals
- Removing data subtotals

Grouping & Outlining Data
- Preparing data to be outlined

PivotTables & PivotCharts
- To create a PivotTable
- To sort a PivotTable
- To Filter a PivotTable
- Change the Layout of a Pivot Table
- Refresh Button
- Change Source Data
- Show/Hide PivotTable elements
- Summarise values by
- Show values as
- PivotTable Design Tab
- To create a PivotChart

Protecting the Workbook
- About Using Passwords

Excel Tables
- Create a Table
- Format Table
- Displaying & Calculating Table Totals
- Automatically Calculated Columns
- Filter & Sort a Table
- Convert back to Range

- Recording a Macro
- Running a Macro
- Deleting a Macro
- Editing a Macro
- Assign a Macro to an object, graphic, or control
- Assign a Macro to Quick Access Toolbar
- To change the Macro security settings to enable/disable macros
- Relative & Absolute Macro Recording

Email: businesstraining@manukau.ac.nz

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