Understanding and Using Pivot Tables in Microsoft Excel 2007

Many advance users of Excel swear by Pivot Tables, many refer to it as Excel’s single most powerful tool, having myself taken a deeper look into Pivot Tables, it may be hard arguing with them.
Pivot Tables are indeed a powerful feature. The amazing thing for me is how much you are able to get out of so little effort and how quickly. They, those advance users, may have a point there.
I have attempted here to present Pivot Tables to you in a simple step by step manner so that you can both appreciate and understand the feature in great detail.
Despite its massive power, Pivot tables are not just for advance users, any Excel user should become familiar with its power.
The actual Excel file has been uploaded as the "Preview", that way you can actually follow the exact steps in the book.