XL-ENT
Access 97-1
Access 97-2
Excel 97-1
Excel 97-2
Excel Advanced
Office 97
QuickBooks-1
Quickbooks-2
Quicken
PowerPoint 97-1
PowerPoint 97-2
Windows 95-1
Word 97-1
Word 97-2
Word 97 Advanced

Excel 97: Advanced (Windows 95)

Course specifications

Course number: 52-222

Software version number: 97

Course length: 1 day

Certification

The combined content of the Excel 97: Worksheets, Excel 97: Charting and Organizing Data, and Excel 97: Advanced courses satisfies the requirements for the Certified Microsoft Office User for Excel 97 at the Expert level.

Course description

Overview: Students will learn the skills and concepts necessary to work with advanced features of
Excel 97.

Prerequisites: Windows 95: Introduction, and Excel 97: Worksheets, or equivalent knowledge.

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.