Excel 2000 MOS - Online Course

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.

This series is for anyone preparing for the MOS Excel 2000 Core certification exam. This online course contains 7 lessons and should take approximately 21 hours to complete.

Lesson 1: Working with Cells (4.0) hours

Working with Cells teaches you how to enter data, edit one or more cells, find and replace values, use the AutoFill feature to create series, and create and edit hyperlinks. This course shows how to enter and edit data in Excel 2000 worksheet cells and how to create hyperlinks. Topics include Entering Data, Editing a Cell, Editing Multiple Cells, Replacing Values and AutoFilling, and Creating Hyperlinks.

Lesson 2: Working with Files (3.0) hours

Working with Files teaches you how to open files, save files, send a workbook via e-mail, save a worksheet or workbook as a Web page, and use the Office Assistant. This course shows how to locate, open, and save files in Excel 2000. Topics include Opening Files, Saving Files, Files and the Internet, and Using the Office Assistant.

Lesson 3: Formatting Worksheets (4.0) hours

Formatting Worksheets teaches you how to format cells, adjust alignment and indentation of text in cells, adjust rows and columns, format numbers, use the AutoFormatting feature, and define, apply, and remove a style. This course shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2000 worksheet. Topics include Formatting Cells, Adjusting Cells, Adjusting Rows and Columns, Formatting Numbers, and Using AutoFormatting and Styles.

Lesson 4: Page Setup and Printing (2.0) hours

Page Setup and Printing teaches you how to preview worksheets, workbooks and Web pages, change page setup, set up headers and footers, set print options, and print worksheets, workbooks, and selections. This course shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2000 worksheets. Topics include Previewing, Page Setup, Headers, Footers, and Titles, and Printing.

Lesson 5: Worksheets and Workbooks (3.0) hours

Worksheets and Workbooks teaches you how 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, and link worksheets, consolidate data, and check spelling. This course shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets. Topics include Working with Rows and Columns, Working with Worksheets, Linking Worksheets and Consolidating Data, and Zooming and Spell-Checking.

Lesson 6: Formulas and Functions (3.0) hours

Formulas and Functions teaches you how to enter and revise formulas, use absolute and relative references, use the AutoSum feature, enter and use basic functions, and enter and use date functions, financial functions, and logical functions. This course shows how to work with formulas and functions in Excel 2000 worksheets. Topics include Working with Formulas, Using References and AutoSum, Entering Functions, Using Basic and Date Functions, and Using Financial and Logical Functions.

Lesson 7: Charts and Objects (2.0) hours

Charts and Objects teaches you how to use the Chart Wizard to create a chart, modify charts, preview and print charts, insert, move, and delete an object (picture), and create and modify lines and objects. This course shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in Excel 2000 worksheets. Topics include Creating Charts, Modifying and Printing Charts, Working with Objects, and Drawing Lines and Shapes.