Excel 2000 MOS Expert Series: Validating and Auditing Data
Product Code: E2KE05 Time: 2.0 hour(s) CEUs: Available

Summary:

This course shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.

Objectives:

After completing this course, students will 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)

Topics:

  • Validating Data
  • Using the Auditing Toolbar
  • Tracing Precedents and Dependents

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. (5.5 or higher for MindLeaders Central) Minimum Connection Speed: 28.8k. Sound card, with speaker or headphones is recommended, but not required to play the courses. Macromedia Flash Player 7.0 (Note: We do not recommend or support installation of the Yahoo toolbar.) JavaScript must be enabled. Netscape and AOL browsers not supported.


Copyright © 2005 MindLeaders. All rights reserved.