Dan,
I think the best way is to go into Excel Help and do a search on PivotTables. I just did and got a wealth of info from "About PivotTable reports: interactive data analysis" to "Create a PivotTable report", as well as "Arrange the data".
Hope this helps.