Pivot Tables

Pivot tables are by far the most powerful data manager in Excel. They allow the user to organize raw data into any desired format, making it easy to convert the data into information you can use. They are perfect for interactive reports and times when you want to sort and view data in various ways. To create a pivot table, simply highlight your contiguous data range, and select "Pivot table report" from the "Data" menu. Drag the gray header boxes into the section of the report you want. When you click OK, the pivot table is created. You can drag the gray header boxes into other positions without going back to the Pivot table wizard. You can also double click on any value and Excel will pull the raw data that supports the value and paste it into a new worksheet. If you have multiple row sources, you can double click to expand or hide detail.

Actually, I love Pivot Tables so much, I wrote an article on it, and it was published in the Journal of Accountancy.  For additional information on Pivot Tables, feel free to check out my article, Drilling for Information.

Pivot Tables