Review of basic/intermediate skills

LOOKUP functions
Using VLOOKUP and HLOOKUP

Auditing Workbooks
Auditing worksheets
Using tracer arrows
Finding worksheet errors

Workbook and Worksheet Protection
Protecting and Un-protecting Workbooks
Protecting and Un-protecting Sheets
Selective cell protection

Linking Workbooks

Creating and Customising PivotTables
Creating a PivotTable
Adding and removing fields
Hiding and displaying field detail
Using page fields
Working with totals in a pivot table
Formatting and editing PivotTables
Sorting items in PivotTable fields

Other Excel functions
Database, Logical and Information functions

Introduction to Macros
Command and Function macros
Recording and running Macros
Assigning Macros to the Keyboard and Toolbar

Working with Toolbars
Moving and Sizing toolbars
Customising Toolbars

Interpreting and Analysing data using Excel tools
Goal seeker
Creating and removing outlines
Creating and using Scenarios
Consolidating data