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 numbers manually - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Adding numbers manually
If you completed your expense report worksheet from the movie on entering data, then you should have a worksheet that looks something like this. I want to show you how to add numbers. Now, adding numbers is probably the most common calculation that you could do in Excel. And it's so common that there are whole bunch of different ways to do it, probably about a half dozen different ways. So let's start off simple. I'm going to show you the basic manual way. I kind of think of it as the Cherry Pick method. So we want to start off by adding across Row 6. We want to add the numbers here for San Francisco. So click on cell E6, and in E6 we want to say add this number and that number and that number. Well, we know that every formula, every function starts off with an equal sign. So type in an equal sign. As soon as you do, you're in Editing Mode, and you can see the toolbar is mostly grayed out because we're editing. So we want to click that first number here. Here click that 6100. As soon…
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
-
(Locked)
Entering data in a worksheet3m 22s
-
(Locked)
Adding numbers manually5m 1s
-
Adding numbers using Sum and AutoSum6m 11s
-
(Locked)
Adding a whole worksheet1m 48s
-
(Locked)
Working with numbers in columns4m 53s
-
Preventing errors using absolute references5m 57s
-
(Locked)
Working with times and dates3m 7s
-
(Locked)
Using IF4m 49s
-
(Locked)
Using SUMIF and AVERAGEIF4m 15s
-
(Locked)
Naming and using cell ranges3m 45s
-
-
-
-
-
-
-
-
-
-
-
-
-