Home · Course Details

Learn how to find and fix common errors in spreadsheets and how to create models that have built-in error prevention mechanisms to help maintain data integrity.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Experienced
  • Pre-requisites: Basic familiarity with Excel formulas
  • Version: Suitable for 2010, 2013, 2016 and Office 365

  • Understand error types
  • Use Auditing tools to trace errors in spreadsheets
  • Use Data Validation to prevent data input errors
  • Protect workbook data to prevent data input errors

Topics covered include:
  • Formula Auditing
  • Data Validation
  • Using the Formula Auditing Toolbar
  • Error Checking Options
  • Trace Error
  • Data Validation
  • Entering Data in a Validated cell
  • Setting up a Validation Rule
  • Creating Input and Error Messages
  • Displaying Error Messages
  • Protecting Workbooks
  • Worksheet Protection
  • Unlocking Cells
  • Setting Worksheet Protection
  • Password Protection

No pre/post work required

Name Date Time Location Cost

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.