What is a PivotTable?

A PivotTable is a powerful tool for exploring, summarizing, and analyzing information. A PivotTable helps you organize and manipulate the raw data in your spreadsheet to provide insight into patterns or relationships that might not be obvious at first glance. PivotTables also give you the power to summarize your data and view it in a different context, without changing the original content or structure of the data in the worksheet.