Advanced Microsoft Excel 2003 Training Courses

Using multiple workbooks

Using a workspace
Linking workbooks
Printing workbooks

Printing and previewing multiple worksheets
Using the Report Manager
Named ranges

Add a named range
Delete a named range
Use a named range in a formula
Use Lookup Functions
Auditing a worksheet

Using the Auditing Toolbar
Tracing errors
Tracing dependents
Tracing precedents
PivotTables and Reports

Creating a PivotTable report
Creating a PivotChart report
Resetting a summary function in a PivotTable report
Creating a PivotTable report for the World Wide Web
Data Analysis Tools

Goal Seek
Solver
Scenario manager
Excel workgroup features

Changing workgroup properties
Creating a shared workbook
Merging workbooks
Tracking changes
Creating, editing and removing comments
Applying and removing file passwords
Applying and removing worksheet and workbook protection
Macros

Recording macros
Running macros
Editing macros