My Excel® 2013

9. Working with Pivot Tables

In this chapter, you discover one of Excel’s best analytical tools—the Pivot Table. A pivot table is an analysis tool that enables you to create an interactive view of your data, called a pivot table report. The topics covered in this chapter include the following:

→ Creating a pivot table

→ Rearranging and adding a pivot table data

→ Adding a report filter

→ Refreshing pivot table data

→ Customizing field names

→ Applying numeric formats and summary calculations

→ Showing and hiding data items

→ Sorting your pivot table

With a pivot table report, you can quickly and easily categorize your data into groups, summarize ...