Training Course: Microsoft Excel 97 Level 3

Training Course Summary:

This class is designed for students who want to learn how to use the high-end-user features in Excel 97. Students will also learn how to use financial and logical functions, use and create macros and templates, and work with multiple worksheets and workbooks.

Pre-Requisites:

Excel 97 Level 2

Who Should Attend:

Excel users looking to become Advanced power users.

Training Course Overview/Content:

Lookup & Information Functions:
Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index
IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa

Advanced List Management:
Advanced Filters
Using List Features
Dynamic Lists

Pivot Tables:
Using the Pivot Table Wizard
Changing the pivot table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Lay out reports directly on worksheet
Pivot Chart

What If Analysis:
Scenarios
Custom Views
Reports
Goal Seek
Solver
Data Tables

Protecting & Sharing Files:
Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments

Introduction to Macros:
Purpose of Macros
Recording macros
Where to save macros
Absolute and relative record
Running macros:
Custom buttons, menu items, keyboard shortcuts