Excel Filter Basics (for quick data analysis)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/filter-basics-file

[@andyroid7339]

I've watched tens of Leila's tutorials and every lesson is so clear and easy to digest. I really learn from Leila's style. The videos are just the right length and the info is concise; once I've finished watching I go to Excel to try out what I've picked up. Thanks Leila!

[@prakharsinha5397]

Wow, never knew Filters were this powerful, awesome thanks for this.

[@joelmuricho6051]

Hi leila i am in Kenya and your tutorials are very clear and easy to understand. I am an instructor in a computer school and the tutorials have helped me so much. Thanks.

[@bluejeans706]

All your videos are just incredible! I've been using Excel for a very long time, and really didn't think there would be anything to learn from this video, but thought maybe there's something in here that I forgot about using so watched it. Lo and behold I learned something new.

[@LeilaGharani]

Great to hear you found something new!

[@1gopalakrishnarao]

Well Explained Madam. I want to put your Videos as A=ACCURATE, B= BRIEF, C= CLARITY, D= DYNAMIC, & E= EXCELLENT. like this up to Z. Thanks a lot to My beloved and beautiful EXCEL GURU. I pray the almighty to bestow good health, as she is doing a great job.

[@LeilaGharani]

Ohhh thank you Gopala! That is really really kind of you! I very much appreciate your support.

[@alexanderkuklin8967]

Hi Leila, thank you for your videos! I'm studying your PowerQuery tutorial right now, and it's great. By the way, there's another easy way to clear your filters: Alt, A, C. It's even quicker than pressing Ctrl+Shift+L twice (@3:19).

[@LeilaGharani]

Thanks for the tip!

[@Pablo_Trader]

Thanks Leila, your short tutorial has been helpful. I'm going to start using the shortcut that you demonstrated.

[@1000tastebuds]

Leila, You're the best I've seen on KZbin on Excel. Thank you so much.

[@LeilaGharani]

Wow, thank you!

[@excelisfun]

Awesome filter tricks : )

[@LeilaGharani]

Thanks Mike :)

[@muhammadnomansaeed8607]

Sir Mike your channel is excellent. I learnt a lot from your channel. This Channel of Ms. Leila is also excellent. Thanks for all of your efforts to help us, highly appreciated.

[@rakibulmahmud3253]

Thankyou for providing excel workbook for practice

[@sharjeelmazhar-y9e]

great work, keep up shinning, helps a lot

[@miklosmuller]

Hi Leila, i like your videos they are very good. I have a problem with the AutoFilterClassic. Do you use this Filter? I use alot of the filter in Excel, especially the AutofilterClassic Filter. If the datas are the Normal Range, then AutofilterClassic option works perfectly. I selected a cell and select the filter, and only the value of the cell is filtered by Excel. When i create a table (CTRL+T) in excel, and use AutoFilterClassic icon from my Quick Access Toolbar, unfortunately does'not work, just turn the filter on and off. I don't like use the mouse/Right click/Filter/Filter Selected by Cell's Value. I think AutoFilterClassic is a very good thing in excel. Please help in this case.

[@ltronics62]

Very clear explanations. Thank you for posting!

[@sneha2169]

Hi Leila. How come you are using a * sign to search for shirts or sites? Can you not just search for shirts or sites WITHOUT the * sign?

[@nyancole]

Thanks for your lessons in excel. I have just begun watching few of them and I'm growing a huge interest in the practical way you present your lessons.

[@AlsenseiAMA]

Thank you! I was looking for how to filter with the results of formulas for just those rows for a long time. Your explanation was easy and clear.

[@anupamawenzel5000]

The table option allows me to filter in one column that is across multiple groups! Thank you!

[@husnijutt3442]

Leila your way of delivering lecture is appreciated and great thanks ♥️

[@LeilaGharani]

Thank you! 😃

[@husnijutt3442]

@@LeilaGharani keep it up🥰🥰

[@domhough8914]

Many thanks, simple useful and comprehensive.

[@pinkpooh9788]

Hey Leila. Thank you so much for making so many useful videos. I have been watching your videos and came across so many new tips that I didn't even have idea about. Thanks you so much again.

[@LeilaGharani]

You're so welcome!

[@bekkishetter7504]

Thank you; I learn something new from you every time. You are an excellent teacher.

[@LeilaGharani]

You're welcome. Thank you for the kind words and for your support.

[@nicouekuete8842]

You are a "ROCKSTAR" Leila!!!

[@sayangchen9924]

May I ask question about, how would I use 1) subtotal sum 2)only visible items 3) number

[@qunwang5165]

Thanks a lot! The tutorials are amazing!

[@garys2187]

Excellent. Thank you. I always wondered how to get rid of the default colors that are created in a table and you explained that with one simple click!!

[@LeilaGharani]

Glad it was helpful Gary!

[@ahmedelgammal5889]

Leila many many thanks for your clear and detailed explanation i like the idea of transforming my range to a table and colour filter

[@LeilaGharani]

Great! I'm very happy you found something valuable here.

[@ahmedelgammal5889]

Leila Gharani all of your lessons are valuable

[@joedelarios1]

