Viewers: in countries Watching now:
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
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.
There are currently no FAQs about Excel 2010 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.