Verifying Excel 2010 Data and Formulas


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Formulas are an integral and important feature of Excel 2010. So ensuring they are correct can save you time and a lot of headaches. Excel 2010 provides you with the tools you need to audit formulas and correct errors that may be found. In addition, using Excel's data validation tools you can restrict the types of data that can be input to your workbooks – preventing data entry errors that could otherwise occur. This course describes Excel 2010's auditing and formula correction features and shows you how to use data validation to avoid worksheet errors.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
1.0

Lesson Objectives

Verifying Excel 2010 Data and Formulas

  • use Excel's formula auditing tools to evaluate and correct formulas
  • use the Watch Window to inspect, audit, or confirm formula calculations and results
  • use data tools to convert text to columns and remove duplicates
  • add data validation to worksheet cells
  • list the different things you can use data validation for
  • use error checking to identify a formula error
  • separate text in one column into two columns
  • restrict data entry in specific cells
  • Course Number:
    mo_aexl_a04_dt_enus

    Expertise Level
    Intermediate