Rapid formula creation


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

Rapid formula creation

You can simplify the creation of some formulas by using entire column or row references when appropriate. In this list of over 700 names, we might want to know the Total Salary. So, right here in column O, next to the phrase Total Salary, let's do a total here for the Salaries out of column J. Now, the AutoSum button, which is found in two locations, on the Formulas tab in the Function Library left-hand side or on the Home tab, extreme right side here in the Editing group. AutoSum, let's click this.

AutoSum always makes a guess here. It makes a bad guess. We'll simply ignore it and click column J and at the indicator J:J. We're done here; there is the answer. Fast, easy, easy to read. We didn't have to drag across or type in any complex cell references. And similarly with Average Salary, take advantage of the fact that AutoSum has a drop arrow to the right of it, let's choose Average. Same idea here. It makes a bad guess. We'll click column J. We're all set. And ...

Rapid formula creation
Video duration: 3m 48s 3h 43m Intermediate

Viewers:

Rapid formula creation 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 ...