AutoSum shortcuts


show more AutoSum shortcuts provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

AutoSum shortcuts

One of Excel's best calculation tools and used in lots of formulas is the AutoSum capability. It's on the Formulas tab in the Function Library here on the left side also on the Home tab, in the Editing group on the right side AutoSum. Has little drop arrow associated with it for other related functions as well. Let's use it in its most basic form. We are in cell G2 for example we want some totals. AutoSum is designed to quickly add totals from above or from the left.

It is context sensitive. The standard way to use this would be to put the active cell here and click AutoSum, and we view what's going on and if we are relatively new with functions and formulas in Excel we might look at that for a bit and also make figure it out and say oh yeah that looks good and what do we do next? Many people press Enter and that's fine. We could also press AutoSum a second time and of course that raises the idea this could be a little bit faster couldn't it? Next time we will need t...

AutoSum shortcuts
Video duration: 2m 57s 3h 43m Intermediate

Viewers:

AutoSum shortcuts provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...