A friend reached out asking how to help her son with a homework assignment involving spreadsheets. The easiest answer was to just show her. That's how this video came together.
Filtering is one of those things that looks simple on the surface, and it is: but it's also something you'll use constantly once you get the hang of it. I use it regularly at work, especially when importing and exporting large sets of data. The biggest reason to use it correctly is data integrity. If you sort or move rows without filtering first, you can easily break the organization of your data and not realize it until something doesn't add up.
The video below walks through the basics: how to turn filtering on and how to use it in both Google Sheets and Excel.
Filtering is one small piece of a larger set of process improvements that add up quickly. Here are more examples of small changes that made a real difference.
For an example of how a single well-built tool can replace multiple manual processes, read about the one flyer that solved four problems.