	Online Excel 2000 MOS Series (21 hours)

Summary:
This series is designed to help users prepare for the MOS Excel Core examination. The series begins with basic Excel tasks, such as entering and editing data, using Find, Replace, and AutoFill, and creating hyperlinks. It also covers locating, opening, and saving files, and using the help function, Office Assistant. Formatting worksheets is covered in detail, including cell and number formatting, adjusting rows and columns, and the use of AutoFormat, styles, and Format Painter. More advanced topics covered include page setup, managing worksheets and data, and creating formulas and functions. An overview of charts and objects, including the Chart Wizard, is also provided.

Audience:
This series is for anyone preparing for the MOS Excel 2000 Core certification exam.

ONLINE TRAINING INCLUDES

* Interactive online courses.
* Low prices (Only $39.95)
* A full year of complete and unlimited access to your course.
* Return to you courses as many times as you like.
* Assessment tests and certificates (if passed) after each course.

1. WORKING WITH CELLS
Time: 4 hours

This course shows how to enter and edit data in Excel 2000 worksheet cells and how to create hyperlinks.

OBJECTIVES:
* Enter data
* Edit one or more cells
* Find and replace values
* Use the AutoFill feature to create series
* Create and edit hyperlinks

TOPICS:
* Entering Data
* Editing a Cell
* Editing Multiple Cells
* Replacing Values and AutoFilling
* Creating Hyperlinks

2. WORKING WITH FILES
Time: 3 hours

This course shows how to locate, open, and save files in Excel 2000.

OBJECTIVES:
* Open files
* Save files
* Send a workbook via e-mail
* Save a worksheet or workbook as a Web page
* Use the Office Assistant

TOPICS:
* Opening Files
* Saving Files
* Files and the Internet
* Using the Office Assistant

3. FORMATTING WORKSHEETS
Time: 4 hours

This course shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2000 worksheet.

OBJECTIVES:
* Format cells
* Adjust alignment and indentation of text in cells
* Adjust rows and columns
* Format numbers
* Use the AutoFormatting feature
* Define, apply, and remove a style

TOPICS:
* Formatting Cells
* Adjusting Cells
* Adjusting Rows and Columns
* Formatting Numbers
* Using AutoFormatting and Styles

4. PAGE SETUP AND PRINTING
Time: 2 hours

This course shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2000 worksheets.

OBJECTIVES:
* Preview worksheets, workbooks and Web pages
* Change page setup
* Set up headers and footers
* Set print options
* Print worksheets, workbooks, and selections

TOPICS:
* Previewing
* Page Setup
* Headers, Footers, and Titles
* Printing

5. WORKSHEETS AND WORKBOOKS
Time: 3 hours

This course shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.

OBJECTIVES:
* Insert and delete rows and columns
* Hide and unhide rows and columns
* Freeze and unfreeze rows and columns
* Move between worksheets in a workbook
* Rename, insert, delete, move, and copy worksheets
* Link worksheets, consolidate data, and check spelling

TOPICS:
* Working with Rows and Columns
* Working with Worksheets
* Linking Worksheets and Consolidating Data
* Zooming and Spell-Checking

6. FORMULAS AND FUNCTIONS
Time: 3 hours

This course shows how to work with formulas and functions in Excel 2000 worksheets.

OBJECTIVES:
* Enter and revise formulas
* Use absolute and relative references
* Use the AutoSum feature
* Enter and use basic functions
* Enter and use date functions, financial functions, and logical functions

TOPICS:
* Working with Formulas
* Using References and AutoSum
* Entering Functions
* Using Basic and Date Functions
* Using Financial and Logical Functions

7. CHARTS AND OBJECTS
Time: 2 hours

This course shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in Excel 2000 worksheets.

OBJECTIVES:
* Use the Chart Wizard to create a chart
* Modify charts
* Preview and print charts
* Insert, move, and delete an object (picture)
* Create and modify lines and objects

TOPICS:
* Creating Charts
* Modifying and Printing Charts
* Working with Objects
* Drawing Lines and Shapes