1 |
Show summarized data with pivot tablesAdd a pivot table based on your data through automatic suggestions in Sheets. Pivot tables help you summarize data, find patterns, and reorganize information. Learn how |
2 |
Graph your data in a single clickFind 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 in Slides, too. Learn how |
3 |
Make data-driven decisions with site metricsWant 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. Learn how |
4 |
Work on shared data independentlyWorking 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. Learn how |
5 |
Track data updatesWhen 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. Learn how |
6 |
Search large datasetsWhen 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. Learn how |
7 |
Revert to an earlier version of your dataKeep all your Sheets drafts in one place in Drive, 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. Learn how |
8 |
Import data from another spreadsheetIf your data lives in multiple spreadsheets, you can consolidate everything into a single spreadsheet using the IMPORTRANGE function in Sheets. Learn how |
9 |
Get quick calculations with formulasWant 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. Learn how |
10 |
Keep headings in place when scrollingWorking 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. Learn how |