Excel 2002 Series

Excel 2002 Series
Total Time: 22 hours

Excel 2002: Working with Cells

Time: 4 hours

EXPM01

Excel 2002: Working with Cells shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.

Entering Data
Editing a Cell
Editing Multiple Cells

Replacing Values and AutoFilling
Creating Hyperlinks

Excel 2002: Working with Files

Time: 3 hours

EXPM02

Excel 2002: Working with Files shows users how to locate, open, and save files in Excel 2002.

Opening Files
Saving Files
Files and the Internet

Working with Comments
Using the Office Assistant

Excel 2002: Formatting Worksheets

Time: 4 hours

EXPM03

Excel 2002: Formatting Worksheets shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.

Formatting Cells
Adjusting Cells
Formatting Numbers

Adjusting Rows and Columns
Using AutoFormatting and Styles

Excel 2002: Page Setup and Printing

Time: 2 hours

EXPM04

Excel 2002: Page Setup and Printing shows users how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.

Previewing
Printing

Page Setup
Headers, Footers, and Titles

Excel 2002: Worksheets and Workbooks

Time: 4 hours

EXPM05

Excel 2002: Worksheets and Workbooks shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.

Working with Rows and Columns
Working with Worksheets
Linking Worksheets and Consolidating Data

Zooming and Spell-Checking
Using a Data Filter

Excel 2002: Formulas and Functions

Time: 3 hours

EXPM06

Excel 2002: Formulas and Functions shows users how to work with formulas and functions in Excel 2002 worksheets.

Working with Formulas
Using References and AutoSum
Entering Functions

Using Basic and Date Functions
Using Financial and Logical Functions

Excel 2002: Charts and Objects

Time: 2 hours

EXPM07

Excel 2002: Charts and Objects shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.

Creating Charts
Modifying and Printing Charts

Working with Objects
Drawing Lines and Shapes