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)

This entry was posted in Data Input & Manipulation and tagged , , , , , , . Bookmark the permalink.

16 Responses to Video Lesson: Advanced Filtering in Excel

  1. Anonymous says:

    Hi Ben, Thank you so much. It’s really useful video.

  2. javid says:

    I need help sir regarding excel plzzz reply

  3. Pingback: 8 tricks to boost Excel productivity | Resultize

  4. Hawraz says:

    Thank you very much that helped me alot

  5. Sharon Pendorf says:

    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.

  6. Kell Getting it In McClen says:

    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

  7. Anonymous says:

    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.

  8. Anonymous says:

    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.

  9. Jos says:

    Thanks a lot, frome the Netherlands.

  10. Anonymous says:

    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

  11. Vini says:

    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 …

  12. Viswanath says:

    It helped me a lot. Thank you very much.

  13. Anonymous says:

    Thank you very much.

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

  15. Phillip says:

    Nice and simple. Thanks.

Leave a Reply