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.