Course Details

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

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