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.