Excel 97: Advanced

Course length: 1 day

Course description

Overview: Students will build upon the skills acquired in Excel 97: Worksheets and Excel 97: Charting and Organizing Data to learn the skills and concepts necessary to work with advanced features of Excel 97. This course meets the Microsoft Proficiency Guidelines for Excel at the Expert level.

Prerequisites: To ensure your continued success, students must first take the Software Training courses, Excel 97: Worksheets, and Excel 97: Charting and Organizing Data, and have a good working knowledge of the Windows 98 environment.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to customize toolbars, create pivot tables, link files, consolidate data, and record macros.

Target student: Students enrolling in this course should understand the basic concepts involved in using Excel 97. For example, students should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to:

• Evaluate learning. Upon successful completion of this course, students will be able to:
• Customize toolbars and create styles and templates.
• Create nested and decision making functions.
• Analyze worksheet data by creating pivot tables.
• Compare and contrast workbook files and file links.
• Outline and consolidate worksheets; analyze worksheet data by using the Solver and Scenario Manager.
• Display and protect worksheet data by locking cells.
• Record and modify macros by using the Visual Basic Editor.

Course content

Lesson 1: Customizing the work area

Working with existing toolbars

Creating a new toolbar

Creating and using styles

Creating templates

Lesson 2: Advanced formula construction

Nested functions

The IF function

The VLOOKUP function

Error handling and the Auditing features

Lesson 3: Pivot tables

Creating pivot tables

Working with pivot tables

Viewing pivot tables at different levels

Lesson 4: Multiple file linking

Working with workbooks

Linking individual cells

Workbooks versus links and workspaces

Lesson 5: Consolidating data and using analysis tools

Consolidating worksheets

Using the Goal Seeker and Solver utilities

Creating a scenario by using Scenario Manager

Lesson 6: Protect and display options

Using comments

Protecting the worksheet

Hiding information

Custom views

Lesson 7: Introduction to macros

Running a macro

Recording a macro

Viewing and editing VBA code

Additional information: This course was designed to meet the Microsoft Proficiency Guidelines for Excel 97 at the Expert level.