Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
What we have in this worksheet is the beginning or maybe close to the ending of a simple basic expense report. And I want to show you few editing techniques before we go and use this. First thing you can see this Column A is not quite wide enough. Now you may know already but if you put your mouse pointer up here in the header in the border between Column A and Column B, when you get that two-headed mouse pointer, you can just sort of click and drag to the right. But how far you are supposed to go. Maybe you went too far, maybe not far enough. I am just going to press Ctrl+Z to undo.
A little tip here is when you get that two-headed arrow there between two columns, if you double- click the column auto fits. So it's now as wide as the widest item in the column. That's pretty cool. Now, let's fill in the months. You may know already to auto fill, so if you click on January, put the mouse pointer on that little Auto Fill dot in the lower right corner. Make sure the mouse pointer is a crosshair. It has to be the crosshair. And if you drag that out, you can fill in the months. And I'll just go over here and type the word Total. And let's take a look at the numbers.
If you want to fill-in these numbers fairly quickly, what you do is this. Let's select the whole range. So that's all three months. That's all the cities. Now, in this selected area, you notice that the cell in the upper left corner is a little different. If you hit the Enter key, you notice that the active cell is just in that selected area. So there is always one active cell no matter what is selected. Well, here is what we do. Let's go down here to the number for Dallas and January and let's just type in 7532, press Enter, and the number here is 2589 for Boston.
Now, that's the end of Column B in that selected area. When you press Enter, it just cycles back to the top of the next column. So I'll put in 3421 for San Francisco. And I'll simply hit the Enter key, and then when I get down to Boston for February, I'll put in say 2080. And when I Enter, I go up to the top the next column. So if you select an area like that, you could fill the numbers fairly quickly. And if you are using a full-size keyboard that has a numeric keypad on the right side, then you can type those numbers in using this selection technique and get things done very quickly.
It's a lot faster than using the numbers across the top of the keyboard. Okay, that's great! But before you actually start adding some numbers here, we need to talk a little bit about the order of operations. So here is a little math test for you. What is the right answer to 2 plus 3 times 4? Sounds simple, doesn't it? Well, is the correct answer 20? Or is the correct answer 14? Well, here is how you can figure out? The order of operations priority goes to parenthesis.
Second priority is exponents, but that's if you are raising the number to a power like squaring the number or cubing the number. Multiplication and division come next. It doesn't matter what you do first, multiplication or division. And then, addition and subtraction. Again, it doesn't matter what you do first, addition or subtraction. So the answer to 2+3*4 is you multiply 3*4 first and then add 2. So the correct answer is 14. The easiest way to remember this, you may remember this from school, is please excuse my dear Aunt Sally.
Excel does it the same way that you will do it on pencil and paper.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64872 Viewers
80 Video lessons · 124406 Viewers
52 Video lessons · 60330 Viewers
59 Video lessons · 46155 Viewers