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.
   Learn why ”Create a filter” is unavailable
   The option to “Create a filter” can be unavailable due to:

   • Formatting
     • Check for any merged cells or hidden rows or columns in the sheet. Try to unmerge the cells and unhide the rows or columns.
     • Check for any conditional formatting applied to the sheet.
       1. Go to Format.
       2. Select Conditional formatting.
          • Make sure there are no rules applied.
     • Data validation
       • Check for any data validation rules applied to the sheet.
         1. Go to Data.
         2. Select Data Validation.
            • Make sure there are no rules applied.
     • If none of the above solutions work, you might not have access. To get access:
       1. Create a copy of the sheet.
       2. Check if the filter option is enabled in the copy.
          • If it is, you can use the copy of the sheet instead.
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.
     Custom formula examples

     Find unique values within a data range

     • Select Custom formula is
     • Type =COUNTIF(data_range, data_range)=1

     Find text matching “Good” or “Great” within a data range

     • Select Custom formula is
     • Type =OR(REGEXMATCH(data_range, "Good"), REGEXMATCH(data_range, "Great"))
     • 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.
4. To remove the filter, select an option:
   • Click Data Remove filter.
   • Right click on any cell then click Remove filter.

Once filtered, at the bottom right users can find the number of rows being displayed out of the total rows in the table.

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 .

1. On your computer, open a spreadsheet in Google Sheets.
2. Select the cells you want to include in your chart.
3. Click Insert Chart.

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.