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.
I want to show you some copying and pasting techniques. First thing we do before even copying and pasting is I want to show you some moving techniques. Let's just select this area here. Now most of the time when you're using Excel, your mouse pointer is this big old Plus sign, but put the mouse pointer anywhere on the edge of the selected area and you see your mouse pointer becomes a four-headed arrow. When you get that four-headed arrow, you could just drag anywhere on the worksheet you want and that whole area goes together. Now I want to undo, so I could hit this Undo button over here. You could also press Ctrl+Z and Ctrl+Z will undo in every application under the sun whether it's Microsoft or not.
To remember it I always think that Z stands for zap the last thing that I did. Well, I want to copy this area. So when I get that four-headed arrow mouse pointer, let's hold down the Ctrl key on the keyboard. When you hold down the Ctrl key, see that four-headed arrow turn to a regular arrow with a little plus sign next to it. When you get that little plus sign, keep holding the Ctrl key and drag down a little bit and let go of the mouse first before letting go the keyboard and now you've copied it. We could do that again for practice. Select an area here, get a four-headed mouse pointer, hold down the Ctrl key and drag to the right and always remember to let go of the mouse first and let go of the key second.
So that's a nice handy way to be able to copy some data. I'm just going to delete that. Here's another handy tip. Let's say Column A was a little bit wider and if you put your mouse pointer up here on the border between Column A and Column B and the header, you see the mouse pointer is that two-headed arrow. That has to be up there in the header. It can't be in the worksheet and when you get that two-headed arrow, just drag to the right a little bit, just so Column A is a little wider. Now here's why we're doing that. Let's select this and just copy to the Clipboard, I'll press Ctrl+C, and let's come over here.
Now if you simply do a regular old paste, just press Ctrl+V, it pastes in, but you notice that the first column here Column J is narrow, the same width as all these others. It's not wide like it is in the original. And again, just Ctrl+Z or hit the Undo key. Let's click back there. Up here in the Home tab, you have your Paste button and if you click it, there's a whole bunch of options here. The first one is just the regular paste, just like we did before. You notice that when I move my mouse away the thing disappears. This is just a preview. We actually haven't done it yet. This is new to this version, by the way.
Now, if I go down here, now you see that Column J is as wide a Column A. So the destination columns are the same width. You can see that's a little pop-up help there. Here's another option that is really great. If you choose this one here that's Transpose and now you see what had been the rows are now the columns, what had been the columns are now the rows, just by a simple click. Now let's take a look down here. This is Paste link and you might be wondering, what the heck are all those zeros doing? Well, this is taking the values from the cells in the original and linking to the cells where you are pasting.
Now, an empty cell has a value of zero. That's why you're getting all those zeros. This one here we'll paste as a picture. You might wonder well, what's that all about? We'll click that and now you see this is a picture and you have your selection handles. Put your mouse pointer on one of these dots and now you can shrink it, you can enlarge it, and you have this little green dot on the top, put your mouse pointer there, and you can rotate it. That's interesting but why would I want to do that? Well, maybe if you're creating a presentation in PowerPoint or in Word, you want to overlay some of your numbers there, that might be something useful.
I'm just going to delete that. Now you see the marching ants are around this original area. That means that these cells are still in the Clipboard so you can still paste. In fact, let's maybe go to Sheet 2 and we can paste and maybe go to Sheet 3 and we can paste. Now, let's go back to Sheet 1 and if you hit the Escape key, now it clears out the Clipboard and the marching ants are gone. Notice the Paste button is grayed out. If you press Ctrl+V, nothing happens because we've cleared out the Clipboard. So those are some really great handy features of using the Clipboard and hopefully that'll save you a little bit of time later on.
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.