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.
What we're going to take a look at in this particular movie is your Microsoft ribbon. This is the biggest change for anyone that's used Microsoft Excel in the past. In the previous versions of Microsoft Excel, you needed to know the menu options very well. You needed to know that paste was included in your Edit menu, in order to be able to bring information from one application into the other. What we've done in 2007, is group the information under tabs, and included in each tab are a group of commands that you see I'm circling over here, that are of like kind. And by that I mean, if I wanted to work with the information that's in my document and I wanted to bring it from my Word document into my Excel document, I would paste that information together.
I also have a cut. I could cut the information from one document, or one worksheet, to another, and I could copy it in. We'll see how these things work in detail in later movies. But you can see that they're grouped together so that the information is easier for me to find. If I want to align the information on my screen, I could simply go over to my Alignment group. So under each tab, You have groups of commands. In the groups of commands, you have very easy access to the groups. You don't have to remember what the name of the particular command is, it's identified either by a button, some text, or a icon.
You'll also notice that in each of the groups, you have a downward pointing arrow, and I'm hovering over that right here. What that does, if I click on this is a last way to see more options that are available in that particular grouping of commands. And these are much more similar format for those of you that are used to using Excel. It gives you the details behind that. So you could click on the formatting of cells, you can take a look at the number formatting that you might want to use, how these are aligned, what font styles you want to work with, and some other filling options and styling options.
You'll see that these are very similar to the tabs that are showing up here. So whatever way works best for you, is the way that you can access the information in the new version of 2007.
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.