Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97627 Viewers
80 Video lessons · 141096 Viewers
59 Video lessons · 59437 Viewers
52 Video lessons · 72757 Viewers
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.