Getting Started with Excel 97

Course description

Overview: Students will learn worksheet basics.

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:

*     Identify the features of an Excel workbook.

*     Create a basic worksheet by entering text, values, and formulas.

*     Create formulas by using Excel’s built-in functions.

*     Move and copy data by using shortcut menus and toolbar buttons.

*     Change the appearance of worksheet data by using a variety of formatting techniques; prepare a document for printing.

Course content

Lesson 1: Excel basics

The paper spreadsheet

The Excel program

The workbook environment

Lesson 2: Entering data and navigating in a worksheet

Entering and correcting data

Saving a file

Using formulas

Navigation and movement techniques

Lesson 3: Modifying a workbook

Working with ranges

Working with functions

Editing cell contents

Lesson 4: Moving and copying data

Inserting rows and ranges

Moving data

Copying data

Absolute references

Lesson 5: Formatting and printing a worksheet

Formatting a worksheet

Number formats and text alignment

Using the Print Preview command

Printing a large worksheet