Collecting information is often much easier than analyzing or understanding it, especially for large information in large spreadsheets. One common challenge is that it’s hard to drill down into the data you want to find quickly.

Today it is easier to analyze and view your data with the addition of filtering in Google spreadsheets. Adding a filter onto a set of data can help you quickly narrow down the data set to find the data you need. By selecting a data set, you can filter and sort amongst many rows at once.