Learning Center
Show summarized data with pivot tables
Add a pivot table based on your data through automatic suggestions in Sheets. Pivot tables help you summarize data, find patterns, and reorganize information.
1
2
Graph your data in a single click
Find patterns in your data instantly with the Explore feature in Sheets. If you’re only interested in a subset of data, select just the columns or cells you need. Your graphs update in real time. You can add these graphs to your presentations, too.
3
Make data-driven decisions with site metrics
Want to get insights from customers so you can make better business and marketing decisions? Use Google Analytics to see how visitors find and use your site—and keep them coming back. Then, use Google Script to import your data into Sheets.
4
Work on shared data independently
Working with collaborators on the same spreadsheet? Filter data without changing how others see the spreadsheet. You can save and name multiple filter views for quick access and sorting later. You can also share the views so people immediately see the most relevant information.
5
Track data updates
When several people are working on the same dataset, it’s easy to miss important changes. Track updates using formatting rules in Sheets. For instance, if your sales team is tracking their revenue in a spreadsheet, set up rules to change the cell color when they reach their target.
6
Search large datasets
When you have large amounts of data in your spreadsheet, it can be tricky to find what you’re looking for. Filter, sort, add, and verify values in your data with the QUERY function in Sheets.
7
Revert to an earlier version of your data
Keep all your Sheets drafts in one place, and revert to previous versions anytime. If you’re collaborating with others on a spreadsheet, you can see who made which changes to the data.
8
Import data from another spreadsheet
If your data lives in multiple spreadsheets, you can consolidate everything into a single spreadsheet using the IMPORTRANGE function in Sheets.
9
Get quick calculations with formulas
Want to find the average, maximum, or minimum values in a dataset? Use a function in Sheets to instantly calculate these values. For financial analysis, keep track of specific stock prices and see their changes. Or, predict future stock trends using the GOOGLEFINANCE function.
10
Keep headings in place when scrolling
Working on a detailed project plan with your team, or entering a large amount of data for your accounts? Keep your column headings fixed in Sheets, so you always know what data you’re viewing.
Want more ways to use G Suite to analyze data?
Visit the Transformation Gallery