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.
Now, what we'll do is create a brand- new worksheet from scratch and this is a very typical thing that you open Excel, you have a blank sheet rather than something that somebody has given to you, and you go. So let's click Cell A1 if you need to, where Column A meets Row 1, and let's just start typing. I'll say Two Trees is the name of our company, Olive Oil Company. Now when you're done typing you know you're done typing but Excel doesn't know you're done typing, and you see you have your cursor flashing there.
Well, in order to tell Excel that you're done and you want to make this permanent, you have to press the Enter key. If you start typing, let's say go down here and type Sales, if you don't press Enter nothing happens and in fact if you hit the Escape key, then it goes away. Now that's not an undo because you haven't done anything yet. So let's type in, again, let's say Sales of bath soap, first half of year. And again, you know you're done typing, you have to tell Excel.
So we press Enter and notice also that when you press Enter, you're not just entering what you're doing. You're also going down one row below. We'll talk about that also in a little bit. So let's click back on this and it looks like we have some words in A2 and that you have other words in the other cells. But that's not what's really happening. When you have A2 selected, look up here, in the formula editing bar, you see all of the text and if you go to cell B2 or C2, D2, you notice that the formula editing bar is empty.
So what's happening is the text is really contained in A2. It's just kind of borrowing the space next to it. Well, what happens if you go here into B2, which is the formula editing bar? It tells you it's empty and available to type. Let's just type in some stuff and Enter. Now you notice that the text isn't continuing because there is text in the way. Cell B2 is filled. If you take that and delete, now your text can continue. All right, let's put some other things in here. Let's go here to A5 and let's type in Region. I want to say what region of the companies we are looking at.
Let's put in say North, South, Central, and West. Okay, and let's put in the months. So let's go over here and I'll type January and I'm just going to hit the Tab key to get to the next cell or I could hit the Right arrow key to get to the next cell. And there is an easier way to type in the months that we'll look at in a little while, but right now, we just want to do this. Now here's something that's kind of important. When I'm done typing, and I see a lot of new Excel users will do this, they'll type in a whole sheet and when they get to the very last cell they're typing in, they just kind of sit there.
Well, you can't do that. You have to press Enter. But here's what's also important is, instead of pressing Enter and going down one row, what if I wanted to Enter and stay put on cell G5? Well, instead of pressing the Enter key by itself, hold down the Ctrl key and press Enter and that way you can enter G5 and stay put on G5. Well, let's look at a few editing techniques here. You can use the four cursor keys on your keyboard to navigate up, down, right, and left. Let's go out here.
If you hit the Home key, you zip all the way to Column A but staying in the same row. If you press Ctrl+Right arrow, you stay in the same row and go all the way to the last column. You could do this going up or down also. If you press Ctrl+Home, you get to the first cell, Cell A1. If you press Ctrl+End, not Ctrl+N like New File, but END, that brings you to the end of the worksheet. Now let's look at a few editing techniques here. Let's say instead of June, I wanted this to be a Total column.
Well, you can click it and just delete and that gets rid of it and I'm going to undo and you have your Undo button up here where you could press Ctrl+Z to undo. Ctrl+Z works in every program, whether it's Microsoft or not, and if you have a hard time remembering that, you might go on to think that Z stands for Zap, the last thing I did. Well, if I want to put the word Total here, I could just type the word Total. I don't have to delete anything. I'll just press Ctrl+Enter to stay put on that cell. Now, what if I wanted to edit what's in one of the cells? Well, a few things I could do is maybe if I wanted this to say Regions instead of Region, I could just double-click and that puts my cursor in there and I can type.
I'm just going to escape out of there. Or when your cell is selected you can click up here in the formula editing bar and you can type. I'm just going to escape out of there or you could press the F2 key on your keyboard and that will also let you edit. So there's three ways that you could edit. Well, here's a nice little technique. If you want to select one word in a cell that has bunch of things, so, for example, Sales of bath soaps first half year, we have a bunch of words in here. What if I wanted to select the word Sales only and not the rest of the words and that cell is not active, that's two double-clicks.
The first double-click puts your cursor in the cell; the second double-click selects the word. So I'm going to put my mouse pointer on the word Sales. First double-click inserts the cursor, second double-click selects the word, and now if I want to type something like Volume or whatnot. So that's a handy thing to do. Again, I'm just going to press Escape to get out of there. So now that you know some handy editing techniques, you really want to keep them in mind because it's going to make your life in Excel a heck of a lot easier and remember some of those shortcuts too. I think you're going to like those.
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.