How to analyze data using Excel PivotTables

Learn how to use one of the most powerful tools Microsoft Excel has to offer.

By Helen Bradley, PC World |  Software, Microsoft Excel

By default, Excel sums the value fields in a PivotTable, but you can change this setting so that it makes other calculations, such as the maximum, minimum, and average. For instance, if you want to see the average of the values in the PivotTable, right-click an item in the data area, choose Summarize Values By, and click Average. The heading in the top left of the table will change to indicate that you are viewing the average values, and Excel will recalculate the PivotTable values to show averages. To undo the change and see the data totaled, right-click a value, choose Summarize Values By, and click Sum.

In this discussion I've merely scratched the surface of what you can achieve with PivotTables and PivotCharts in Excel. With knowledge of these basic tools, however, you can easily create a PivotTable to summarize and analyze your own data.

If you liked this article, you might also be interested in these stories:

How to Create Advanced Microsoft Excel Spreadsheets

Work Faster in Microsoft Excel: 10 Secret Tricks

Make Data Entry Easier in Microsoft Excel: 10 Tricks

10 Secrets for Creating Awesome Excel Tables


Originally published on PC World |  Click here to read the original story.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

ITworld Answers helps you solve problems and share expertise. Ask a question or take a crack at answering the new questions below.

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Ask a Question