Before inserting a pivot table, make sure the data you want to analyze is in an organized table and that your data includes a header row, no empty rows or columns, and no subtotals. Pivot tables make it easy to rearrange data, quickly displaying it in different ways. A pivot table is an interactive table that can be used to analyze, organize, and summarize large amounts of data.
The following steps show how to insert a pivot table. How to Insert a Pivot Table in Microsoft Excel See Microsoft Excel: Tips and Tricks for similar articles.