From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use AutoSum to simplify and accelerate formula creations

Use AutoSum to simplify and accelerate formula creations - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use AutoSum to simplify and accelerate formula creations

“

- [Instructor] Excel has over 500 built-in functions and probably the most common function for most Excel users is the SUM function, SUM. And the SUM calculation can be accessed also by way of buttons. On the home tab off to the right is what's called an AutoSum button in the editing group. Notice it has a tiny drop arrow to its right. And on the formulas tab, the same button, much larger located on the left side and it too has a drop arrow. We can also use the SUM button to get to other functions as well. In its most basic use, we're adding up totals often from the left or from above. I've got some revenue numbers in row 7 I want a total on the right. What can I do? I could click AutoSum in either of its locations. That looks good. I'll press enter. If you've used this more than a few times, you probably have discovered that rather than pausing, why not double click AutoSum, click, click. There we go. Many…

Contents