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