Provider Registration Provider Login

Course Details

Book with this provider now

Microsoft Office Excel Advanced, version 2010
16 Oct 2015
Professional Development
Computer Skills / Applications
Manukau Institute of Technology
Faculty of Business and Information Technology Reception, Floor 2 Corner of Manukau Station Road and Davies Avenue, Manukau
Half Day
9.00am to 12.30pm
$241.50
including GST
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

Manuals are included in the course fee
Annamarieke Ymker
growme © copyright 2024 | Site by oneclick