Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
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.
Your file was successfully uploaded.