{"id":12159,"date":"2012-09-02T12:48:41","date_gmt":"2012-09-02T12:48:41","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2363"},"modified":"2022-08-07T02:33:29","modified_gmt":"2022-08-07T02:33:29","slug":"what-is-pivot-table","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/09\/what-is-pivot-table\/","title":{"rendered":"What is Pivot Table ?"},"content":{"rendered":"
As you know Excel has so many excellent features in it. Pivot Table is one of them. If you use Microsoft Excel and not used Pivot Table, It means you have missed a really great feature of Excel.
\n<\/p>\n
Pivot table is the best tool available in Excel to Sort, Filter, Count, Sum and summarizing the data in a worksheet. A pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table, which is called as Pivot Table<\/strong>. Pivot table is also useful in preparing graph based on some calculated value from a data table.<\/p>\n \nThis is very useful and easy to use. Despite of being so easy and useful, many people are scared of using Pivot Table. For them I must say, Do not scared of Pivot Table, start using them, soon you will become fan of Pivot table. So start using Pivot Table on every possible opportunities :).
\n
\nAs per Wikipedia “In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software”<\/em>
\n <\/p>\n