Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
When you add headings, formatting, and data to a worksheet, you'll often find that you can use those same elements again, whether on the same worksheet, another worksheet in another workbook, or even in another Office document. In this movie, I'll show you how to cut, copy, and paste your data effectively. To cut cell data, you first select a cell, or group of cells, and then either press Command+X, or click at the Cut toolbar button. So let's say that I wanted to cut the values calendar year 2005 through calendar year 2010 from these cells and paste them into other cells.
After you select them, you can press Command+X, which is for cut, or you can click the Cut button on the toolbar - it looks like a pair of scissors. Then you click the cell where you want paste the values and press Command+V. Because I used cut, Excel removed the values from the original cells and pasted them here. Now I am going to undo that. To undo I will press Command+Z key, put the cells back, and then press Escape to release the selection. Now I will select the values and press Command+C. That's the Copy command. Now when I click cell I4, I can press Command+V and paste the values in, but because I used copy instead of cut, the original values remain in place.
So that's how we copy all of the contents of one or more cells. But let's say that you want to copy just a part of it; for example, in cell A1, let's suppose that I just wanted to copy the word 'Revenue.' To do that, click the cell, as I did here, and you'll see the value here on the formula bar. Now, I can click in the formula bar and copy just that part that I want to copy and paste. So after it's highlighted, I can press Command+C to copy, press Escape to stop editing the cell, and then click cell I1, press Command+V to paste it, and there you have the value.
And once the value is there, you can change the formatting to match the formatting here in cell A1 if you want to. But now let's say that you want to copy the elements of an Excel worksheet to another Office document; for example, a Microsoft Word document. Well, let's do that. I have another Microsoft Word document open, so what I would do is I will copy the values from cells A1 through G17, press Command+C to copy it, and then I will open my Word document. In the Mac OS, you can press Command+Tab to move to another window.
So I will move to Microsoft Word, and here I have my blank document. All I need to do to paste the values from the worksheet into this document are press Command+V - and because Word and Excel are both Office programs, you can copy and paste between the two programs quite easily. The techniques I've shown you in this movie will help you avoid entering the same data and formatting more than once. After you enter the elements you want into your worksheet, you can cut or copy them and use them again in Excel or any other Office document.
Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.