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.
Pre-requisites: Basic familiarity with Excel formulas
Version: Suitable for 2010, 2013, 2016 and Office 365
Learning Outcomes
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
Course Outline
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
Resources & Precourse Work
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.