– This description is meant for MS Excel 2010. If however you are using an older version of MS Excel then click the option Data and then select Pivot Table and Pivot Chart Report option.
– Apply formula where aggregation is required.
– Image Courtesy: brighthub.com