In this video, you will create filters and use filter views to better understand thedata in your sheet. Filters temporarily hide data in a spreadsheetso you see only a selection of specific rows or values. Filters are useful when workingwith specific entries, such as if you only want to see sales by a specific person ora specific t-shirt design that was sold. To begin, duplicate the sheet of your formatteddata. You may want to reference the original version again later.
Rename the copied sheet.
Then, create a filter in your header rowso you can filter any column in your sheet. For example, you might want to filter for thesalesperson to see the number of sales they made and which items they sold.
Choose a column to filter. Then, clear the values. Select the value you want to see.
The rest of the values will stay hidden.
You can select multiple values in a filter, too.
Open the filter again to see all the values.
Next, sort your sheet alphabetically or by other conditions for text, numbers, or dates.
For example, you may be looking for an entry that contains a particular letter or a SaleI-D greater than a certain number.
Or, you may want to filter out transactionswhere only one shirt was ordered.
View all your data again by removing the filter conditions.
You can filter multiple columns at one time.
For example, design...
Or, turn off the filters for the entire sheet.
Turn them back on again at any time.
But for now, leave your filter off. Next, you’ll be using filter views, and you can only useone type of filter at a time. While a “filter” is visible to anyonewho uses the sheet, a filter “view” is only visible when it’s selected, so it’sentirely optional. Filter views are useful when many people areusing the same spreadsheet and need to filter for or see different information.
For example, a salesperson may want to see all the transactions attributed to them, whilea supply manager may want to see the most popular styles of shirts.
To create a filter view, highlight the header row again. Create a filter view...
...then name it. Set the condition of your filter view thesame way you did with your filter. When you’re finished with that particularfilter view, close it. Add at least two filter views to your sheet.
You may want to add a filter to see sales of a certain product, using a certain paymenttype, or from a certain range of dates.
Return to your named filter views at any time.
Now, it’s your turn: Duplicate your sheet and rename it,Add a filter, Sort by values in your sheet,Remove the filter, And add at least two filter views to your sheet.
1. Introduction to G Suite Certification: Sheets - Part 2
2. Sheets: Create Filters and Use Filter Views
3. Sheets: Use Filters to Count, Add, and Summarize Data in a Table — Use Sheets and COUNT
4. Sheets: Use the SUM Function to Analyze Data
5. Sheets: Display Data in a Chart — Create, Insert, and Modify Charts, and Protect Sheets and Ranges
6. Sheets: Use COUNTIF to Generate Numeric Data with Text Values
7. Sheets: Share and Collaborate — Add Comments, View Revision History, and Download Spreadsheets as File Types