Dennis demonstrates how to use workbook protection to inhibit worksheet manipulation and discusses Insert, Delete, Move, Copy, and Unhide.
- [Instructor] On this worksheet called FindFormulas,…I haven't finished it just yet, and it's in disarray.…But it's some semi-confidential data I'm working on…regarding pricing techniques.…Now, maybe this is a workbook that others use.…You can hide a worksheet.…In fact, if you right click any sheet tab,…as I'm doing right now,…you will see you can Hide,…and if Unhide is selectable,…one or more other worksheets are hidden.…So, I'm going to click Unhide.…There's another worksheet out there already…that we're not seeing.…I can click OK to unhide it, and there it is.…
Now, here too, these are projections…for the following year.…Maybe we don't want this to be visible,…and yet we're in an environment where different people…can access this.…Now, I think you know, people who understand Excel…and are familiar with hiding and unhiding…can get to locations like this…simply by right clicking a tab and unhiding.…So, we're not talking about heavy duty protection, here.…But you can protect a workbook.…If you go to the Review tab in the ribbon,…
Dennis begins with the basics—how to display data so that errors can be easily spotted. Next, he offers handy tips to ensure data is entered correctly the first time, using the AutoFill feature and using AutoCorrect shortcut codes for frequently used entries. Dennis provides easy ways to validate your data, which is particularly helpful when multiple team members are contributing to the same spreadsheet. This includes restricting the data that can appear in a spreadsheet by setting value limits, pre-populating data with drop-down lists, and other methods. He also shows how to avoid mistakes in formulas, how to hide data that doesn't need to be seen, and how to use workbook protection to prevent errors, and more.
- Streamlining data entry steps
- Using Excel shortcuts and automation features
- Protecting worksheets and workbooks
- Validating data
- Basing entries on formulas
- Detecting errors in formulas
- Using Range Names
- Finding mistakes in large, complex spreadsheets