Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video series you will learn how to work with the Filters in Excel. Filters hide and unhide rows to help us prepare our data for analysis and tie out numbers to formulas, pivot tables, and summary reports.

Click here to download the file used in the video: https://www.excelcampus.com/tables/filters-training-part-1/

In this first video I explain an overview of filters and how to apply them to your data. I share some advantages of using Excel Tables for filtering data. I also show navigation shortcuts to help find filtered columns.

Click the following link to watch my video on a Beginners Guide to Excel Tables to learn more about this awesome feature of Excel.

https://www.youtube.com/watch?v=fJnJTff4Na8

The second video is all about keyboard shortcuts for the filter drop-down menus. These shortcuts will save you tons of time when working with filters.

In the third video you will learn how to apply filters to multiple columns with both AND and OR logic. I also explain the rules that Excel uses when applying filters to multiple columns.

Throughout the video series I will also be sharing an Excel Add-in I developed called Filter Mate. Filter Mate is a productivity add-in that will help save you time when working with filters.

Filter Mate & the Filters 101 Course are now available. Click here to learn more. https://www.excelcampus.com/filter-mate/

Please leave a comment on the following page with your favorite filtering tip. https://www.excelcampus.com/tables/filters-training-part-1/

Video #2: https://www.youtube.com/watch?v=Z1_oq-uPUBU
Video #3: https://www.youtube.com/watch?v=rgATdkyLey8