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!
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.
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.
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.
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).
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.
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.
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.
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!
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
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!!
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
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.
Really amazing tutorial videos. These help us discover some very simple yet unexplored and extremely handy Excel tips and tricks. Highly recommend everyone to subscribe to this channel.
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.
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
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!
Grab the file I used in the video from here 👉 pages.xelplus.com/filter-basics-file
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!
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.
You are such a genuine and smart girl ever.
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.
Great to hear you found something new!
Wow, never knew Filters were this powerful, awesome thanks for this.
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.
Ohhh thank you Gopala! That is really really kind of you! I very much appreciate your support.
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).
Thanks for the tip!
Leila, You're the best I've seen on RUclips on Excel. Thank you so much.
Wow, thank you!
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.
Thanks Leila, your short tutorial has been helpful. I'm going to start using the shortcut that you demonstrated.
Awesome filter tricks : )
Thanks Mike :)
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.
Thank u so much now i understand filtering data analysis thnx for ur help god may bless u for helping many ppl
Very clear explanations. Thank you for posting!
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.
Leila your way of delivering lecture is appreciated and great thanks ♥️
Thank you! 😃
@@LeilaGharani keep it up🥰🥰
great work, keep up shinning, helps a lot
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.
You're so welcome!
Thankyou for providing excel workbook for practice
The table option allows me to filter in one column that is across multiple groups! Thank you!
3:12 As I know I need this very often, I added the command "Clear All Filters" to Quick Access Toolbar.
Many thanks, simple useful and comprehensive.
You are a "ROCKSTAR" Leila!!!
Thank you!!!!! Whew, so understandable. I just learn about your channel yesterday because I'm studying People Analytics.
Welcome!
Excellent instructor. I meant, beautiful instructor and excellent instructional video. Dale!
Thank you; I learn something new from you every time. You are an excellent teacher.
You're welcome. Thank you for the kind words and for your support.
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!
Thank you, this video was very helpful, I struggled trying to do this for months!!
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
Am Learning a lot from you , thanks alot for your kind effort and kindness to share all this knowledge with us .mercy
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!!
Glad it was helpful Gary!
Mam it amesome, your all tutorials are very useful and new techniques you should teach, many many thanks !!
You're very welcome Shirish. Glad you like the tutorials.
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
That's great :) I'm curious if you'll find something new in the advanced filter one for next week....
I have just come across your channel and they are great and you are a great teacher keep up the good work.
Thank you very much. Your videos are very clear and interesting. It helped me a lot.🤗
Thanks Leila. Looking forward for the Advance Filter
You’re welcome John.
Marvelous!! Wonderful vid, thank you so much for such a useful content!!
Oh how good is the 'Total Row' option! I can't wait to use it!
Thank you Ms. Gharani! This was so helpful
Thank you so much Leila.
Very useful and helpful.
Thanks a lot! The tutorials are amazing!
Leila many many thanks for your clear and detailed explanation i like the idea of transforming my range to a table and colour filter
Great! I'm very happy you found something valuable here.
Leila Gharani all of your lessons are valuable
Really enjoying the explanation. Easy to understand. Thanks!
You're welcome. I'm glad to hear that Azeem.
I really like how you get right to the point. Thank you
You're very welcome Joe. Happy you like the content. Thank you for your support.
excellent video! very easy to follow and to the point. Thank you
Glad you enjoyed it!
I love ur videos even without watching it...
Hi Leila, Thank you for sharing. This was a good opportunity for me to review my knowledges.
Glad to hear that Mehdi. Thanks for dropping by.
It was simply awesome, Leila.
Glad you like it Imran.
thank you, i love you ❤
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.
Great work Leila!
Thanks! I'm glad the tutorial is useful.
Excellent video, Leila, you are excellent!
Glad you like it! Thanks for your kind comment & support!
Great Video as always Leila👍. Thanks.
You're welcome Monte.
Salute to my great teacher Leila Gharani
very useful vedio like all of yours.
Thnx for this amazing stuffs. God bless u.
Very helpful as usual. Thanks a lot for sharing your knowledge!
You’re very welcome. Thank you for your support.
Great tutorial! Awesome filter. Thanks Leila mam ☺️👍
You're very welcome Pallab.
Appreciated. I thought I am good at filter. But I learned more from your video!
Even I learned a lot from her videos love u Lelia
Awesome Tricks.... Thank you Laila.... keep us teaching....
Totally enjoyed it your vedios and way of explanation are totally awesome
Thank you! Glad you like the videos & the explanations :)
Thank you for the data file so that I can practice.
You can also use Alt+D+F+F to apply filter and Alt+D+F+S on unfilter everything without removing filters.
GOOD JOB greetings Leila from MEXICO
Really amazing tutorial videos. These help us discover some very simple yet unexplored and extremely handy Excel tips and tricks. Highly recommend everyone to subscribe to this channel.
Thank you!
Awesome Filter details LG
Hi. I am getting issues in filtering my data. In fact i have to select all records after 21:15:00. To note the time has been input as text format.
never been used that table function..thanks I learned something today about it..
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.
super clear! thanks!!
Many, many thanks Leila!
You're very welcome Zahid.
Very nice explanation mam...m learning a lot from u mam
Thank you Ubaid for your comment. I'm happy to hear that.
Fab. Thank you 😜
Thank you for tutorial its very useful for me, thanks again
You're very welcome Vishwa. Glad you find it useful.
Amazing video! Thank you very much.
You're very welcome Amrinder :)
Amazing i just got to know the *blue* filter thank you Ms. Leila
:) I'm happy to hear that Ismail.
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?
Excellent presentation
Glad you like it! Thanks for your support.
Madam a very cool and pleasent way to explain filer basics
😇😇😇😇😇😇😇
Glad you like it Harish :)
Thank you 🤗
So useful, thank you!
you re a savior!!!!
Good explaination
Thank you very much.
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
Thanks Sachin. Yes, I wasn't aware of that shortcut for the longest time....
Excellent keep it up it is starting to workout for me 😁
Great! Thanks for your support.
Great stuff! Thanks Leila. Already looking forward to part 2 :-)
Glad to hear you like it.
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
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!
Amazing! Its really helpful .. Thanks 💓
Glad you find it helpful :)
First time see video simply awesome madam
Glad you like it Huzaifah! Thanks for dropping by.
May I ask question about, how would I use 1) subtotal sum 2)only visible items 3) number
Very best 👌
Thank you Leila.
Thank you Leila
Very helpfull thanks!!
great stuff thanks
What is the difference between OR & AND when it comes to blue/white shirts?
great video
is it any method that I can capture the filter data for channels at once?