What is a PivotTable and how do I make one out of my data in Excel 2007? A PivotTable is a lot like an Excel Filter form. Meaning you can apply a filter to a range of data, from which you can "pivot"or filter between specified criteria. Another way to put it is that a PivotTable is an interactive worksheet table you can quickly analyze and summarize greats amount of data. You can also specify which part of the Source data you'd like to pull in, or interact with. These include Fields or Items. Fields are categories and Items are subcategories. To get the secret on how to create a great PivotTable please support this website and purchase this training video on PivotTables!

Purchase the training video and you can see this in action for yourself!