Dennis demonstrates how to create AutoCorrect shortcut codes, use auto decimal point, and create custom lists.
- [Instructor] If you find yourself using a certain word…or phrase often, not only does it become tedious…but from time to time you mistype the entry.…On this worksheet here is a phrase,…I've been using it frequently,…Environmental Health & Safety.…I get tired every time I type it,…sometimes I do make those mistakes.…So, let's use a feature called autocorrect…which is actually designed to correct misspellings…but we can use it in a different way,…one that will cut down on errors.…I'm going to double click this cell…and highlight the text and press CTRL C to copy it.…
Escape and then in the ribbon menu go to File,…Options, Proofing, off to the right, AutoCorrect Options.…Every time I type a code,…a combination of letters I'll make up,…I want to see that phrase.…So, I'll paste it here with CTRL V,…that's what I copied earlier,…I'm going to use the letter Q which doesn't turn up…in English too much followed by the letter U,…I'm going to use QE, that's my shortcut.…Every time I type that followed by space,…punctuation or enter,…
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