Google Sheets: Pivot Tables
53mIntermediate2018-04-02
Authors
Curt Frye
President of Technology and Society, Incorporated
Course details
Google Sheets users can leverage pivot tables to create useful summaries to gain insights into their business data. Follow along with Curt Frye as he shows how to summarize and rearrange data dynamically with pivot tables. Learn how to lay out your data, create the pivot table, edit the data source, add custom calculated fields, and sort and filter data to display exactly the information you need.
Learning objectives
Arranging data for use in a pivot table
Editing the data source
Creating a calculated field
Sorting values
Filtering a pivot table by rule, selection, or filter field
Learning objectives
Arranging data for use in a pivot table
Editing the data source
Creating a calculated field
Sorting values
Filtering a pivot table by rule, selection, or filter field
Skills covered
Google AppsGoogle SheetsGoogle WorkspaceGoogle DriveSpreadsheetsGoogleBusiness Software and ToolsDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Welcome
- 02 - What you should know
1. Creating and Manipulating Pivot Tables
- 03 - Arrange your data for use in a pivot table
- 04 - Create a pivot table
- 05 - Pivot a pivot table
- 06 - Edit a pivot table s data source
- 07 - Change a value field s summary operation
- 08 - Create a calculated field
- 09 - Show and hide totals
2. Manipulating Pivot Tables
- 10 - Sort values in a pivot table
- 11 - Filter a pivot table by rule
- 12 - Filter a pivot table by selection
- 13 - Filter a pivot table using a search filter
- 14 - Filter a pivot table using a filter field
- 15 - Filter a pivot table using show and hide detail controls
Conclusion
- 16 - Further information