Excel Filters Training - Part 1 of 3

In this video series you will learn how to work with the Filters in Excel. Filters hide and unhide rows to help us prepare our data for analysis and tie out numbers to formulas, pivot tables, and summary reports.

In this first video I explain an overview of filters and how to apply them to your data. I share some advantages of using Excel Tables for filtering data. I also show navigation shortcuts to help find filtered columns.

Click the following link to watch my video on a Beginners Guide to Excel Tables to learn more about this awesome feature of Excel.

The second video is all about keyboard shortcuts for the filter drop-down menus. These shortcuts will save you tons of time when working with filters.

In the third video you will learn how to apply filters to multiple columns with both AND and OR logic. I also explain the rules that Excel uses when applying filters to multiple columns.

Throughout the video series I will also be sharing an Excel Add-in I developed called Filter Mate. Filter Mate is a productivity add-in that will help save you time when working with filters.

[sarahruthgomes]

Some of the best tutorials I've found! Content is well organized across individual lessons and series, goals are clearly defined, narration, demos, and pace provide just enough guidance for the intermediate user, and your voice is pleasant. Thank you!

[dinacarella]

Total row in table & filter hop. I enjoyed your lesson on this, you made it so easy to apply.

[krismaly]

I really enjoyed watching this video and recommend others to watch and learn.

Host is an awesome teacher too. His voice and way of explaining I liked it and hope others will also like.

Host explains clearly and crisply the subject matter.

I watched many of his videos and all I liked and they enriched my knowledge on Excel.

Thanks for educating the community and appreciate your volunteership.

Thanks a bunch have a nice Thanksgiving day

[ykarina]

Thank you so much for this video. It was very easy to follow along and work on learning new shortcuts.

[motivated]

I am so excited and thankful I found your page...I'm taking an hour a day to learn and develop my skill set in this area...you're awesome!!!

[gellijayalakshmiharika]

Way to find out whether filter is applied or not is very nicee

[aprilcrawley]

I liked how you pointed out the variety of ways to know that a worksheet has been filtered. I would like to know how to utilize filters of a range copied from a pivot table .

[gulshanmehta]

very nicely demonstrated the tutorial. Sir, you made it very simpler. Thank you very much for sharing....

[strykerfrog]

Thank you sir. I was needing a tutorial like this.

[myrnasuyan]

Thank you so much. We really appreciate your videos. I love it. God bless you Mr. John 😊😇♥️

[jacquehiggins]

using tables to add multi-functions, great tip

[brookswhitford]

I have the filtering on the Quick Access Toolbar. Saves me time.

[alexrosen]

Great tutorial. Thanks for sharing :-)

[imranahmedkhan]

very beautiful voice and very good lecture.

[ashokrathor]

Really Awesome instructional vedio! !!

[rahulsingh-mjed]

HEY...JOHN REALLY TEACHING WAY VERY FANTASTIC....WILL YOU TELL ME HOW TO WORK ON MULTILE FILTER.

[nevado.]

my best filter tip is to while I am on filter cell, I hold down the Alt key with Down Arrow to select any individual item or to go to any other data I want rather than using the mouse.

[AsgharAli-ckqh]

Hi Jon,
Hopefully, you are doing well
you have a great job with excel and I hope that we will get a lot unique to learn there
The point to mail you was that I am too facing a problem in my excel sheet in filtering the data when I put the filter as my desire then the sum and grand total's row also go hide, so could you help me to solve this?

[ipshitabanerjee]

Hello Jon! most of your vedios explains about XL campus. I am new to Excel tutorials, can you please guide in which excel version will I get that? Also the developers icon in ur excel ribbon, which I dont have in my excel practice sheets.

[imranahmedkhan]

kindly guide about correlations and other add in.