Excel 2000 : A Sample Application    Pivot Tables  

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.

 
screenbooks home site

28 of 35
  Text Author: Joe Orr   Copyright 2000 All Rights Reserved  
  Created with ScreenBook Maker   Last update: 12/20/2002   Additional Trademark and Copyright Information