Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
In your Pivot Tables options tab, in the first grouping under Pivot Table, you have the ability to name your Pivot Table directly here. So I can change it from the default to EatCake Pivot Table. Under here, you can find other Pivot Table options, but we'll save that for a more advanced movie. Under your active field, it will default to add up the items in the body of your Pivot Table in here, but what you also could do is go to your Field Settings tab and change the type of calculations that's being done on those values. If you wanted to count the individual values that you see, want to average them, find the maximum or minimum in the area, you can also show that here.
Also, you could show the value in different formats. So you have lots of choice and options of what data is included here in your active fields. You can group your data, for better selection than sorting, you can sort it, so that it can be presented alphabetically, or in other sorting manners. You can also set up your data so that it's automatically updated from an external source. You can clear your pivot tables, and remove them, and change the formatting filters, as well as moving it from the place that is set in this particular worksheet.
You also have some Pivot Charting options and Formula functionalities. Also, you can change the field list presentations, so if you wanted to you can change the way the Field List is presented. In this case, I've hidden it all together, but if I click it again, I will have it presented to me. I can change the Show or Hide buttons to expand or collapse items within my Pivot Table, as well as display the Field Headers for more rows or columns. So I have different choices that I can work with here in this case. If you noticed, I clicked on the Field Headers button and I removed the formatting options and the filtering options that I had here.
If I wanted to add that back in I would just click, and that your field column labels and your row labels are re- shown. And I'm going to turn that off because I like the presentation of that better. In the next movie, we're going to take a look at the Design tab, and see what that offers us in terms of working with Pivot Tables.
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.