MICROSOFT EXCEL

Pivot table is one of the most used feature in Microsoft excel. It helps you to summarize the data in your table in many different ways, thus it will save a lot of time while you analyze your data. 

It is important you have a basic table ready before you can apply a pivot table.

After inserting a Pivot table you need to understand how to work with the pivot table fields and the four areas( Filter area , Column  area , Row area , Value area)


In the video below you can understand how to insert a Pivot table,





In the video below you can understand how to work with the Pivot table fields and four areas,