Join Bob Flisser for an in-depth discussion in this video Working with numbers in columns, part of Excel 2010 Essential Training.
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 Ctrl+Enter and it gives us that average.…
Author
Released
6/9/2010- Copying and pasting techniques
- Working with formulas and functions
- Dealing with formula errors
- Creating lookup tables
- Naming cell ranges
- Formatting data and worksheets
- Finding and replacing data
- Creating SmartArt diagrams
- Creating charts and PivotTables
- Recording macros
- Sharing workbooks
Skill Level Beginner
Duration
Views
Related Courses
-
Excel 2010: Tips, Tricks, and Shortcuts
with Dennis Taylor3h 43m Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate -
Android Essential Training (2017)
with Dan Gookin2h 44m Appropriate for all
-
Introduction
-
Welcome53s
-
-
1. Getting Started
-
Touring the interface3m 38s
-
2. Worksheet Basics
-
Creating a worksheet5m 23s
-
Targeting large data groups4m 26s
-
-
3. Excel Formula Basics
-
Entering data in a worksheet3m 22s
-
Adding numbers manually5m 1s
-
Adding a whole worksheet1m 48s
-
Using IF4m 49s
-
Using SUMIF and AVERAGEIF4m 15s
-
Naming and using cell ranges3m 45s
-
4. Essential Formatting
-
Adding pictures and shapes7m 19s
-
5. Advanced Formatting
-
Inserting SmartArt6m 54s
-
Applying built-in styles3m 16s
-
Creating and sharing styles5m 33s
-
Using templates4m 9s
-
-
6. Printing Preparation
-
Making the pieces fit4m 57s
-
Printing and PDFs4m 34s
-
-
7. Large Excel Projects
-
Finding and replacing data3m 12s
-
Managing worksheets7m 23s
-
-
8. Collaborating with Others
-
Setting workbook permissions6m 44s
-
Sharing a workbook1m 25s
-
Tracking changes3m 5s
-
Saving files in shared locations10m 29s
-
9. Exploring Excel's Database Features
-
Creating lookup tables6m 3s
-
10. Analyzing Data
-
Working with Goal Seek5m 29s
-
Using scenarios in formulas5m 28s
-
11. Advanced Analysis with PivotTables
-
Discovering PivotTables2m 22s
-
Creating a basic PivotTable2m 46s
-
Modifying a PivotTable6m 57s
-
-
12. Creating and Using Charts
-
Choosing chart types1m 55s
-
Inserting Sparklines3m 54s
-
Creating a column chart3m 23s
-
Modifying a column chart5m 47s
-
-
13. Creating and Using Macros
-
Understanding macros3m 5s
-
Editing a macro6m 50s
-
-
14. Customizing Excel
-
Customizing the Ribbon bar8m 44s
-
Setting Excel options8m 19s
-
Conclusion
-
Goodbye16s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Working with numbers in columns