Filter Basics First
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
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 file HERE
Leila Gharani
I’ve spent over 20 years helping businesses use data to improve their results. I've worked as an economist and a consultant. I spent 12 years in corporate roles across finance, operations, and IT—managing SAP and Oracle projects.
As a 7-time Microsoft MVP, I have deep knowledge of tools like Excel and Power BI.
I love making complex tech topics easy to understand. There’s nothing better than helping someone realize they can do it themselves. I’m always learning new things too and finding better ways to help others succeed.
