PivotTable is an interactive, cross-tabulated Microsoft Office Excel feature that produces reports to analyze data (e.g., database records) from various sources, including the ones that are outside of Microsoft Office applications. Using PivotTable, you can automatically update a data source by changing the cell reference. This makes it possible for you to update data automatically without having to change the format of the report or database. Writer Bio
