Skip to main content Help with accessibility Skip to main navigation
Updated on: 28-06-2021

Excel Intermediate/Advanced Protection - Online

At the end of the session all delegates will:

Protect worksheets and workbooks in Excel.

Topics covered

Protection and Data Validation in Excel

  • Protecting Sheets
  • Protecting Cells
  • Adding Data Validation Rules

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.

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.

 

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
Duration of Training Between 30 minutes and 1 hour

Login