Top 10 ways to use G Suite to analyze data

gray bar

1

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.

Learn how

Sheets

gray bar

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 in Slides, too.

Learn how

gray bar

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.

Learn how

Sheets

gray bar

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.

Learn how

Sheets

gray bar

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.

Learn how

Sheets

gray bar

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.

Learn how

Sheets

gray bar

7

Revert to an earlier version of your data

Keep 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

Drive

gray bar

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.

Learn how

Sheets

gray bar

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.

Learn how

Sheets

gray bar

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.

Learn how

Sheets

gray bar

Was this article helpful?
How can we improve it?