How to Work with Numbers in Columns in Microsoft Excel 2010


show more Working with numbers in columns provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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...

Working with numbers in columns
Video duration: 4m 53s 6h 21m Beginner

Viewers:

Working with numbers in columns provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...