Excel Protection and Data Validation (Intermediate/Advanced) Online
Protection and Data Validation in Excel
- Protecting Sheets
- Protecting Cells
- Adding Data Validation Rules including drop down lists
To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password.
A data-validation rule is a rule concerning what kind of data can be entered in a cell. When you select a cell that has been given a rule, an input message tells you what to enter, as shown here. And if you enter the data incorrectly, an error alert tells you as much, also shown. A data-validation rule in action.
Online training will be delivered via MS Teams. You will receive joining instructions before your selected session.
At the end of the session all delegates will:
On successful completion of this course you will be able to:
- Protect worksheets and workbooks in Excel
- Add Data Validation Rules to a worksheet
About the course
|Intended Audience||Regular users of Excel or those who have completed Excel Introduction topics|
|Required Experience / Training||Comfortable with the content of the Excel Introduction topics Quiet room with access to MS Teams and headset or headphones|
|Duration of Training||1 hour|
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.