Go BackExcel 2000 MOUS: Worksheets & Workbooks

Synopsis
Excel 2000 MOUS: Worksheets & Workbooks shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.

Audience
This course is for anyone preparing for the MOUS Excel 2000 Core certification exam.

Time
4 hours

Product Code: E2KM05
After completing Excel 2000 MOUS: Worksheets & Workbooks, the user should 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

Working with Rows and Columns
Inserting and deleting rows and columns
Hiding and unhiding rows and columns
Freezing and unfreezing rows and columns
Splitting a worksheet

Working with Worksheets
Moving between worksheets in a workbook
Renaming a worksheet
Inserting and deleting worksheets
Moving and copying worksheets

Linking Worksheets and Consolidating Data
Using 3-D references in a formula
Using 3-D references in a function
Using Paste Special

Zooming and Spell-Checking
Changing the zoom setting
Checking spelling

This course has the following features:

Exercises that allow users to practice in Excel 2000
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to Excel 2000
A course index
A glossary
A Skill Assessment

Office 2000: Getting Started (O2KC01)
Office 2000: Editing Text and Printing (O2KC02)
Office 2000: Text and Document Formats (O2KC03)
Office 2000: Introduction to Excel (O2KC05)
Excel 2000 MOUS: Working with Cells (E2KM01)
Excel 2000 MOUS: Working with Files (E2KM02)
Excel 2000 MOUS: Formatting Worksheets (E2KM03)
Excel 2000 MOUS: Page Setup and Printing (E2KM04)

Excel 2000 MOUS: Formulas and Functions (E2KM06)
Excel 2000 MOUS: Charts and Objects (E2KM07)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation.

 

Go Back