Excel 2000: Worksheets Book

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

Opening a second file

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

Using the Fill Series feature

Lesson 5: Formatting a worksheet

Formatting a worksheet

Number formats and text alignment

Copying and pasting formats

Special and custom formatting

Lesson 6: Printing a worksheet

Checking spelling

Using the Print Preview command

Printing a large worksheet

Additional print options

Lesson 7: Introduction to the workbook environment

Using a multiple-sheet workbook

Creating a chart

Outlining

Spreadsheet Solutions

Lesson 8: Creating Excel Web pages

Using Excel as a Web tool