What is the use of Pivot in Excel?

Large amount of data can be analysed and summarized effectively

A 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 doesn't actually change the spreadsheet or database itself. In database lingo, to pivot is to turn the data (see slice and dice) to view it from different perspectives.

A pivot table is especially useful with large amounts of data. For example, a store owner might list monthly sales totals for a large number of merchandise items in an Excel spreadsheet. If the owner wanted to know which items sold better in a particular financial quarter, it would be very time-consuming for her to look through pages and pages of figures to find the information. A pivot table would allow the owner to quickly reorganize the data and create a summary for each item for the quarter in question.

A pivot table is a table which is used to store the summary of a certain data set in a condensed manner. It consists of rows, columns, data fields, and pages. it helps the user to expand, isolate, sum, and group the particular data in real time. It is easy to use. we can easily summarize data by dragging the columns to different sections of the table. The columns can also be re-arranged as we wish with the click of a mouse.

Among other functions, a pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations.

Pivot Table is the most powerful tools to group and analysis the data in any such way you ever wanna it. in easy way it can make anything possible.

Regards, 

Being able to analyze all the data in your worksheet can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data.