Excel 2000 MOUS Series

Excel 2000 MOUS Series
Total Time: 21 hours

Excel 2000 MOUS: Working with Cells

Time: 4 hours

E2KM01

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

Entering Data
Editing a Cell
Editing Multiple Cells

Replacing Values and AutoFilling
Creating Hyperlinks

Excel 2000 MOUS: Working with Files

Time: 3 hours

E2KM02

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

Opening Files
Saving Files

Files and the Internet
Using the Office Assistant

Excel 2000 MOUS: Formatting Worksheets

Time: 4 hours

E2KM03

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

Formatting Cells
Adjusting Cells
Adjusting Rows and Columns

Formatting Numbers
Using AutoFormatting and Styles

Excel 2000 MOUS: Page Setup and Printing

Time: 2 hours

E2KM04

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

Previewing
Page Setup

Headers, Footers, and Titles
Printing

Excel 2000 MOUS: Worksheets & Workbooks

Time: 3 hours

E2KM05

Excel 2000 MOUS: Worksheets & Workbooks shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.

Working with Rows and Columns
Working with Worksheets

Linking Worksheets and Consolidating Data
Zooming and Spell-Checking

Excel 2000 MOUS: Formulas and Functions

Time: 3 hours

E2KM06

Excel 2000 MOUS: Formulas and Functions shows how to work with formulas and functions in Excel 2000 worksheets.

Working with Formulas
Using References and AutoSum
Entering Functions

Using Basic and Date Functions
Using Financial and Logical Functions

Excel 2000 MOUS: Charts and Objects

Time: 2 hours

E2KM07

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

Creating Charts
Modifying and Printing Charts

Working with Objects
Drawing Lines and Shapes