Courses

Excel: Data Validation and Protection

Excel: Data Validation and Protection

Price:

$3.00

Description:

<p id="isPasted">Sometimes, the data we work with is sensitive, and extra precautions need to be taken. This might be in the form of setting rules for the data that’s entered or by restricting access. With Excel, you can do both these things, ensuring your data gives you what you need, but remains protected. </p><p><br></p><p>This course will show you how to use data validation and how to protect your data. It’ll focus on setting rules and conditions with the data validation tool, and encrypting your workbook with passwords. Each video will cover a specific action you can take, so you can choose exactly what you want to learn, at a pace that suits you. </p><p><br></p><p><strong>This course contains useful information on: </strong> </p><p><br></p><p>• Data validation </p><p>• Creating drop-down lists </p><p><strong>• </strong>Conditional formatting for data validation </p><p>• Protecting worksheets and workbooks</p><p>• Encrypting workbooks with passwords</p><p>• Locking and unlocking cells </p><p>• Using the “allow edit ranges” feature </p><p><strong>• </strong>Adding input messages and error alerts </p><p><br></p><p><strong>Why take this course?  </strong></p><p><br></p><p>Making sure your data gives you what you need can be useful for anyone, and protecting data is essential when it’s sensitive information. 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, you’ll need access to a computer and Microsoft Excel. </p><p><br></p><p>15 mins | SCORM |<strong id="isPasted"> </strong>Transcript</p>