Video Lesson: Advanced Filtering in Excel

Using auto-filters in Excel provides a useful way to drill down and extract data from spreadsheets.

This video lesson explains multiple ways you can use filters in Excel.

Make sure to download the most recent Master Workbook so that you can follow along.

Next in the Lesson Guide is Creating and Designing Charts (including Sparklines)

13 thoughts on “Video Lesson: Advanced Filtering in Excel

  1. I am really finding this series extremely useful. However, even though I have downloaded the Master Workbook, and would also like to download the workbook mentioned in the Excel 2013 Tour (truly awesome) I am not sure how to do so within your excellent Excel examples. I shall persevere but would appreciate any and all advice and assistance.

  2. Thank you soo much for all your work. I don’t know what reason you had to make this website but I am grateful that you did. Very detailed, and you gave us a workbook so we can do it on our own. This content is just what I needed to dust off and update my excel skills.
    Thanks Man

  3. Hi, I would like to know where does the search box come from when you click on the filter. After text filters, the version I am using does not have the search box.

  4. Ben – these videos are great. Is there a way to filter using shapes? I have a spreadsheet and want to filter the rows that have an object/shape in them.

  5. Great videos! Really very good explanations!
    Just a small comment: Theres no need to select the whole table. You can just click on the row number (in this case 5) and then click on filter. At least this works for me…might be that in more complicated cases your way is neccessary. In that case, sorry 🙂

    • Great point, but the method of selecting the entire table is sometimes useful if you have blank rows in between data.

      If all of your data is in a nice and neat table, you are correct that Excel will guess the active range you’re in is where you’d like the filter.

      I just wanted to show the long(er) method here in case people don’t have their data as nicely formatted as the example.

      Thanks for the comment!

      Ben

  6. Awesome!!! I am very happy that I have found such a great Website in which I can learn and practice Excel!!! Please, keep enriching it with new trainings …

  7. Pingback: A Complete Introduction to Excel | MBAx.me

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s