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.
Now that you've seen what the ribbon offers you, let's take a look at how 2007 Excel let's you customize these lists. For those of you that are old-time Excel users, you're probably wondering, how can I get easy access to those commands that I used to use a lot when I was in 2003, and I knew where they were. Well that's very easy to do. Right at the very top of the screen, you have your drop-down list, and I'm pointing at that drop-down list right now. I'd simply click on that to customize my Quick Access toolbar, and if you take a look to the left, you'll notice that I already have a few icons sitting on that toolbar.
How can I add more? Well, it's very simple. You'll notice that by the Save option here, or the Save command, I have a checkbox. What does that do for me? Well that adds that particular icon, that Save icon, to my Quick Access toolbar. I could say I'd like my spell check, because I'm an awful speller, and I want that easy at hand. By clicking on that, it closes that window and it puts the spell check icon right up on that Quick Access toolbar for me. So by simply clicking on the downward pointing arrow, I can set up my Quick Access toolbar very, very simply.
I could look at more commands, and by clicking on that I pop into the Excel Options tab, to the customized view. And this gives me access to all of the different commands that are in the Microsoft Office menu, as well as in Excel itself. By clicking on the particular tab I'm interested in, it presents me with a drop-down list of all the information that I'd like to be able to work with. I also like the AutoSum features, so I'm going to select that, click on the Add button to move it from the left-hand side of the screen to the right. I can re-order the order that my Quick Access toolbar presents in, by selecting a particular command that I want at the very beginning of my list, and clicking up.
So you see, it's very, very simple for you to have complete control over what you are looking at in the Quick Access toolbar. By clicking on the OK button, you'll notice up in the top here that I have now all my favorite commands, just at the click of a button. One last thing I want to show you that the Quick Access toolbar, is the ability to position it. Right now, it's at the very top above my ribbon. We have one other place that it can be placed, and it's down below the ribbon. So if I prefer to have the Quick Access toolbar closer to my formula bar, I can simply place it below my ribbon.
If I prefer, I can put it back above. So it's really personal preference. If you've placed all of your favorite icons on your Quick Access toolbar, and you really don't want to see the ribbon any longer, you can easily minimize it by again, clicking on the custom Quick Access toolbar, and clicking the minimized ribbon option. And there, it's gone. And for those of you who are true 2003 users, this is a little bit more in tune with what you're used to seeing. Let's bring back the ribbon at the moment because I really want to explore the information that's included on it, so I just simply click on my Quick Access toolbar option, and click on the minimize ribbon to deselect that option, and my ribbon's now in front of me.
Now, we're going to go on to the next movie that allows us to see how we can customize the information behind the Microsoft Office button.
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.