Excel Filter Basics (for quick data analysis)

No video

Excel Filter Basics (for quick data analysis)

Рет қаралды 276,018

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Unlock the full potential of Excel filters with this beginner-friendly tutorial. Perfect for anyone dealing with large data tables, learn the basics of Excel's filtering capabilities to streamline your data analysis process.
⬇️ Download the workbook here: pages.xelplus....
🌟 Key Learning Points:
- Quick Filter Activation: Discover how to quickly apply filters to your data using keyboard shortcuts and menu options.
- Filter by Selection: Learn how to filter data based on specific cell values, ideal for focusing on certain data subsets.
- Wildcard Searches: Understand how to use wildcard characters to filter data based on partial information.
- Color-Based Filtering: Find out how to filter data based on cell color, adding a visual aspect to your data sorting.
- Copying Filtered Data: Get insights into copying only the visible, filtered data to another sheet.
- Date Filters: Explore the various automatic date filter options, such as filtering by month, year, or specific date ranges.
- Using OR in Filters: Learn how to apply the OR condition in filters to display data meeting any one of multiple criteria.
- Subtotal Function: Understand how to use the subtotal function to sum only visible, filtered data.
🚀 Practical Applications:
- Simplify data analysis by quickly filtering large datasets.
- Extract and focus on specific data points with ease.
- Efficiently copy and analyze only relevant data, avoiding hidden rows.
★★ Links to related videos: ★★
Check out my Excel Basics Playlist here: • Excel Introduction - L...
★ My Online Excel Courses ★ www.xelplus.co...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 244

@LeilaGharani 7 ай бұрын

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

@andyroid7339 2 жыл бұрын

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 17 күн бұрын

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.

@1gopalakrishnarao 6 жыл бұрын

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 6 жыл бұрын

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

@bluejeans706 4 жыл бұрын

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 4 жыл бұрын

Great to hear you found something new!

@alexanderkuklin8967 2 жыл бұрын

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 2 жыл бұрын

Thanks for the tip!

@1000tastebuds 6 ай бұрын

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

@LeilaGharani 6 ай бұрын

Wow, thank you!

@nyancole 2 жыл бұрын

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 4 жыл бұрын

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.

@paulmartineau3850 Жыл бұрын

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

@ltronics62 3 жыл бұрын

Very clear explanations. Thank you for posting!

@anupamawenzel5000 4 жыл бұрын

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

@domhough8914 4 жыл бұрын

Many thanks, simple useful and comprehensive.

@rakibulmahmud3253 3 жыл бұрын

Thankyou for providing excel workbook for practice

@nicouekuete8842 3 жыл бұрын

You are a "ROCKSTAR" Leila!!!

@djjammindave 5 жыл бұрын

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

@bekkishetter7504 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@excelisfun 6 жыл бұрын

Awesome filter tricks : )

@LeilaGharani 6 жыл бұрын

Thanks Mike :)

@muhammadnomansaeed8607 6 жыл бұрын

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.

@azizniazi9159 5 жыл бұрын

Salute to my great teacher Leila Gharani

@RogerStocker 4 жыл бұрын

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

@husnijutt3442 Жыл бұрын

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

@LeilaGharani Жыл бұрын

Thank you! 😃

@husnijutt3442 Жыл бұрын

@@LeilaGharani keep it up🥰🥰

@garys2187 4 жыл бұрын

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 4 жыл бұрын

Glad it was helpful Gary!

@pinkpooh9788 4 жыл бұрын

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 4 жыл бұрын

You're so welcome!

@danielhutchinson6158 Жыл бұрын

Thank you Leila.

@minra 7 ай бұрын

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

@jheanpalmejan 2 жыл бұрын

you re a savior!!!!

@tahata7436 2 жыл бұрын

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

@AmitSharma-ft7jb 2 жыл бұрын

I love ur videos even without watching it...

@heligomez8048 4 жыл бұрын

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

@johnborg6005 6 жыл бұрын

Thanks Leila. Looking forward for the Advance Filter

@LeilaGharani 6 жыл бұрын

You’re welcome John.

@anshuiway 6 жыл бұрын

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 6 жыл бұрын

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

@DiamondDiamondHeart 5 жыл бұрын

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

@joedelarios1 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@guadalupeaguilera7818 2 жыл бұрын

GOOD JOB greetings Leila from MEXICO

@gauravbatra346 4 жыл бұрын

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

@09shirish 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@amiraboodi2075 2 жыл бұрын

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

@tutsecret499 Жыл бұрын

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

@ahmedelgammal5889 6 жыл бұрын

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 6 жыл бұрын

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

@ahmedelgammal5889 6 жыл бұрын

Leila Gharani all of your lessons are valuable

@MrTosha43 5 жыл бұрын

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

@hathawayamato 3 жыл бұрын

Thank you Ms. Gharani! This was so helpful

@swsw5959 Жыл бұрын

Thank you very much.

@user-vh6hr1jm4u 4 ай бұрын

great work, keep up shinning, helps a lot

@rtlinsn5085 4 жыл бұрын

Thank you Leila

@sasavienne 5 жыл бұрын

Thank you so much Leila. Very useful and helpful.

@qunwang5165 Жыл бұрын

Thanks a lot! The tutorials are amazing!

@arshadullah1066 2 жыл бұрын

Thnx for this amazing stuffs. God bless u.

@NadiaDAidan 3 жыл бұрын

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

@LeilaGharani 3 жыл бұрын

