From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using SUM and AVERAGE

Using SUM and AVERAGE

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using SUM and AVERAGE

“

- In this workbook, 03 - Creating Formulas and Functions, we're looking at a worksheet called Sum Average. Sum and Average represent two of the most commonly used functions in Excel, and there are some shortcuts here. If we're about to create a total in cell G2 we can use the function Sum. We can type =sum, left (, and highlight these cells, and press Enter, we've got an answer. Now, potentially a faster way to do this is to use a feature called the AutoSum button. On the Home tab you'll see it here off to the right in the Editing group, there's AutoSum. There's a keystroke shortcut referred to below it, Alt + =. If we click AutoSum in cell G2 Excel says, "I see numbers to the left, let's add them." Press Enter, we've got our total. That's likely to be faster than typing in the entry. Now, you can get there a little bit faster. Why not just double click AutoSum, there we are, rather than pressing AutoSum and then Enter? If you press Alt + = you will have to press Enter. But at other…

Contents