Verifying Excel 2010 Data and Formulas

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

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
60 minutes

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.


Correcting Formulas and Data and Validating Data

  • 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




    Multi-license discounts available for Annual and Monthly subscriptions.