Pivot tables allow you to create an organized summary of data within a spreadsheet. Pivot tables can calculate data by addition, average, counting and other calculations. A data set is summarized in a chart format which can be updated whenever the data set is updated. A pivot table can include multiple columns and rows from a spreadsheet. Reading a pivot table requires you to understand how data is calculated and the meaning of each heading. Warnings Writer Bio