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.
There's a new way of finding your information and your commands in 2007 for all of the office suite applications, and it's called the ribbon. And that's what we're going to explore right now. In previous versions of Excel, you were presented with a list of menus; your File, your Edit menus, your Window menus, and underneath there you went to look for your commands. What we've done in 2007, is we've grouped the information into a more logical format, and it's done through the different tabs that you seen here. There's 8 in all. And as you go through the different tabs, you'll notice that the information on the tabs changes to present you with the information or the commands that would be most appropriate for that kind of command that you want to work with. For example, if I went to my Page Layout tab, I see Themes, the setup of the page itself, some of the formatting options for the size of the rows or the columns that I'm working with, printable options, and how I'm going to arrange the information.
If I go to my Review tab, it allows me to select from different commands when I am going to be reviewing a document. In creating the ribbon idea for Excel 2007, Microsoft has grouped the information together in logical areas so that you will go to a particular tab to do a certain type of function, and find the commands you want there. If we take a look individually at the Home tab, this is where most of the formatting and styling options are available to you. You've got your Clipboard options, which allow you to paste, cut and copy, your information from one area to another. You have your Font commands, which allows you to style, bold and italicize information that's included in your spreadsheet.
You have your Alignment section, which gives you the ability to format and change the look and feel of the information, so that it's easy to read. You have your numbering options in formatting. With your accounting and percent and number of decimal places very easily highlighted, and easy to use with a click of a button. You have your styling options, the ability to manage your cells and other editing features. Right with the click of a button. That's a quick introduction to the ribbon. We'll explore how to manage this ribbon in another movie.
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.