Excel: Data Validation and Protection
Duration15'
No. of mini-lessons8
ResourcesTranscript
Duration 15'
No. of mini-lessons 8
Resources Transcript
Course overview
Sometimes, the data your employees work with is sensitive, requiring extra precautions. This might involve setting rules for the data being entered or restricting access. With Excel, they can do both, ensuring their data provides what they need while staying protected.
This course will show them how to use data validation and protect their data. It focuses on setting rules and conditions with the data validation tool and encrypting workbooks with passwords. Each video covers a specific action they can take, allowing them to choose what they want to learn at a pace that suits them.
What's covered
Data validation and creating drop-down lists
Conditional formatting
Protecting and encrypting workbooks
Locking and unlocking cells
Using the “allow edit ranges” feature
Adding input messages and error alerts
Why your teams need this course
This course is ideal for anyone who’s familiar with Excel and wants to set rules or conditions for their data, or wants to protect it. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
