Google Sheets: Pivot Tables

Learn how to summarize and rearrange your Google Sheets data dynamically with pivot tables.

Introduction

• Welcome
• What you should know

1. Creating and Manipulating Pivot Tables

• Arrange your data for use in a pivot table
• Create a pivot table
• Pivot a pivot table
• Edit a pivot table’s data source
• Change a value field’s summary operation
• Create a calculated field
• Show and hide totals

2. Manipulating Pivot Tables

• Sort values in a pivot table
• Filter a pivot table by rule
• Filter a pivot table by selection
• Filter a pivot table using a search filter
• Filter a pivot table using a filter field
• Filter a pivot table using show and hide detail controls

Conclusion

• Further information