Microsoft Office Excel 2010 Advanced
Sorry, this event’s been and gone
When:
| Tue 11 Sep ’12, 9:00am–12:30pm |
|
Where: Colliers House, 52 Highbrook Drive, Auckland
Restrictions: R15
Ticket Information:
- General Admission: $241.50
Online tickets are no longer on sale
- Booking fees may apply
Website:
Event listed by: Lynnette Greeff
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.






Would you like to comment?
Sign up with Eventfinda (it’s free!) or sign in if you’re already a member
Eventfinda 45 mins ago