From the course: Google Sheets Essential Training
Join today to access over 24,400 courses taught by industry experts.
Using pivot tables - Sheets Tutorial
From the course: Google Sheets Essential Training
Using pivot tables
- [Instructor] A pivot table is a dynamic tool you can use to summarize or find patterns in the data in your sheet without ever having to enter a formula. Let's take a look at how to create and use a pivot table in a Google Sheet. I'll show you how using my solar product sales spreadsheet. You'll notice I've organized my data into columns. It's best to organize your data into columns for pivot tables because the column headers will become the fields that you add into your pivot table report. Once you've opened the sheet with the source data for your pivot table, you don't even have to pick a range of cells To add to your pivot table. Google Sheets will suggest a range of cells for your pivot table. You can always edit the data range at any point. To add the pivot table, click the insert menu and select pivot table. First, select your data range. Click on the select data range icon and Google Sheets will suggest a range for your pivot table. I'll click on that suggestion, which…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