I really like how you get right to the point. Thank you

[@LeilaGharani]

You're very welcome Joe. Happy you like the content. Thank you for your support.

[@Lusandro]

6:56 Leila, if you change drop-down to “does not contain” for both would you join them with AND or OR? Please explain why you would use one or the other operator. Thanks!

[@johnborg6005]

Thanks Leila. Looking forward for the Advance Filter

[@LeilaGharani]

You’re welcome John.

[@engahmedegy1]

thank you, i love you ❤

[@latifahfahad6121]

What to use instead of filter function because my version is 2019 😢?

[@heligomez8048]

Thank you, this video was very helpful, I struggled trying to do this for months!!

[@lululemonlok4291]

is it any method that I can capture the filter data for channels at once?

[@tahata7436]

Am Learning a lot from you , thanks alot for your kind effort and kindness to share all this knowledge with us .mercy

[@srikanthtr753]

When I check 'Total Row' option in the Table Design (as demonstrated at 9:09 in your video), Excel adds the Total row with subtotal, however its doesn't provide a list of other options like count/Max/Min etc. Can you please advise what am I missing.

[@amiraboodi2075]

Thank you very much. Your videos are very clear and interesting. It helped me a lot.🤗

[@MrTosha43]

I have just come across your channel and they are great and you are a great teacher keep up the good work.

[@missadventure7564]

Hi, I do not see "Date Filte" as you have. Is it something new on latest version? I have option text filer with options and custom filter

[@09shirish]

Mam it amesome, your all tutorials are very useful and new techniques you should teach, many many thanks !!

[@LeilaGharani]

You're very welcome Shirish. Glad you like the tutorials.

[@AronPrince1967]

Thank you!!!!! Whew, so understandable. I just learn about your channel yesterday because I'm studying People Analytics.

[@LeilaGharani]

Welcome!

[@minra]

Dear Leila, It is not necessary to put starsigns in the searchbar (unnecessary effort). 2:26 The term "shirt" only will do with the same wildcard result. Cheers

[@mswordexpert]

very useful vedio like all of yours.

[@anshuiway]

First time I already knew and using all the trick which u show on this video. Like custom filter color filter Subtotal on filter deta. I m feeling very happy

[@LeilaGharani]

That's great :) I'm curious if you'll find something new in the advanced filter one for next week....

[@hathawayamato]

Thank you Ms. Gharani! This was so helpful

[@djjammindave]

Excellent instructor. I meant, beautiful instructor and excellent instructional video. Dale!

[@NadiaDAidan]

excellent video! very easy to follow and to the point. Thank you

[@LeilaGharani]

Glad you enjoyed it!

[@MadamAdam67]

Hi Leila, I am having an excel issue and I am looking everywhere for how to do this. I have a spreadsheet, on it, I have several bits of information listing (for example) % increase and a country name. How can I get these to sort automatically? Whatever I try throws all the data into disarray, the numbers do not match up with the country names. I've tried several different excel hints from KZbin and still no luck. I'd greatly appreciate a pointer!

[@tutsecret499]

Thank you for the data file so that I can practice.

[@axeemx]

Really enjoying the explanation. Easy to understand. Thanks!

[@LeilaGharani]

You're welcome. I'm glad to hear that Azeem.

[@sneha2169]

What is the difference between OR & AND when it comes to blue/white shirts?

[@sasavienne]

Thank you so much Leila. Very useful and helpful.

[@mariaemilialeonsanchez2123]

Hi Leila! I have a question, I've been looking some of your filter videos. But I couldn't see an example of what happens if you want to lookup multiple parameters on a filter. For example, in this video that you have, let's say you wanted to filter by the sales values, but you have 10 different ones. Instead of going one by one filtering, how could you do it all at once? Consider that the sales values don't have any other matching criteria (i.e. color, starting letter) since each is unique. Hopefully this makes sense. Thank you so much, and your videos are super helpful!

[@Deedington]

Great work Leila!

[@LeilaGharani]

Thanks! I'm glad the tutorial is useful.

[@valunomics738]

It was simply awesome, Leila.

[@LeilaGharani]

Glad you like it Imran.

[@azizniazi9159]

Salute to my great teacher Leila Gharani

[@DiamondDiamondHeart]

Oh how good is the 'Total Row' option! I can't wait to use it!

[@yahtadi5152]

Mam. When data input is date, does filter features will automatically grouping as a year? or do i have to do it manually? if manually, how to do that?

[@JV-xg5jk]

Thanks Leila! Is there anyway we can filter by color for 2 or more colors? Or select all except a particular color??

[@heysimoo]

super clear! thanks!!

[@rmohabali]

Excellent video, Leila, you are excellent!

[@LeilaGharani]

Glad you like it! Thanks for your kind comment & support!

[@AmitSharma-ft7jb]

I love ur videos even without watching it...

[@luismoreyra6804]

Marvelous!! Wonderful vid, thank you so much for such a useful content!!

[@swsw5959]

Thank you very much.

[@raghuv7114]

Leila Madam, Basically which excell version you will be using ?? Is it office 365 insider????

[@LeilaGharani]

