Creating

You create a pivot table report by selecting (Data > PivotTable and PivotChart Wizard).
Select any cell within the list from which you want to create your table.
You can use pivot tables to aggregate data from a wide range of sources including external databases.
There are four places you can use for the data for your pivot table
1) A list or database table in Excel. The excel data must be arranged in the correct way to get the maximum benefit.
2) An external source, database or another workbook
3) A consolidation of multiple ranges from different worksheets.
4) Another Pivot Table or Pivot Chart.
Pivot tables that are based on external data can use a great deal of memory and the size of the workbook can increase dramatically.