Microsoft Excel 97 Proficient User

Course Code NGE71031

Contents

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

Screenshot

Description

This self-paced learning course will instruct you on working with Microsoft Excel 97. The unique Skill Builder instruction uses text, 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 both a new spreadsheet user or a person familiar with Excel but not this version. Participants should have taken Microsoft Windows 95 Fundamentals (Course 70011).

Prerequisites

(Currently no course prerequisite information)

Objective

• Create budgets and expense reports.
• Create marketing and sales reports.
• Create invoices and purchase orders.
• Create spreadsheet information for use on the Internet/Intranet.

Topics Include

Unit 1: Working with Workbooks

• Start Excel.
• Open a workbook.
• Enter text and numbers.
• Enter formulas.
• Save and close workbooks.
• Save spreadsheets to be read on HTML.
• Read an HTML spreadsheet.

Unit 2: Entering and Editing Data

• Create and name ranges.
• Clear and format ranges.
• Copy and move ranges.
• Preview and print worksheets.
• Print the screen and ranges.
• Print headers and footers.

Unit 3: Formatting Worksheets

• Delete cell contents.
• Delete a worksheet.
• Revise text and numbers.
• Rotate and indent text.
• Revise formulas.
• Copy and move data.
• Insert, modify, and delete rows and columns.
• Use references: absolute relative mixed
• Modify cell size and alignment.
• Apply general numbers formats.
• Apply font formats.
• Apply outlines.
• Create and modify lines and objects.
• Create and modify 3D shapes.

Unit 4: Charts

• Create and format and modify charts.
• Preview and print charts.

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