I use both regular Office 365 and Office 365 Insider Fast.

[@raghuv7114]

@@LeilaGharani what is difference between them?

[@LeilaGharani]

With Office Insider you get the latest functions that are still in testing phase, e.g. XLOOKUP

[@monte4955]

Great Video as always Leila👍. Thanks.

[@LeilaGharani]

You're welcome Monte.

[@seyedjamalghaemmaghamiheza1907]

Dear Leila. Thank you for your videos. I have a problem. Will you please solve that for me. I have a big table with 17000 row And 60 column. I need to filter this table with one of variables and I need only to show some colum not all. Thank you

[@LeilaGharani]

Check out this video: kzbin.info/www/bejne/m6fVn3yrebenqbM

[@seyedjamalghaemmaghamiheza1907]

@@LeilaGharani thank you is there another way?

[@mehdihammadi6145]

Hi Leila, Thank you for sharing. This was a good opportunity for me to review my knowledges.

[@LeilaGharani]

Glad to hear that Mehdi. Thanks for dropping by.

[@ZAHIDHUSSAIN-ri5kg]

Many, many thanks Leila!

[@LeilaGharani]

You're very welcome Zahid.

[@danielhutchinson6158]

Thank you Leila.

[@magdyelzawawy2755]

I am using formula Sumifs(index(E6:AU100),,Match(b1,E6:AU6),A6:A100,A2), this an example of formula I am using and it reads from Power query table and every time I refresh and add data to the power query the array in the formula gets expanded except the one from the index which it makes all the formula return #Value. Do you have any idea how to fix this ???

[@PankajKumar-jw7gf]

Good explaination

[@CarlosAguilar-xw7ot]

Very helpful as usual. Thanks a lot for sharing your knowledge!

[@LeilaGharani]

You’re very welcome. Thank you for your support.

[@jasonthompson4636]

if my spreadsheet is pulling data from other spreadsheets all with connecting formulas will filters cause issues with that?

[@shanesmohammed]

Awesome Filter details LG

[@kabootty]

Excellent presentation

[@LeilaGharani]

Glad you like it! Thanks for your support.

[@arshadullah1066]

Thnx for this amazing stuffs. God bless u.

[@jheanpalmejan]

you re a savior!!!!

[@nitaadams5151]

Thank you 🤗

[@megan2484]

Is it possible to combine IF and SUBTOTAL functions in one formula?

[@LeilaGharani]

Yes.

[@teodoraguleva7609]

So useful, thank you!

[@RogerStocker]

3:12 As I know I need this very often, I added the command "Clear All Filters" to Quick Access Toolbar.

[@rtlinsn5085]

Thank you Leila

[@basupallab91]

Great tutorial! Awesome filter. Thanks Leila mam ☺️👍

[@LeilaGharani]

You're very welcome Pallab.

[@wendymoran1912]

Fab. Thank you 😜

[@BezUmiaru]

How to make a filter based on the text typed in a separate cell that filters the original table rather than creates a separate table with results? If possible, with functions not VB.

[@guadalupeaguilera7818]

GOOD JOB greetings Leila from MEXICO

[@paulrxxxmann6718]

in my textbook there is subtotal fx , whereby the words subtotal ( of whatever as text ) appears , with followng no. insert how can i do this please ? eg .... SUBTOTAL pencils : 556677

[@atiaabdelkader1905]

Thank you a lot

[@flightforge30]

never been used that table function..thanks I learned something today about it..

[@gauravbatra346]

You can also use Alt+D+F+F to apply filter and Alt+D+F+S on unfilter everything without removing filters.

[@chrizwhizfren2400]

Well...hopefully in 2 months time i drive to tlc in pj and work there for a year and later till i am 60 years old. God bless you ...hope i drive effuciently there is in pj8

[@ahmedeid5381]

Sometimes I type CTRL+SHIFT+L and I find a massage says "No cells were found", what does this mean?

[@amrindersingh9568]

Amazing video! Thank you very much.

[@LeilaGharani]

You're very welcome Amrinder :)

[@ismailismaili0071]

Amazing i just got to know the *blue* filter thank you Ms. Leila

[@LeilaGharani]

:) I'm happy to hear that Ismail.

[@VishwaJeetDwivedi]

Thank you for tutorial its very useful for me, thanks again

[@LeilaGharani]

You're very welcome Vishwa. Glad you find it useful.

[@karishmasharma471]

How to save the file when we use the filter. It appears that when I remove the filter, it removes my criteria.

[@hasankabir3180]

Great! When we will get the Advance filter vedio ?

[@LeilaGharani]

Next one should be out on Thursday - although I'm travelling this week, but I'll try to get it out around that time...

[@mohdirfan7291]

Totally enjoyed it your vedios and way of explanation are totally awesome

[@LeilaGharani]

Thank you! Glad you like the videos & the explanations :)

[@sachinrv1]

Lovely and useful. By the way many of us are habitual using short-cut keys ALT"D"+F+F. I did not know I can use CTRL+SHFT+L

[@LeilaGharani]

Thanks Sachin. Yes, I wasn't aware of that shortcut for the longest time....