Dennis demonstrates how to use shortcuts and he provides tips and techniques.
- [Instructor] Excel has any number…of different shortcuts, tips, techniques…that'll make your work with the software more efficient,…and also avoid typing errors and entry errors.…First of all, in this worksheet called Miscellaneous Tips,…if you look in the lower right-hand corner,…you'll see the zoom factor is 85%.…Now, I can read the data; maybe you can't read it so easily.…It's there, but why not zoom in?…And you can easily zoom in.…You don't necessarily have to use that slider bar…in the lower right-hand corner.…Nothing wrong with that, by the way.…But any time you want to zoom in,…see the data larger and clearer,…you're less likely to make typing mistakes…and other kinds of formatting and formula mistakes as well.…
Hold down the Control key, use the wheel on the mouse.…Zoom in, make things large and clear on your screen.…As you wish, you can do that at any time.…And obviously no impact on the content itself.…In this worksheet, there are three column headings here…that have something in common.…There are built-in format for these entries.…
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