Join Curt Frye for an in-depth discussion in this video What you should know, part of Google Sheets: Pivot Tables.
- [Narrator] Thanks again for your interest in this course. Before I get started, I'd like to give you an overview of what you should know to get the most out of this course. First off, you should know how to manage workbooks and worksheets in Google Sheets. When you create a pivot table, it is created on a new worksheet, and so you should know how to move back and forth between your data worksheet and the pivot table worksheet so you can get the most out of the pivot table. Next, you should know how to create formulas.
Even though most pivot tables do the summaries for you, you can create calculated fields that give you custom summaries. And finally, you should know how to explore and learn more about your data. Pivot tables are extremely versable tools. The more you know about pivot tables, the more you can learn about your data. Thanks again, and let's get started.
- 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