Excel Filter Basics (for quick data analysis)

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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.com/filter-basi...
🌟 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.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩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

[@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!

[@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.

[@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.

[@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.

[@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!

[@ltronics62]

Very clear explanations. Thank you for posting!

[@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.

[@domhough8914]

Many thanks, simple useful and comprehensive.

[@paulmartineau3850]

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

[@heligomez8048]

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

[@sasavienne]

Thank you so much Leila.
Very useful and helpful.

[@qunwang5165]

Thanks a lot! The tutorials are amazing!

[@sibesomunyinda9574]

Really helpful. Thank you

[@tedland3016]

great stuff thanks

[@heysimoo]

super clear! thanks!!

[@teodoraguleva7609]

So useful, thank you!

[@swsw5959]

Thank you very much.

[@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!

[@MrTosha43]

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

[@danielhutchinson6158]

Thank you Leila.

[@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.

[@wendymoran1912]

Fab. Thank you 😜

[@MBD2903]

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

[@rakibulmahmud3253]

Thankyou for providing excel workbook for practice

[@djjammindave]

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

[@shanesmohammed]

Awesome Filter details LG

[@hathawayamato]

Thank you Ms. Gharani! This was so helpful

[@DiamondDiamondHeart]

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

[@nitaadams5151]

Thank you 🤗

[@luismoreyra6804]

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

[@nicouekuete8842]

You are a "ROCKSTAR" Leila!!!

[@amiraboodi2075]

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

[@atiaabdelkader1905]

Thank you a lot

[@axeemx]

Really enjoying the explanation. Easy to understand. Thanks!

[@LeilaGharani]

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

[@arshadullah1066]

Thnx for this amazing stuffs. God bless u.

[@user-vh6hr1jm4u]

great work, keep up shinning, helps a lot

[@doraramos4735]

Very helpfull thanks!!

[@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!

[@jheanpalmejan]

you re a savior!!!!

[@ajaycan]

great video

[@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!

[@1000tastebuds]

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

[@LeilaGharani]

Wow, thank you!

[@CarlosAguilar-xw7ot]

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

[@LeilaGharani]

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

[@rtlinsn5085]

Thank you Leila

[@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.

[@PankajKumar-jw7gf]

Good explaination

[@k50159]

Much appreciated!

[@19761999]

Lady, YOU ROCK!

[@monte4955]

Great Video as always Leila👍. Thanks.

[@LeilaGharani]

You're welcome Monte.

[@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.

[@engahmedegy1]

thank you, i love you ❤

[@alexrosen8762]

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

[@LeilaGharani]

Glad to hear you like it.

[@anupamawenzel5000]

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

[@mswordexpert]

very useful vedio like all of yours.

[@user-lu1mh5py5r]

thanks very much it helps a lot your lecture

[@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.

[@johnborg6005]

Thanks Leila. Looking forward for the Advance Filter

[@LeilaGharani]

You’re welcome John.

[@ZAHIDHUSSAIN-ri5kg]

Many, many thanks Leila!

[@LeilaGharani]

You're very welcome Zahid.

[@amrindersingh9568]

Amazing video! Thank you very much.

[@LeilaGharani]

You're very welcome Amrinder :)

[@NadiaDAidan]

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

[@LeilaGharani]

Glad you enjoyed it!

[@valunomics738]

It was simply awesome, Leila.

[@LeilaGharani]

Glad you like it Imran.

[@maramhammad1098]

Amazing! Its really helpful .. Thanks 💓

[@LeilaGharani]

Glad you find it helpful :)

[@Deedington]

Great work Leila!

[@LeilaGharani]

Thanks! I'm glad the tutorial is useful.

[@MalinaC]

Leila, thank you for this filter tutorial! :)

[@LeilaGharani]

You're welcome Malina :)

[@basupallab91]

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

[@LeilaGharani]

You're very welcome Pallab.

[@atefteleb3094]

very impressive

[@amraref9116]

Very best 👌

[@rmohabali]

Excellent video, Leila, you are excellent!

[@LeilaGharani]

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

[@imrankhalidsialkhalid5112]

thank you..

[@flightforge30]

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

[@tahata7436]

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

[@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....

[@husnijuttvlog3442]

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

[@LeilaGharani]

Thank you! 😃

[@husnijuttvlog3442]

@@LeilaGharani keep it up🥰🥰

[@ruchigupta6520]

Very nice.

[@LeilaGharani]

Glad you like it.

[@AronPrince1967]

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

[@LeilaGharani]

Welcome!

[@mostafaelsawy1209]

you are great

[@meghasyam427]

leila thank you so much

[@VishwaJeetDwivedi]

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

[@LeilaGharani]

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

[@azizniazi9159]

Salute to my great teacher Leila Gharani

[@tutsecret499]

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

[@AmitSharma-ft7jb]

I love ur videos even without watching it...

[@ismailismaili0071]

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

[@LeilaGharani]

:) I'm happy to hear that Ismail.

[@roybayona3475]

thanks

[@kabootty]

Excellent presentation

[@LeilaGharani]

Glad you like it! Thanks for your support.

[@tsdhruva2298]

thank you mam, very helpful video

[@LeilaGharani]

You're very welcome.

[@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.

[@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

[@RogerStocker]

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

[@guadalupeaguilera7818]

GOOD JOB greetings Leila from MEXICO

[@tamerhegab1513]

Great

[@lopnagalal9345]

u are awesome

[@onataghoghoatikpe5989]

excellent

[@LeilaGharani]

Glad you like it.

[@mohdirfan7291]

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

[@LeilaGharani]

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

[@hosseinhosseinpoor4845]

thanks thanks thanks

[@abcd24730]

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]

Thank you!

[@jingwu8461]

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

[@mmincredible1451]

Even I learned a lot from her videos love u Lelia

[@urchaitanya]

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

[@LeilaGharani]

Great! Thanks for your support.

[@md.yousuf3684]

Excelent, Leila...

[@abdifitahahmedabdi9258]

Thanks

[@LeilaGharani]

You're welcome :)