From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Unlocking cells and protecting worksheets
From the course: Excel 2016 Essential Training
Unlocking cells and protecting worksheets
- Excel has any number of different protection schemes. And when you work with Excel sometimes it's just a simple question of hiding data and that's good enough. We're looking at a worksheet called worksheet protection, it's in the workbook 11- Security&Sharing. Let's imagine you're an HR manager and this is a list of all the employees. And you've got a couple of assistants and from time to time some changes need to be made. Maybe you're looking at a sheet of paper and you're making some marks on it. This needs to be changed that does, whatever. Now the people who work for you don't necessarily know Excel that well. They might not need to know it too well. And you're concerned about some changes to this file. There's a formula in column E that calculates Years, based on the hire date. You may or may not have seen how to use a function called DATEDIF, it's not too critical. But on your sheet of paper, this hire date needs to be changed to 03. Now someone looking at this might say well…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.