How to Filter in Excel

In this step-by-step tutorial, learn how you can use filtering in Microsoft Excel. In this video, I walk through the following:

0:00 Introduction
0:53 Basic Filtering
11:23 Advanced Filtering
13:29 The new Filter Function

As full disclosure, I work at Microsoft as a full-time employee.

[timandersentheappraisersad]

Kevin, I am a consultant to real estate appraisers. This filtering function is just GOLD for them and should save an Everest of time for them! Thank you!

[BlueTigerRunning]

OMG, thanks for making this so simple. I've been using the sort feature for years, but never used filter for some reason. This will make things SO much easier. I love how you make it so simple and clear, thank you!

[CRUX]

You just solve a very huge problem for me that would save me hours of working. Do you know that I have been gathering data and working on them for 5 days already? With this filtering it would take at most 1-3 hours total. Great video, thank you so much Kevin. I always enjoy your videos. Thank you for your time I do appreciate it.

[davidobrien]

Thank you Kevin. This has been enormously helpful. I am working on a large spreadsheet as we speak and this video has helped me chop away 95% of the data, leaving the bits I need. Exactly what I wanted.

[pabloochoacarrera-dzvc]

I just came to this video hoping for an answer to some problems in excel, but I saw your channel, and know I understand everything a lot more.

Thank you Kevin.

One more suscriptor

[larrykhanmiller]

Thanks, Kevin for the video, it helps me with my first statistics class.
They go too fast in school thinking everyone knows this already, refresher tutorials always help.

[conniesmith]

Very helpful and I appreciate your cheerfulness. This stuff takes some concentration for us in our 60s!

[mr.ahmedjama]

Amazing explanation. I like your explanation especially when you come up with some data and explain the concept using that data.

[danielgrandmont]

Hi Kevin, Great video! short and sweet and right to the point. Thank you

[marisbesakirskij]

Thank's Kevin for a great lesson! Greetings,
from Latvia!

[deondraparks]

You did an awesome job. Was able to follow you step by step. Was not as scary as I thought it would be. Thank you.

[capt]

Kevin..can't thank you enough for the work you have done...one of the best tutorial on the subject ..easy and straight forward with practical examples
Keep the good work .

[roseanneenriquez]

Thank you, just got a promotion and I need to learn this basic stuff!! You are a lifesaver!

[sa-ma_]

Hi Kevin, great video as always. And there will never be enough Excel videos on your channel!
I like the way in which you summarize a potentially much wider subject in a 15-to-20 minute video, getting straight to the content without wasting 1/3 of the video with pointless introductions as many You Tubers do.
In the way of requests the list is very long: more multi-media videos, maybe a Photoshop one, now and again a “nerdy” video (what are the basic specs when it comes to replacing my old PC/Laptop...)
Thank you again

[yavor]

Great tutorial - starting from the simple and moving towards the more complex, all explained in a clear way with good examples. Thank you!

[conradl]

I like that: Beginner (that’s me) and advanced (hey! I can do that too!) in the same video. And very clear.
Thanks

[carmenhorvath]

Thank you so much for this easy to follow video, exactly what I needed to solve a dead end at work :). Have a great day !

[AntonJansenvanVuuren]

I love this stuff. Thanks for an amazing YouTube channel

[Gabi-kvjh]

thank you so much kevin, this video was very helpful to me and you explains evrything i a very beautiful calm way, thanks again

[tjmsyd]

This is just what I needed -thank you!