Excel Protection and Data Validation (Intermediate/Advanced) Online
Topics covered
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
| Course Code | MLCSU-TR0034 |
|---|---|
| Intended Audience | Regular users of Excel or those who have completed Excel Introduction topics |
| Delivery Method | Online |
| 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 |
Premium Content
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.