Creating a PivotTable or PivotChart from worksheet data. You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.
https://support.office.com/en-us/article/Overview-of-PivotTable-and-PivotChart-reports-527c8fa3-02c0-445a-a2db-7794676bce96
You can use a PivotTable report to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends.
https://support.office.com/en-us/article/Overview-of-PivotTable-and-PivotChart-reports-527c8fa3-02c0-445a-a2db-7794676bce96
You might think of a pivot table as a user-created summary table of your original spreadsheet. You create the table by defining which fields to view and how the information should be displayed. Based on your field selections, Excel organizes the data so you see a different view of your data.
https://www.timeatlas.com/excel-pivot-tables/
Pivot Tables. Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country. To insert a pivot table, execute the following steps.
http://www.excel-easy.com/data-analysis/pivot-tables.html
The above are all really good answers to your question. The Excel pivot table is a great tool for taking a large transactional data set and provides you with a mean to easily summarize that data in pretty much every way you can think of. I built a list of 10 ways Excel pivot tables can make you more productive on my blog (http://bradedgar.com/10-ways-piv... - source).
https://www.quora.com/Why-use-pivot-tables-in-Excel
Using an external data source to create a PivotTable or PivotChart. You can retrieve data from an external data source such as a database, an Online Analytical Processing (OLAP) cube, or a text file. For example, you might maintain a database of sales records you want to summarize and analyze.
https://support.office.com/en-us/article/Overview-of-PivotTable-and-PivotChart-reports-527c8fa3-02c0-445a-a2db-7794676bce96
Many people encounter the term “pivot table” when using Excel spreadsheets for example. Some are aware of the functions of the pivot table while others are not familiar of what it can actually do for a particular spreadsheet. Pivot tables actually serve a good purpose when used in Spreadsheets. They actually perform various functions in terms of summarizing various data indicated on the spreadsheet.
http://www.knowswhy.com/why-are-pivot-tables-used/
You can do the same thing with filters and subtotals in Excel, or just use multiple reports and go from page to page when the detail changes, but it just doesn't work as well. Refreshed with Recent Data. Pivot Tables can be setup to query a database, and by refreshing the data, the entire report updates.
https://www.quora.com/Why-use-pivot-tables-in-Excel
Excel pivot tables allow you to group the spreadsheet or external data source by any of your data fields. The screen snap below shows a count of voters by party by precinct. Using a pivot table, I can continue to slice the information by selecting more fields from the PivotTable Field List.
https://www.timeatlas.com/excel-pivot-tables/
Excel pivot tables are a feature that you should learn how to use. Instead of analyzing countless spreadsheet records, these tables can aggregate your information and show a new perspective in a few clicks. You can also move columns to rows or vice versa.
https://www.timeatlas.com/excel-pivot-tables/
why use pivot table
Use a Pivot Table report to summarize, analyze, explore, and present summary data. Use pivot table to summarize, analyze, explore, and present summary data.