From the course: Excel 2010 Essential Training

Unlock the full course today

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

Working with numbers in columns

Working with numbers in columns - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Working with numbers in columns

“

Now if you've completed the exercise on adding a whole worksheet at once or one of the AutoSum movies, you should have a worksheet that looks something like this. So we have our Totals column. We added across all the rows. We have the totals down here. We added down all the columns. But there are a few other things that we might want to know about these numbers. So let's click down here in Cell A15 and type the word Average. We want to know what the average is of these numbers. I'll just press Tab. So we'll use the Average function. I'll type =Average. Now by the time I type the first four letters of the word average, you see Excel is suggesting that I probably want the Average function. So I'll just press the Tab key and Excel will fill in the rest. So we want the average of what? Well, we want the average of these numbers in January. So just drag over those numbers. Be sure you don't drag anywhere below Row 12. You just want San Francisco through Boston, and that's it. Just press…

Contents