Excel Filters Training - Keyboard Shortcuts - Part 2 of 3

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

This 2nd video in the series is all about Keyboard Shortcuts for the Filter Drop-down menus. These shortcuts will save you a lot of time when applying filters to ranges or Tables in Excel.

Click here to download the file used in the video: https://www.excelcampus.com/tables/fi...

Learning keyboard shortcuts can really help us work more efficiently with Filters. There are a lot of features and options within the filter menus that can take extra time to navigate to with the mouse.

Keyboard shortcuts make this process much faster. In the video I explain some common filtering tasks like filtering for zeros, errors, blanks, custom search criteria, and more.

I also have an article that explains these shortcuts and tips in written form.

https://www.excelcampus.com/keyboard-...

I recommend getting a good keyboard that works well for Excel and keyboard shortcuts. Here is an article where I explain what to look for when buying a keyboard, and I also share some of my favorite keyboards.

https://www.excelcampus.com/keyboard-...

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 keyboard shortcut for filters. https://www.excelcampus.com/tables/fi...

Video #1:    • Excel Filters Training - Part 1 of 3  
Video #3:    • Excel Filters Training - Multiple Col...  
00:00 Introduction
00:31 Filter Dropdown Menu
06:49 Filtering for Blanks Zeros Errors
10:00 Filtering for Selected Cells Values
11:37 Filtering for Columns