Author: Brady Gavin / Source: How-To Geek
Pivot tables let you analyze large amounts of data and narrow down large data sets to see the relationships between data points. Google Sheets uses pivot tables to summarize your data, making it easier to understand all the information contained in your spreadsheet.
What Are Pivot Tables?
Pivot tables are handy for analyzing massive amounts of data. Where a regular spreadsheet uses only two axes—columns and rows—pivot tables help us make sense of the information in your spreadsheet by summarizing any selected columns and rows of data. For example, a pivot table could be used to analyze sales brought in by divisions of a company for a specific month, where all the information is randomly entered into a dataset.
Creating a pivot table from the information in the picture above displays a neatly formatted table with information from selected columns, sorted by division.
How to Create a Pivot Table
Fire up Chrome and open a spreadsheet in Google Sheets.
Next, select any of the cells you want to use in your pivot table. If you’re going to use everything in your dataset, you can click anywhere on the spreadsheet, you don’t have to select every cell first.
Note: Each column selected must have a header associated with it to create a pivot table with those data points.
On the menu bar at the top of the page, click “Data,” then click “Pivot Table.”
If the new table doesn’t open automatically, click “Pivot Table,” located at the bottom of your spreadsheet.
How to Edit a Pivot Table
From the pivot table sheet, the side panel lets you add rows, columns, values, and filters for viewing your data. Sometimes, Sheets offers up suggestions based on the information you chose. Click a suggestion…
The post What are Pivot Tables in Google Sheets, and How Do I Use Them appeared first on FeedBox.