Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
So you've learned how to open up older versions of Excel documents within Excel 2007, let's take a look at creating a brand new Excel document itself. Excel documents are called workbooks, and in a workbook, you have a series of sheets of information. We're going to take a look at now, how to add different sheets within the application. I'm now looking at three sheets of data. That's the default that I've set in my Options tab above. If I wanted to change the name of one of these sheets, I simply go down to the bottom, right-click on the name of the sheet as it stands here, and select the Rename option.
So I click Rename, and I can call this Qtr 1. So that's going to house my first quarter information. I can simply do the same thing by selecting sheet number 2, right-clicking on the sheet name, clicking Rename again, and call that Qtr 2. For those of you that prefer to use the ribbon commands to rename your sheet, you simply need to go up to the Format option, click the downward arrow, under the Organizing Sheets area, select Rename Sheet, she you'll notice if I come back down to the bottom of the screen, it's highlighted the name of the sheet forming, so I can simply click on Qtr 3, and add it in that way. So, it's very, very flexible depending on what best suits you in terms of using a mouse to navigate or to use your clicks of the buttons to navigate around system.
In every year, I have four quarters, but I've run out of tabs. How do I add a brand new tab into the system? Well, there's a couple of ways that you can do it. The easiest way is to click on the icon that I am hovering over right now, click on it once, and you'll see that I have created a brand you tab. To rename the tab, I go up to Format, I select Rename Sheet, sheets, and I can easily rename my sheet on tab number four. For those of you that prefer to use the mouse, you can simply click on the tab, use your right-click Mouse button, select Insert.
It's going to ask you what would you like to insert, you'll be asked what kind of information would you like to insert, and you're going to select Worksheet, and click OK. And you'll see that you've added in a brand new worksheet here, and you can rename it. For those of you that prefer to use keystrokes, if you hover over the final icon here, you'll see what the keystroke is to insert a worksheet, and it's Shift, holding down the shift key, hitting your F11 function key, and you add in one more worksheet.
So it's very, very easy, whatever way you'd like to add your worksheets in, you can. Now, you see here that I have more worksheets then I need, how can I delete them? You can right-click on it, select Delete, and you remove one of your worksheets. For those of you that prefer to use the ribbon to remove your worksheets, you select the worksheet that you would like to remove by placing your mouse within that worksheet, go up to Delete, and select Delete Sheet. And your worksheets are gone. That's how you can work with your worksheets. So now that you've learned how to add and delete worksheets, let's find out how you can do that same functionality, with cells and rows.
Find answers to the most frequently asked questions about Excel 2007 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.