You missed this – Subscribe & Avoid FOMO!


Wed 1 Apr 2015, 9:00am–12:30pm

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

Restrictions: R15

Ticket Information:

  • General Admission: $244.00 ($241.50 + $2.50 fees)
  • Eventfinda tickets no longer on sale

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

Phone 0800 SKILL UP (754 5587) or email

Restaurants to book near Microsoft Excel Advanced Version 2010