I use pivot tables quite a lot, and love thei use to summarise data.

When I select the pivot table function there are 4 options to choose from, and I only use the first 'Microsoft Excel list or database'

I would loev to learn how to use the other options, and learn how to create a pivot table etc from 2 different worksheets/spreadsheets.

Does anyone know of a good site that has a good guide of how to use these functions in Excel 97?

I know that a lot of your could help me, but where do I start with it all, so I figured that if someone could recommend a good site/s then it might be easier on everyone !!!