Microsoft Excel 2003, 2007, XP Advanced

Course contents

Data Validation & Pivot Tables
Data validation
Pivot tables
Creating a chart from a pivot table
Sharing Workbooks*
Setting up a shared workbook
Limitations of a shared workbook
Distributing a shared workbook
Tracking changes
Review and incorporate changes
Removing a workbook from being shared
Merging workbooks
Styles and Templates
Cell styles
Format as a table
Using the Sort and Filter Editing option
(to remove filters)
Creating a style by example
Defining and applying a style
Creating spreadsheet templates
Creating worksheet templates
Opening and editing the original template
Customising Excel
The Quick Access toolbar
Adding commands
Customising the keyboard
Creating custom views


Data AnalysisUsing Scenarios
Using Goal Seek
Using Solver*
Data tables
Remove duplicates
Simple Macros
The Office toolbar
Adding Developer tab
Trust Centre settings
Recording a macro
Understand the Personal Macro Workbook
Assigning a macro to Quick Access toolbar
Editing the icon
Running a macro
Editing and deleting macros
Exchanging Data with Other Applications
Using Clipboard
Linking and embedding data buttons
*Optional items available on request