This Video Explains powerful Data Analyis Tool Pivot Table In this you will learn
Creation of Pivot table
group items/records/rows into categories
count the number of items in each category
sum the items value
-compute average, find minimal or maximal value etc.
Updation of Pivot Table