If you are following along, or if you have downloaded the sample (from the last page of this tutorial) you can try "slicing and dicing" the data yourself at this point. Any numeric measure can be dropped on to the data portion of the PivotTable, and any non numeric can be a row header or column header. You can subdivide a category by another. You see a chart of your data with a couple of mouse clicks.
We'll wrap up this fast introduction to some of Excel's powerful features with a quick look at two more PivotTable features: Calculated Fields, and Field Settings.
28 of 35
Text Author: Joe Orr
Copyright 2000 All Rights Reserved