Pivot Table Uses

Pivot tables are powerful tools commonly seen in Microsoft Excel. Pivot tables are ideal for allowing users to manage large amounts of information while focusing on a smaller set of information. Pivot tables allow a user to switch their perspective into a condensed table that contains critical data.

Create a Sub-Table of Data

Pivot tables can be used to grab specific data points and create a sub-table. This helps users focus in on a subset of the data without having to manage the entire data set. Users can select options for specifying the specific data that is shown.

Summarize Data

Pivot tables can be used to perform functions on the subset of data. For example, users can select a subset of data and also calculate the total of the data (such as the total sales for a particular region).

Format Data

Pivot tables can also be used to rearrange some or all of the original data. Users can manipulate the layout and the format of the data in the pivot table without changing the original data set. This can be helpful for presentation or reports of the data.