Excel 2013 Pivot Tables

- Create pivot tables from worksheet databases.

- Rearrange pivot tables by dragging, swapping, and nesting fields.

- Customize pivot tables with styles, layouts, totals, and subtotals.

- Combine numbers, dates, times, or text values into custom groups.

- Calculate common statistics or create custom formulas.

- Filter data that you don't want to see.

- Create and customize pivot charts.

- Unlink a pivot table from its source data.

- Control references to pivot table cells.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.

Contents

1. Pivot Table Basics

2. Nesting Fields

3. Grouping Items

4. Calculations and Custom Formulas

5. Filtering Data

6. Charting Pivot Tables

7. Tricks with Pivot Tables