Bottom line: In this FREE video series you will learn how to use the Filters in Excel. I share time saving tips, techniques, and shortcuts that will help make you a filtering ninja!
Skill level: Beginner
Video #1: Introduction to Excel Filters
In this first video I explain how to apply filters to your data. You will learn the advantages of using Excel Tables for filtering data. I also explain some navigation shortcuts that will help you find filtered columns.
Double-click video to view full screen HD.
Download the file I used in the video to follow along.
Excel Filters Training - Part 1.xlsx (101.4 KB)
We Spend A LOT of Time Filtering Data!
Filters are an extremely powerful feature of Excel that help us cleanse and analyze our data. They help us tie out numbers to summary reports and pivot tables, cleanup formulas, fix errors, and prepare our data for analysis.
It would be hard to live without filters… 🙂
We also spend a ton of time working with filters. Some of these filtering tasks can be very time consuming, and lead to frustration. Throughout this video series I am going to share tips, techniques, and shortcuts that will help save you time when working with filters.
In the video above I show the advantages of using Excel Tables for filtering data. Checkout my video on a Beginners Guide to Excel Tables to learn more about this awesome feature of Excel.
Filter Mate is Coming!
Filter Mate is an Excel Add-in that will save you a ton of time when working with filters in Excel. At the end of the video I shared a feature called Filter Hop. Filter Hop allows you to navigate to the filtered columns in a range or table with a click of a button.
This eliminates the time consuming horizontal scrolling that we often do to find columns with filters applied. The Filter Mate Add-in will be available in a few weeks. You can signup here to get notified when Filter Mate is available.
What's Your Favorite Filtering Tip?
I shared quite a few tips for working with filters in this first video. I'm curious to know if you have a favorite tip or shortcut that you use.
Please leave a comment below with your favorite tip. You can also leave a question with a tip or technique that you would like to learn.
I'll be back next week with video #2 of the series. Thank you!