Excel 2016 Check it and Protect it - Auditing and Protecting Workbooks

 One Hour
Delivery Methods

This course is designed to teach students how to prevent errors in their worksheets. Students will learn how to use various tools to evaluate formulas and how to encrypt data with passwords to prevent unwanted changes in order to make sure that everything is working properly.


Upcoming Class Dates and Times

Oh Snap!
There are no dates listed.
Please contact us to get something scheduled.

Who Should Attend

This course is intended for students who are more comfortable with Excel, requiring a fair amount of experience with formulas. The ability to audit and protect important data is an essential skill for all users, however, so beginners are encouraged to attend once they are familiar with formulas.

Course Objectives

    The goal of this course is to help students make sure that their data is accurate and secure. By the end of this course, you will be able to check formulas for errors and apply various types of protection to make sure your data is correct and stays that way.


1 - Lessons
  • Auditing Workbooks - Learn how to trace precedents, trace dependents, and evaluate formulas.
  • Applying Data Validation - Learn how to create drop down lists and restrict data entry.
  • Password Protecting a Workbook - Learn about adding and removing passwords in a workbook.
  • Protecting Cells, Worksheets, and Workbooks - Learn how to protect entire worksheets, specific cells, and workbook structure.