What is meant by 'Pivot Table' ? What are its uses ?

A Pivot Table is an interactive way to quickly summarize large amounts of data. These are especially designed for Querying large amounts of data in many user-friendly ways. Following are its advantages: 1. Expanding and collapsing levels of data to focus on results and providing from details to the summary of data for areas of interest. 2. Querying large amounts of data in user-friendly ways by summarizing data in subcategories and creating custom calculations and formulas. 3. Moving rows to columns or columns to rows to see different summaries of the source data. 4. Filtering, sorting, grouping and conditionally formatting the most useful and the interesting subset of data to enable us to focus on the information that we want. 5. Presenting concise, attractive and annotated online or printed reports. 6. The use of a Pivot Table report is to analyse related totals, when we have a long list of figures to sum and to compare several facts about each figure.