Laying out your PivotTable


show more Laying out your PivotTable provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Laying out your PivotTable

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 d...

Laying out your PivotTable
Video duration: 2m 30s 5h 13m Beginner

Viewers:

Laying out your PivotTable provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...