Learning to use the AutoSum button and its keystroke shortcut will save you a ton of time and simplify the creation of many formulas. This feature facilitates the use of other functions like AVERAGE, MIN, and MAX and you can use it to create totals on the right and bottom of ranges containing numbers.
- [Voiceover] One of Excel's most valuable tools…when working with formulas, is the AutoSum button.…And we're looking at a worksheet called "AutoSum".…On the right side of the home tab in the ribbon…you'll see the AutoSum button,…along with a drop arrow to the right,…giving you some other capabilities as well.…You will also find the AutoSum button on the…formulas tab in the ribbon off to the left.…Much bigger button here with that same drop arrow.…Anytime we want to add data from the…left or from above, we can use this feature.…
We can also use it in other situations as well.…There's also a keystroke shortcut.…I'm about to put a total in cell G2.…I can click the AutoSum button in either of it's locations.…It immediately exposes what it's about to do.…And probably 99 percent of the time…it does exactly what you want it to do.…You'll simply press Return.…And we're about to do the same thing cell B8.…Now not only we can we use the AutoSum button…but we can use a faster alternative, a keystroke shortcut,…Command, Shift, T, and here there's no pause.…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Save time with AutoSum and extended features