INFO: What is a Pivot Table

A pivot table is a function within spreadsheets. In Microsoft Excel, a PivotTable report has an interactive table that extracts, organizes, and summarizes your data. From this report, you can analyze the data, compare the data, detect patterns and relationships, and discover trends.

An example is taking a spreadsheet with a listing of all the sales within a company. As raw data, this would be difficult to analyze, but if you create a Pivot Table. you can view the data more effectively. Using formulas applied to the PivotTable, you could organize the table to show the sales by state, products sold, or dollar sold (or other data fields in the spreadsheet). Your PivotTable would show you by state which product was selling the best and how much in terms of sales dollars. This is a very powerful tool included with Excel that can increase productivity and reduce time.

Pivot Table example