Excel PivotTable Quick Tips

Introduction

• Analyze your data quickly with PivotTables

1. Excel PivotTable Basics

• Get data ready for an Excel PivotTable
• Create a basic Excel PivotTable
• Use a recommended PivotTable
• Create multiple PivotTables

2. Adjusting Excel 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 in a PivotTable

• 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. Data Grouping with Excel Functions

• Use GROUPBY to view data like a PivotTable
• Use PIVOTBY to view data with more columns

7. Addressing Common Error Messages in PivotTables

• PivotTable error messages: Field name not valid
• Refresh a PivotTable
• PivotTable error messages: Overlapping and make space