Excel Filter Basics (for quick data analysis)

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

Great

thank you..

😘😘😘😘😘😘 GREAT

Thank you very much.

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.

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

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

Fab. Thank you 😜

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

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

thanks a lot beautiful lady❣❣💕

Thanks a lot! The tutorials are amazing!

Thank you Leila.

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

Thank you 🤗

Speedy presentation for beginners...besides robotic narration with zero teaching aptitude...

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.

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!

Very best 👌

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!

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

I love ur videos even without watching it...

Thnx for this amazing stuffs. God bless u.

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

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.

you re a savior!!!!

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

GOOD JOB greetings Leila from MEXICO

Thankyou for providing excel workbook for practice

How to do that drop down in site product date.

Thank you a lot

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

thanks

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

Excelent, Leila... <3

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

These tutorials are excellent. I recommend viewers to subscribe and also to register for Xcel Plus Tutorials. I considered myself reasonably proficient at Excel spreadsheet creation and design BUT the tutorials have shown me so much more. For example, I am an investor in Stocks and funds and my increased knowledge of the use of Excel has helped me to build spreadsheets, with minimal input from me (see Pivot Tables), that readily show me "the wood for the trees". Efficiently processed Data equals Information equals better-informed decisions. Don't hesitate, the tutorials are enjoyable, an investment and they do deliver.....

You are a "ROCKSTAR" Leila!!!

great stuff thanks

Much appreciated!

thanks thanks thanks

i am naeemirfan from multan pakistan..In MS Office 2016. I haven't seen the formula yet, maybe it's in 2109. plz In MS Office 2016. I haven't seen the formula yet, maybe it's in 2109 .specially 2010

you are great

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

super clear! thanks!!

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.