Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


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.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.