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 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) |
|
Microsoft® is a registered trademark of Microsoft Corporation.
Excel® is a registered trademark of Microsoft Corporation.
|