Tips to analyze data

1. On your computer, open a spreadsheet in Google Sheets.
2. Click Data Create filter view.
3. Sort and filter the data.
4. To save your filter view, at the top right, click Save View.
5. Click Save.

1. On your computer, open a spreadsheet in Google Sheets.
2. To create a filter, select an option:
   • Select a range of cells, then click Data Create a filter.
   • Right click on a cell or a range of cells, then click Create a filter. 
3. To find the filter options, go to the top of the range and click Filter  . 

• Filter by condition:Choose conditions or write your own custom formulas.
  • You can filter cells that have valid or invalid data validation rules.
• Filter by values: To hide data points, uncheck the box next to the data point and click OK.
  • To create a filter and filter by cell value, right click on a cell then click Filter by cell value.
• Search: Search for data points by typing in the search box.
• Filter by color: Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.

• Click Data Remove filter.
• Right click on any cell then click Remove filter.

Convert data to tables

Convert existing data to a table

1. On your computer, open a Sheet.
2. Select a range of cells, either empty or with data.
3. On the Menu Bar, click FormatConvert to table.
4. Select the appropriate column type for each column.

Use tables views

With views, you can find the data you care about without impacting what others see on the sheet. You can use views to show or hide specific rows and apply other configurations to manage how to visualize data.

Each view can have its own unique configurations to filter and sort.

• To create new views, click Table menu , and then select one of the following:
  • Create group by view
    • This allows you to see rows grouped together based on the field of your choice.
  • Create filter view

Note: Temporary views disappear after spreadsheet refreshes.

• To apply existing views, click Table menu    existing view name.

Summarize data with pivot tables

1. On your computer, open a spreadsheet in Google Sheets.
2. Select the cells with source data you want to use. Important: Each column needs a header.
3. In the menu at the top, click Insert Pivot table. Click the pivot table sheet, if it’s not already open.
4. In the side panel, next to "Rows" or "Columns," click Add, then choose a value.
   • Sometimes, you'll see recommended pivot tables based on the data you choose. To add a pivot table, under "Suggested," choose a pivot table.
   • High confidence pivot table suggestions will be automatically inserted upon pivot table creation.
   • To turn off pivot table suggestions:
     1. At the top, click Tools Suggestion controls.
     2. Turn off Enable Pivot table suggestions.
5. In the side panel, next to "Values," click Add, then choose the value you want to see over your rows or columns.
6. You can change how your data is listed, sorted, summarized, or filtered. Next to what you want to change, click the Down Arrow  . 

Generate data analysis & insights with Gemini

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. In the side panel, create your own prompt with references from your sheet or generic cell names. Examples of prompts:
   • "Identify trends in this table."
   • "How can I show regression and prediction of this data?"
   • "What analysis can you help me perform with this sheet?"
   • "Help me understand month-to-month food prices."

Visualize data with charts

Create a chart

Insert a chart in your presentation

1. On your computer, open a document or presentation in Google Docs or Google Slides.
2. Click Insert Chart From Sheets.
3. Click the spreadsheet with the chart you want to add, then click Select.
4. Click the chart you want to add.
   • If you don't want the chart linked to the spreadsheet, uncheck "Link to spreadsheet."
5. Click Import.

Navigate data with links

Link to a range of cells

1. Open a Google Sheet.
2. Click the cell you want to link.
3. Click Insert Link  Select a range of cells to link .
4. Select the range of cells you want to link to.
5. Click Ok  Apply.

Search large datasets with QUERY

1. In Sheets, open a spreadsheet.
2. In an empty cell, type =QUERY.
3. In parenthesis, add the following specifications separated by a comma:
   • Cell range, separated by a colon, to perform the query on.
   • Specific query to perform (using Google Visualization API Query Language).
   • (Optional) Type a digit for the number of header rows at the top of the data.
4. Press Enter.

Make 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.

Freeze headings when scrolling