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.
Adding a whole worksheet - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Adding a whole worksheet
Now if you have completed the exercise in the movie about using the AutoSum function in the AutoSum tool, you will have a worksheet that looks pretty much like this. Well, any numbers manually using the cherry pick method is okay. Using the AutoSum tool and Auto Fill are even better but, when you have a worksheet like this that's compact, you don't have any blank columns, you don't have any blank rows, you can add up the numbers very, very quickly. You don't have to write even a single formula. So let's select all the numbers going down that column and press Delete. Let's select the numbers going across the Total row and press Delete. So again, you have just your data and their totals. Here's what you want to do. Let's select cells starting from the very first number, select down and across. So you have not only all of your input data selected but your Total column is the last column selected and your Total row is the last row selected and all you have to do is click the AutoSum tool…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Understanding formulas and functions4m 41s
-
Entering data in a worksheet3m 22s
-
Adding numbers manually5m 1s
-
Adding numbers using Sum and AutoSum6m 11s
-
Adding a whole worksheet1m 48s
-
Working with numbers in columns4m 53s
-
Preventing errors using absolute references5m 57s
-
Working with times and dates3m 7s
-
Using IF4m 49s
-
Using SUMIF and AVERAGEIF4m 15s
-
Naming and using cell ranges3m 45s
-
-
-
-
-
-
-
-
-
-
-
-
-