Overview:
The focus of this course is to learn commands than can help to minimize user errors and mistakes. Explore many different Protection related commands. See how data validation command rules like drop downs increase data integrity. Learn about how using templates and hiding formulas can make spreadsheet less prone to mistakes and errors.
Areas Covered in the Session:
- Protect spreadseets by controlling what types of changes users can make
- Control allowing Editing in certain ranges
- Protect the Workbook structure, Read-only, Passwords, and related commands
- Use TemplatesÂ
- Hide rows, columns, sheets, formulas
- Set Data Validation rules to limit type of data entered (includes drop downs)
Who Will Benefit:
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals