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.

 

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information