Glad you enjoyed it!

@flightforge30 5 жыл бұрын

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

@AronPrince1967 4 жыл бұрын

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

@LeilaGharani 4 жыл бұрын

Welcome!

@axeemx 6 жыл бұрын

Really enjoying the explanation. Easy to understand. Thanks!

@LeilaGharani 6 жыл бұрын

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

@nitaadams5151 2 жыл бұрын

Thank you 🤗

@luismoreyra6804 2 жыл бұрын

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

@PankajKumar-jw7gf 4 жыл бұрын

Good explaination

@valunomics738 6 жыл бұрын

It was simply awesome, Leila.

@LeilaGharani 6 жыл бұрын

Glad you like it Imran.

@mswordexpert 4 жыл бұрын

very useful vedio like all of yours.

@mehdihammadi6145 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

Glad to hear that Mehdi. Thanks for dropping by.

@jingwu8461 5 жыл бұрын

Appreciated. I thought I am good at filter. But I learned more from your video!

@mmincredible1451 5 жыл бұрын

Even I learned a lot from her videos love u Lelia

@chrizwhizfren2400 3 жыл бұрын

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

@ZAHIDHUSSAIN-ri5kg 6 жыл бұрын

Many, many thanks Leila!

@LeilaGharani 6 жыл бұрын

You're very welcome Zahid.

@abcd24730 3 жыл бұрын

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.

@LeilaGharani 3 жыл бұрын

Thank you!

@wendymoran1912 Жыл бұрын

Fab. Thank you 😜

@rmohabali 6 жыл бұрын

Excellent video, Leila, you are excellent!

@LeilaGharani 6 жыл бұрын

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

@ismailismaili0071 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

:) I'm happy to hear that Ismail.

@atefteleb3094 4 жыл бұрын

very impressive

@Deedington 5 жыл бұрын

Great work Leila!

@LeilaGharani 5 жыл бұрын

Thanks! I'm glad the tutorial is useful.

@heysimoo 3 жыл бұрын

super clear! thanks!!

@basupallab91 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

You're very welcome Pallab.

@atiaabdelkader1905 3 жыл бұрын

Thank you a lot

@shanesmohammed 5 жыл бұрын

Awesome Filter details LG

@CarlosAguilar-xw7ot 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@monte4955 6 жыл бұрын

Great Video as always Leila👍. Thanks.

@LeilaGharani 6 жыл бұрын

You're welcome Monte.

@sachinrv1 6 жыл бұрын

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 6 жыл бұрын

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

@MBD2903 6 жыл бұрын

Awesome Tricks.... Thank you Laila.... keep us teaching....

@VishwaJeetDwivedi 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@kabootty 6 жыл бұрын

Excellent presentation

@LeilaGharani 6 жыл бұрын

Glad you like it! Thanks for your support.

@teodoraguleva7609 4 жыл бұрын

So useful, thank you!

@harishpaldhir5915 6 жыл бұрын

Madam a very cool and pleasent way to explain filer basics 😇😇😇😇😇😇😇

@LeilaGharani 6 жыл бұрын

Glad you like it Harish :)

@mohdirfan7291 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@19761999 5 жыл бұрын

Lady, YOU ROCK!

@ajaycan 4 жыл бұрын

great video

@tedland3016 3 жыл бұрын

great stuff thanks

@amrindersingh9568 6 жыл бұрын

Amazing video! Thank you very much.

@LeilaGharani 6 жыл бұрын

You're very welcome Amrinder :)

@amraref9116 2 жыл бұрын

Very best 👌

@UbaidUllah-nj5et 6 жыл бұрын

Very nice explanation mam...m learning a lot from u mam

@LeilaGharani 6 жыл бұрын

Thank you Ubaid for your comment. I'm happy to hear that.

@k50159 3 жыл бұрын

Much appreciated!

@ruchigupta6520 5 жыл бұрын

Very nice.

@LeilaGharani 5 жыл бұрын

Glad you like it.

@imrankhalidsialkhalid5112 Жыл бұрын

thank you..

@roybayona3475 3 жыл бұрын

thanks

@urchaitanya 6 жыл бұрын

Excellent keep it up it is starting to workout for me 😁

@LeilaGharani 6 жыл бұрын

Great! Thanks for your support.

@user-lu1mh5py5r 5 жыл бұрын

thanks very much it helps a lot your lecture

@engahmedegy1 3 жыл бұрын

thank you, i love you ❤

@sibesomunyinda9574 5 жыл бұрын

Really helpful. Thank you

@doraramos4735 5 жыл бұрын

Very helpfull thanks!!

@alexrosen8762 6 жыл бұрын

Great stuff! Thanks Leila. Already looking forward to part 2 :-)

@LeilaGharani 6 жыл бұрын

Glad to hear you like it.

@huzaifahshah3841 6 жыл бұрын

First time see video simply awesome madam

@LeilaGharani 6 жыл бұрын

Glad you like it Huzaifah! Thanks for dropping by.

@harishpaldhir5915 6 жыл бұрын

Ok thanks madam i will search them And once again thanks for ur reply

@LeilaGharani 6 жыл бұрын

You're welcome.

@maramhammad1098 6 жыл бұрын

Amazing! Its really helpful .. Thanks 💓

@LeilaGharani 6 жыл бұрын

Glad you find it helpful :)

@onataghoghoatikpe5989 5 жыл бұрын

excellent

@LeilaGharani 5 жыл бұрын

Glad you like it.