Dennis demonstrates how to use AutoSum shortcuts to simplify formula entry.
- [Instructor] Probably the most common function…used in Excel is the Sum function, S-u-m.…And many people are familiar with…a button called Auto Sum, it's found…on the right side of the Home tab,…or somewhat larger, on the left side…of the Formulas tab.…Not so well know, it has a keystroke shortcut, Alt + =,…many times it's going to be faster.…We're about to use Auto Sum right here,…there's the Auto Sum button.…What many people do is click the button,…look at what is about to happen and press Enter.…And nothing wrong with that.…Make it a bit faster, double click…the Auto Sum button.…
Using Alt + = probably doesn't save you a lot of time here,…but Alt + =, Enter, strictly keyboard.…As always, with Auto Sum, whether you use the button…or the keystroke shortcut, Excel looks upward for data,…if it doesn't see any, it looks leftward.…Occasionally you will have a conflict there…if for example, if this cell here,…over an O7 were empty, if I were to activate Auto Sum…and wanted to add up these numbers.…What will happen if I press Auto Sum or Alt + =,…
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