The seven courses in this series provide the necessary training to help students prepare for the Excel 2000 core exam. This series was designed and created to meet the strict content guidelines specified by Microsoft, and has received the Microsoft Office User Specialist (MOUS) logo. There are no prerequisites for these courses, however, basic knowledge in the use of Windows 98 is recommended. All seven courses must be taken to obtain the minimum necessary training needed to help students prepare for the certification exam. |
Excel 2000 MOUS: Working with Cells shows users how to enter and edit data in Excel 2000 worksheet cells and create hyperlinks.
- Entering Data
- Editing a Cell
- Editing Multiple Cells
|
- Replacing Values and AutoFilling
- Creating Hyperlinks
|
|
Excel 2000 MOUS: Working with Files shows users 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 shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in a Excel 2000 worksheet.
- Formatting Cells
- Adjusting Cells
- Adjusting Rows and Columns
|
- Formatting Numbers
- Using AutoFormatting and Styles
|
|
Excel 2000 MOUS: Page Setup and Printing shows users how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2000 worksheets.
|
- Headers, Footers, and Titles
- Printing
|
|
Excel 2000 MOUS: Worksheets & Workbooks shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling 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 shows users 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 shows users 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
|
|
|