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)**

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

I need help sir regarding excel plzzz reply

Pingback: 8 tricks to boost Excel productivity | Resultize

Thank you very much that helped me alot

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.

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

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.

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.

Thanks a lot, frome the Netherlands.

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

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 …

It helped me a lot. Thank you very much.

Thank you very much.

Pingback: A Complete Introduction to Excel | MBAx.me

Nice and simple. Thanks.