Excel Pivot Table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table is especially useful with large amounts of data.
The tool can automatically sort, count, total or average the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data. A pivot table doesn't actually change the spreadsheet or database itself.
Other operations within Excel can perform some functions available with Pivot Tables, but none is as robust. Top advantages of using Pivot Tables are:
- Sort information by category more easily
- Compare information in seconds
- Time saver
- Interactive Data Analysis