What Is the Purpose of a PivotTable in Excel?

by Angelique Sanders

PivotTables are reports extrapolated from an existing Excel spreadsheet, designed to improve the organization of complicated data. They do not interfere with the original spreadsheet, but are extensions of that information.

Querying Ease

Querying extensive amounts of data becomes more user-friendly; it's easy to do and undo.

Improved Presentation of Data

A PivotTable summarizes data by categories as well as subcategories.

Automated Data Rearrangement

A PivotTable can be used to geographically switch the placement of rows and columns. This can be used to automatically reorganize data to create an Excel chart.

Ease of Isolating Specific Data

A PivotTable can isolate specified data. This may be desired for reports in which only certain data is relevant.

Ease of Data Dissemination

It also creates an easier way of looking for trends or patterns in fields of data, especially over several categories.

Customized for the User

A PivotChart is interactive, not standardized. You select and arrange field placement, which allows you to visually determine how to best convey the relevant information.

About the Author

Angelique Sanders has been a freelance writer since 1989, with hundreds of published pieces to her name. Her writing credits include a stint as a restaurant reviewer for "TravelHost" magazine, a weekly political column for a Portland newspaper, and a bevy of food and cooking-related articles as well as other topics. She lives in the beautiful Pacific Northwest.