Excel PivotTable Quick Tips

Introduction

• Analyze your data quickly with PivotTables

1. PivotTable Basics

• Get data ready for a PivotTable
• Create a basic PivotTable
• Use a recommended PivotTable

2. Adjusting PivotTable Data

• Rearrange a PivotTable
• Calculate values in a PivotTable
• Summarize values in a PivotTable
• Expand and collapse details in a PivotTable
• Format data in a PivotTable
• Group data in a PivotTable

3. Filtering and Sorting Data

• Filter data in a PivotTable
• Sort data in a PivotTable

4. Conditional Formatting with PivotTables

• Apply conditional formatting to a PivotTable
• Remove conditional formatting from a PivotTable

5. PivotCharts and Slicers

• Create a basic PivotChart
• Insert slicers into a PivotTable

6. Addressing Common Error Messages

• PivotTable error messages: Field name not valid
• Refresh a PivotTable
• PivotTable error messages: Overlapping reports