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 been introduced to the ribbon, let's take a look in little more detail of what you've got on an ribbon. On your Home tab, you have all of the most commonly used commands that people who are working in Excel want to access very quickly, so that your formatting, your alignment, your numbering formats, the ability to work with cells, and edit the data. If we take a look at the Insert tab, that's going to allow you to put in your pivot tables, other tabular formats, some nice graphic illustrations if you want to jazz up your worksheet a little bit, access to your different charting options, as well as linking and putting in different text and headers. I'm going to go to this fairly quickly in this movie, because we're going be exploring each of these tabs in subsequent movies.
Under your Page Layout, it allows you to take a look at and work with how your information is going to be finely printed on your page. Formula tab allows you easy access to commonly defined functions, within application, as well as the ability to create your own and to find it where you went wrong when you did it. Over on the Data table tab, you have the ability to take a look at and sort and filter your data very easily, and it really allows you a lot of different options to access the information, and to analyze the information that's included in your worksheet.
The second to last tab, the Review tab, allows you to do your proofing right in the Excel environment. There's the good, old spell check option that we've grown to love within all of the Microsoft Office applications. the ability to share the information allows you now, a new commenting feature, and it also allows you the ability to track your changes and to protect your worksheet so that the information, when you do share between people, isn't changed. And finely, under View, the final View tab replaces the old Windows menu.
It let's you work with other windows, and flip between the windows that you're looking at on the screen. And it allows you to change the view that you're looking at, either the page layout view, which shows me how it's going to be actually shown on the page when I want to work with it. That let's me easily and quickly go back to my normal view so I can manage my data. We'll be exploring all of these different tabs in much more detail in subsequent movies.
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.