Microsoft Office Excel 2010 Advanced

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

Macros
- 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 businesstraining@manukau.ac.nz to register.