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