Excel 2000 MOUS Expert

Synopsis
Excel 2000 MOUS Expert: Validating and Auditing Data shows users how to validate data trace and fix errors trace precedents for a formula and trace dependents for a specific cell.

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

Time
2 hours

Product Code: E2KE05

After completing Excel 2000 MOUS Expert: Validating and Auditing Data the user should be able to:

Validate data

Use the Auditing toolbar

Trace cells referenced in a formula (precedents)

Trace formulas that depend on contents of a cell (dependents)

Validating Data
Applying data validation

Finding invalid cells

Using the Auditing Toolbar
Displaying the Auditing toolbar

Troubleshooting the Auditing toolbar

Tracing errors and fixing them

Tracing Precedents and Dependents
Tracing precedents

Tracing dependents

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 Excel 2000

A glossary

A Skill Assessment

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: Worksheets & Workbooks (E2KM05)

Excel 2000 MOUS: Formulas and Functions (E2KM06)

Excel 2000 MOUS: Charts and Objects (E2KM07)

Excel 2000 MOUS Expert: Importing & Exporting Data (E2KE01)

Excel 2000 MOUS Expert: Working with Templates Links and Report Manager (E2KE02)

Excel 2000 MOUS Expert: Formatting Sorting and Filtering Data (E2KE03)

Excel 2000 MOUS Expert: Naming Ranges Working with Macros and Customizing Toolbars (E2KE04)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation. Microsoft and the Microsoft Office User Specialist Logo are registered trademarks of Microsoft Corporation in the United States and other countries.

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.