Filter Basics First

In the filter basic tutorial you’ll learn the following:

  1. The shortcut key to turn filter on and off in Excel (Ctrl + Shift + L)
  2. How to do approximate matches (filter for words that contain a specific word)
  3. How to filter multiple columns
  4. How to filter for OR conditions using wildcards
  5. How to copy a filtered range to another sheet
  6. How to use formulas (such as subtotal) to sum a filtered range
  7. How to filter for values between 2 dates
  8. How to filter based on color
  9. How to turn your data set into an Excel table (Ctrl +T)
  10. 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:

  1. How to setup advanced filter
  2. How to use the criteria range in advanced filter
  3. How to use wildcards
  4. How to setup your criteria to filter for OR / AND conditions
  5. How to filter between two dates or two numbers with advanced filter
  6. How to get a list of unique values

Download the file HERE

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.