Microsoft Excel 97 Expert User

Course Code NGE71032

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This multimedia self-paced learning course will instruct you on working with the advanced features and functions of Microsoft Excel 97. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to have a personalized study path based on the knowledge and skills demonstrated. Mastery modules at the end of each unit allow you to verify your understanding of key skills and guide you back to any content that warrants further study.

Audience

This course is intended for experienced Microsoft Excel 97 users who wish to leverage Excel's more advanced features and options. Participants should have taken Microsoft Windows 95 Fundamentals (Course 70011) and Microsoft Excel 97 Proficient User (Course 71031).

Prerequisites

(Currently no course prerequisite information)

Objective

• Create accounting and financial statements.
• Create data analysis.
• Create statistical tables.
• Create amortization schedules.
• Create forecasts.
• Create personnel records.
• Create lists.

Topics Include

Unit 1: Editing, Formatting and Printing Techniques

• Apply general number formats.
• Create custom formats.
• Use styles and AutoFormats.
• Preview and print workbooks.
• Import from other applications.
• Export to other applications.

Unit 2: Advanced Calculation Techniques

• Create and record macros.
• Edit macros.
• Run macros.
• Check and review data.
• Find cells referred to in a specific formula.
• Find formulas that refer to a specific cell.
• Find errors.

Unit 3: Database and Workgroup Functionality

• Work with existing templates.
• Create templates.
• Edit templates.
• Query a database.
• Perform a web query.
• Extract data.
• Use filters.
• Use data analysis and pivot tables.
• Use data map.
• Sort data.
• Run a query from a list.
• Link workbooks.
• Use multiple workbooks.

Unit 4: Workgroup Functions

• Use cell tips.
• Use share lists.
• Track changes.
• Resolve conflicts.
• Show history of changes.
• Merge workbooks.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media