Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

One of the most common tools people use in Excel to create reports ... update the data in the pivot table accordingly. Using this approach, you can perform any analysis you like on source data ...