Microsoft Excel 2000 MOS

Topics: 7

Length: 21 hours

Location: Online

This onilne excel course is designed to help you prepare for the MOS Excel Core examination. The course begins with basic Excel tasks, such as using Find, Replace, and AutoFill, entering and editing data, and adding hyperlinks. It also covers locating, opening, and saving files, along with using Office Assistant and the help function. Formatting worksheets is covered in great detail, including number and cell formatting, modifying rows and columns, and the use of AutoFormat, styles, and Format Painter.

Excel 2000 MOS: 1 Working with Cells

This topic shows how to enter and change data in Excel 2000 worksheet cells and how to make hyperlinks.

Excel 2000 MOS: 2 Working with Files

This tutorial shows how to find, open, and save Excel 2000 files.

Excel 2000 MOS: 3 Formatting Worksheets

This topic shows how to adjust and format cells, change rows and columns, and apply styles and formatting in an Excel 2000 sheet.

Excel 2000 MOS: 4 Page Setup and Printing

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

Excel 2000 MOS: 5 Worksheets and Workbooks

This chapter shows how to work with sheet columns and rows, manage sheets, and consolidate data in Excel 2000.

Excel 2000 MOS: 6 Formulas and Functions

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

Excel 2000 MOS: 7 Charts and Objects

This topic shows how to create, alter, and print charts; insert, move and remove pictures, and draw shapes and lines in Excel 2000 worksheets.