Excel 97 Advanced Level III

Course Length/Prerequisites

This one-day course requires Excel 97 Introduction or equivalent.

Who Should Attend?

This course is designed for personnel who are already using Excel 97 and who wish to increase their efficiency by using some of the more advanced features of the product. Students who have experience using Excel 97 — but who have no formal training in its use — should consider taking the Excel 97 Fast Pace course.

Course Objectives

Upon completion of this hands-on workshop, students will be able to:
work with multiple worksheets and shared worksheets
use certain advanced functions
Record, run and edit macros
create and use scenarios

Course Content

Multiple Worksheets and Multiple Users
Multiple Worksheet Formulas

Using Multisheet Names

Group Editing

Consolidating Worksheets

Saving a Workspace File

Using Excel in a Workgroup

Sharing Worksheets with Others

Summary

Advanced Functions
Introduction and Definitions

The Function Wizard

The IF Function

AND and OR Functions

Rounding Errors

ISERROR Function

VLOOKUP Function

The PMT Function

Converting Formulas to Values

Auditing Cells

Summary

Recording and Using Macros
Recording a Macro

Running a Macro

Relative References in a Macro

Editing a Macro

Deleting Macros

Using Step and Break

Customizing Toolbars

Assigning Macros To Drawn Objects

Summary

What-if Tools
Scenarios

Goal Seek

Summary