Filtering and Filter Views to optimize viewing of data in Google Sheets

Do you get overwhelmed looking at huge data sets in Google Sheets from Forms? 

There is an easy solution for you to manage viewing the data you want to see without deleting the original data.  

It is called a filter.  

Filtering does just what it sounds like - it shows you the data you want to see by inputting your parameters into the Filter tool options. You can filter by conditions such as "text contains," "cell is empty," or by values.  

You can also create Filter views if you have multiple filters that you want to save without re-typing the parameters.  Filter views are also good for large data sets for departments, grade levels, year long testing, etc. that various people want to view differently.  For example, I have a teacher that collected test data for all of her classes into a single spreadsheet. She wants to just view the data from her first class period without copying and pasting or deleting the original data.  The teacher can create filter views to view each of her class periods quickly. 

Watch the view to see how to set up filters and filters views in Google Sheets.