Get the Filter Workbook
The same dataset from the video with all filter examples set up and ready to use.
Practice wildcards, date filters, and Advanced Filter criteria on your own.
No spam. Unsubscribe anytime.
Excel Filter Basics
In the filter basic tutorial you’ll learn the following:
- The shortcut key to turn filter on and off in Excel (Ctrl + Shift + L)
- How to do approximate matches (filter for words that contain a specific word)
- How to filter multiple columns
- How to filter for OR conditions using wildcards
- How to copy a filtered range to another sheet
- How to use formulas (such as subtotal) to sum a filtered range
- How to filter for values between 2 dates
- How to filter based on color
- How to turn your data set into an Excel table (Ctrl +T)
- How to add totals to your Excel table
Best Value
Excel Essentials Bundle
Excel’s Advanced Filter
The features for advanced filter can be accessed from the data tab. The advantage of using advanced filter is that you can see the filtered criteria in Excel cells.
You can also easily add new filters by typing the values directly in the cells. You just have to know how.
In the advanced filter tutorial, I show you how to do this and much more. You’ll learn:
- How to setup advanced filter
- How to use the criteria range in advanced filter
- How to use wildcards
- How to setup your criteria to filter for OR / AND conditions
- How to filter between two dates or two numbers with advanced filter
- How to get a list of unique values
Download the Free Workbook
Download the free practice file here.
Leila Gharani
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
