What Is an Excel Pivot Table Used For?
An Excel PivotTable is used to view a set of data in different ways. For example, you can determine your business’s highest sales revenue or the lowest sales item for a specific quarter within the same PivotTable without moving around to different spreadsheets or workbooks. As the data source changes with additions, deletions or edits, the PivotTable will reflect these alterations when the Refresh button is pressed.