By default, Excel Pivot table shows sum of numbers if you drag a number column to the value field. But sometimes the values and fields pivot table created by default is not really required.
It allows you to quickly summarize a large chunk of organized data.
Pivot table is one of the most powerful tools of Excel.
