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
3 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 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.

 

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.


Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.