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.
In every workbook, you have a number of worksheets that you can work with and collect your data on. Let's take a look at what we can do and how we can manage this information are in the sheets. If you'd like to work along, re-open EatCake Inventory 11A. The information that's included on sheet number 1, is really the inventory for store A. I'm going to identify that by re-naming the worksheet name at the bottom of the page.
So I select the tab and make sure I've got Sheet 1 highlighted, I right-click on it, and then I select the Rename command. It then highlights the Sheet 1 information, and I just retype what I want to put in there. So I'm going to call this Store A. I can do the same thing for Sheet number 2, by clicking on the tab, clicking Rename, and calling this Store B, and so on.
You'll notice there's other commands that you can work with. You can insert a brand-new sheet by clicking Insert. It asks you what kind of information, or what kind of spreadsheet do you want to insert, I'm goings to select a Worksheet and I'm going to click OK. And I now have a new Sheet 1 in place. An easier way to do this is by using the little smart icon at the bottom here, which is the default insert worksheet, and by clicking on that, it automatically brings me a new worksheet.
That's what I would use, personally. If I click on my tab again and bring up my commands, I can delete a tab that I'm working with by selecting the Delete option. If you try to delete something that has data in it, let's go over to Store A, right-click and select Delete. You'll get a message which tells you that you do have data in here, and once you remove it, it's permanently gone. So be careful. I'm going to cancel this.
If we go back to our commands at the bottom by selecting the tab, you can Move or Copy a worksheet. And this in very handy. Let's click on Move, I'm just going to bring the screen up a little bit for viewers so that we can see it a little bit easier, and I identify what sheet I want to move. And your always selecting the sheet you want to do something with, so you're in Store A, Store A, you're on that sheet, and you want to place that before one of the other sheets that you see here. So if I want to place that sheet in between 1 and 3, I select sheet number 3, and I click OK.
And if you look down at the bottom of your screen here, you'll notice that Store A tab is now between sheet number 1 and one sheet number 3. So it's very, very easy to move your sheets around. Let's see that again. You right-click on the tab, you go up to Move or Copy, you identify where the tab that you selected should go, this time I'm going to move it to the end, click OK, and it moves the tab that you were sitting on to the place that you've indicated.
if you want to make a copy of this information, because it's your starting point for Store B, you can right-click, you can select Move or Copy again, this time say, Create a copy, by clicking on the checkbox beside that choice and clicking OK. Now you'll notice that Store A is shown twice. Store A at the end of the list, and Store A2 at the beginning of the list.
It's very easy to use the Rename option to go in and now call this Store C. And I have a starting point for the information and the inventory for the store. When working with your tabs, you may also want to hide some information every now and then. And you can do that with your tabs as well. If you right-click on your tab, you can select the Hide option, which removes now my Store C tab from view.
By clicking on my Store B tab and saying Unhide, it asks me which hidden sheet would I like to show, I select Store C, and it's brought back. For those of you that like a little color in your life, one last thing I'd like to show you is the ability to change the tab color. This is good if you are used to using paper based file folders and you've often tried to color code them to indicate different uses. And I'm just going through each of my tabs, clicking on the tab itself, going up to Tab Color, and just playing around with some really neat and interesting tabs. And that's how easy it is to add some more color to your spreadsheets. Working in Excel doesn't allow you to be very creative, so you have to get where you can.
Next we're going to be going to take a look at inserting images in our spreadsheets, so we'll get even more creative.
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.