Creating a Pivot Table in Excel 2010

By Mike Chapple, About.com Guide

Pivot tables provide a powerful data analysis tool embedded within your current spreadsheet software. They offer the ability to summarize data without the use of a relational database or aggregate functions. Instead, they provide a graphical interface that allows users to create customized reports within a spreadsheet by simply dragging and dropping data elements to the desired columns or rows. For more details on uses of pivot tables, read Introduction to Pivot Tables. In this tutorial, we examine the process of creating a pivot table in Microsoft Office Excel 2010.

Previous

• Introducing Pivot Tables in Excel 2010
• Open Excel and Your Source Document
• Create Your Pivot Table
• Select the Columns and Rows for Your Pivot Table
• Select the Target Value for the Pivot Table

Next