What is the main purpose of Pivot Table in Microsoft Excel?

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data, the way you wanted it to be.

Use a PivotTable report to summarize, analyze, explore, and present summary data. Use a PivotChart report to visualize that summary data in a PivotTable report, and to easily see comparisons, patterns, and trends. Both a PivotTable report and a PivotChart report enable you to make informed decisions about critical data in your enterprise.

A PivotTable report is an interactive way to quickly summarize large amounts of data. Use a PivotTable report to analyze numerical data in detail and to answer unanticipated questions about your data. A PivotTable report is especially designed for:

• Querying large amounts of data in many user-friendly ways.
• Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
• Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
• Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data. 
• Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want.
• Presenting concise, attractive, and annotated online or printed reports.

You often use a PivotTable report when you want to analyze related totals, especially when you have a long list of figures to sum and you want to compare several facts about each figure.

It's To Change Row Data To Something You Need To Know 

To have a summary of a huge details, very effective tool.

Represents a single data point by symbol in a chart.

They can be used to summarize, analyze, explore and present your data in a tabular form.

Pivot table in excel allows data summary.

It allows creation of reports

Provide means for listing of values into unique rows or columns.

It could serve as source of linkage with other windows out of excel.

It eases data transfer

It helps to summarize the data that you required for reporting.

mostly it will reduce your work  whie doing any report.

can customize in a easy way. and Etc..

Linking data and analyzing , and report them to easily extract

dipicting aggrigate result from data