Introducing PivotTables
- Glossary
- Creating & Pivoting PivotTables
- Arrange Data for Use in a PivotTable
- Create a PivotTable from an Excel Table, Data List or from External Data
- Create a Recommended PivotTable
- Refresh PivotTable Data, Update Cell References that Provide Data to a PivotTable
- Pivot a PivotTable, Defer PivotTable Updates
- Managing PivotTables
- Show or Hide the Field List, Expand & Contract Buttons, Field Headers
- Select an Entire PivotTable, Move it, Copy a Configuration, Delete a PivotTable
- Summarizing PivotTable Data
- Show or Hide Subtotals, Grand Totals
- Change the Data Field Summary Operation
- Change How PivotTable Data Values Are Displayed
- Summarize More than One Data Field
- Create, Edit, Delete a Calculated Field
- Use PivotTable Data in a Formula
- Display Data Source Rows
- Create an Excel table from a PivotTable
- Sorting & Filtering PivotTable Data
- Sort a Column of PivotTable Data into Ascending or Descending Order
- Custom Lists
- Filter a PivotTable Field by Selection, Rule, Using a Search Filter
- Slicers
- Filter a PivotTable Using Report Filter Fields
- Create Individual PivotTables Using Report Filter Values
- Clear a PivotTable Filter Using the Field List Pane
- Clear a Filter Using the Row or Column Labels, Clear All Filters
- Defining Sets of Values
- Define a Set Based on Row Items, on Column Items
- Display a Set in the Rows or Columns Area
- Edit a Set, Delete a Set
- Formatting PivotTables
- Apply a PivotTable Style
- Apply a PivotTable Style & Remove Existing Formatting
- Apply or Remove Headers & Banding
- Create a PivotTable Style
- Apply a Custom PivotTable Style
- Change the Data Field Number Format
- Change the PivotTable Layout
- Control Whether PivotTable Lables Are Repeated at the Top of Each Printed Page
- Determine How to Handle Blank Rows
- Creating & Manipulating PivotCharts
- Create a New PivotChart/from an Existing PivotTable
- Pivot a PivotChart
- Filter a PivotChart by Selection/by Rule
- Apply a Style to a PivotChart
- Change a PivotChart's Layout/Chart Type
- Add a Trendline to a PivotChart
- Move a PivotChart to Another Worksheet/to a Chart Sheet
- Apply a Quick Layout to a PivotChart
- Add or Remove a PivotChart Element
- Apply a PivotChart Style, Change the Color Scheme
- Format a PivotChart Data Series, Format One Value in a PivotChart Data Series
- Add an Annotation to a PivotChart, Format a PivotChart Annotation
- Printing PivotTables
- Print a PivotTable, Print Headers at the Top of Each Printed Page
- Print Each Item on Its Own Page, Print a PivotChart
- Enabling & Adding Tables to the Data Model
- Create a Relationship between Two Tables
- Create a PivotTable Using the Data Model
- Work with a PivotTable Created Using the Data Model
- Edit a Table Relationship, Deactivate, Activate, Delete a Relationship
- Filtering PivotTables Using Timelines
- Create a Timeline
- Filter a PivotTable Using a Timeline
- Format a Timeline
- Clear a Timeline Filter
- Remove a Timeline