Learn how to summarize and rearrange your Google Sheets data dynamically with pivot tables.
Overview
Syllabus
Introduction
- Welcome
- What you should know
- 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
- 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
- Further information
Taught by
Curt Frye
