A PivotTable is an Excel tool for summarizing a list into a simple format. PivotTables are created from lists as you define which fields should be arranged in columns, which fields should become rows, and what data you wish to summarize. You don't have to use all the data in a spreadsheet to create a pivot table—just the data and the fields you need to answer your questions. Once the table is created you can then read off the answer to your question. You can later reuse the PivotTable to answer different questions by rearranging it.
This spreadsheet of sample data helps you create PivotTables in Microsoft Excel. To learn how to create PivotTables, see How to Analyze Data Using PivotTables.
|Requirements||Microsoft Excel (Slicers are availabel in Excel 2010 only)|
|Operating System Compatibility||
|File Size||0.01 MB|