**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**

Microsoft Excel 2000 MOS Online Course Details

Total Lessons: 7
Total Time: 21 hour(s)
Subscription Term: 12 month(s)

Click Here to buy the MOS-E2K Online Course Tutorial Now!

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.

Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment

Lesson 1 Working with Cells - 4 hours

Objectives: After completing this lesson, students will be able to:
* Enter data
* Edit one or more cells
* Find and replace values
* Use the AutoFill feature to create series
* Create and edit hyperlinks

Lesson 2 Working with Files - 3 hours

Objectives: After completing this lesson, students will be able to:
* Open files
* Save files
* Send a workbook via e-mail
* Save a worksheet or workbook as a Web page
* Use the Office Assistant

Lesson 3 Formatting Worksheets - 3 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 4 Page Setup and Printing - 2 hours

Objectives: After completing this lesson, students will be able to:
* Preview worksheets, workbooks and Web pages
* Change page setup
* Set up headers and footers
* Set print options
* Print worksheets, workbooks, and selections

Lesson 5 Worksheets And Workbooks - 3 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 6 Formulas and Functions - 3 hours

Objectives: After completing this lesson, students will be able to:
* 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

Lesson 7 Charts and Objects - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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