What are Pivot Tables?

Pivot tables are created to summarize the data that is represented in a range of cells. The pivot table is a function that is accessible from the toolbar in Excel. You merely highlight the area that contains the data you would like to summarize and then determine which columns you would like to total or get a count on. As data is updated you can refresh your pivot table area to update the totals.