🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Kevin, I am a consultant to real estate appraisers. This filtering function is just GOLD for them and should save an Everest of time for them! Thank you!
You just solve a very huge problem for me that would save me hours of working. Do you know that I have been gathering data and working on them for 5 days already? With this filtering it would take at most 1-3 hours total. Great video, thank you so much Kevin. I always enjoy your videos. Thank you for your time I do appreciate it.
I just came to this video hoping for an answer to some problems in excel, but I saw your channel, and know I understand everything a lot more. Thank you Kevin. One more suscriptor
OMG, thanks for making this so simple. I've been using the sort feature for years, but never used filter for some reason. This will make things SO much easier. I love how you make it so simple and clear, thank you!
Thank you Kevin. This has been enormously helpful. I am working on a large spreadsheet as we speak and this video has helped me chop away 95% of the data, leaving the bits I need. Exactly what I wanted.
Thanks, Kevin for the video , it helps me with my first statistics class. They go too fast in school thinking everyone knows this already, refresher tutorials always help.
Thanks alot, Kevin! I've got an ICT practical tomorrow, and I knew how to make the table but wasn't quite sure about the filtering part :'( You and your video helped alot!!! Thanks!! :D
Hi Kevin, great video as always. And there will never be enough Excel videos on your channel! I like the way in which you summarize a potentially much wider subject in a 15-to-20 minute video, getting straight to the content without wasting 1/3 of the video with pointless introductions as many You Tubers do. In the way of requests the list is very long: more multi-media videos, maybe a Photoshop one, now and again a “nerdy” video (what are the basic specs when it comes to replacing my old PC/Laptop...) Thank you again
Kevin..can't thank you enough for the work you have done...one of the best tutorial on the subject ..easy and straight forward with practical examples Keep the good work .
Hi Kevin, THANKYOU so much for the guides. it did improve my work! could you share with us how can we extra info from internet so that it is updated live in excel? for example, share prices, exchange rates or like any figures we can get online
Hi Kevin, congratulations on your very informational tutorials in excel and powerpoint. I have a concern in extracting the zonal number only in a irregular patern of complete address text string. I hope you can give me advice. Thanks and God Bless your tutorial endevours 😊
Hi Kevin, I was just wondering why you created a table. The Filter function seem to work better with just data without a table. Of course I have ~40k rows of data. Seems redundant since the Filter function is replacing the table filter.
Thank you Kevin, another very helpful tutorial. I have an excel file, it's very wide, to see the filtered selection to the right side is not a good idea. What's your suggestion and the solution please thank you.
Thanks I would like to filter by color however I use the high contrast view with a black background. It's just easier on my eyes as someone who spends many years on the computer. I can't find a way to color boxes in this view
You are rocking today, Kevin. Quick Question - Will the filter function work the same way if you filter against consolidated worksheets,i.e. pulling together data from various worksheets into one worksheet or an external workbook?
Fantastic. Kevin we love you, we will do click like, write a comments and subscribe every your vodeo becouse you are the best. Thank you and good luck. 😍
Maybe, it's my sub vision talking, but, when you say "click here", "in this part", things like that, I am kind of lost. Again, maybe my sub vision problems are to blame. Anyway, really cool explanation. I learned to do what I wanted. Would it be possible to make the mouse a little bigger and when you click on something you could go like say the names of the tabs? Even if you repeat them. No problem. Love your videos. Thank you.
Great video thanks for making this. I'm new to using Excel. I have a list of 60 names. I need to search and see if all or any of the names appear in other Excel sheets. Can I use the filter feature to do that?
How do you copy data based on a filtered list? Do you need to do anything special or can you just highlight everything you want to copy and paste? I can’t seem to figure out how to paste data into a filtered list either.
Great video. Thank you for sharing. A question: Can Filter command (in 365) handle wild-cat characters, or is there a way to do it, if we do not know exact values? Thanks,
Questions, After using the filter function to copy from another excel table , The Function is fine. but the text color is just disappeared , May I know how can I fix it please? Thanks😘😘
When writing numbers in Arabic, we should write them starting with the year, month, then date to propably read. The problem happens when copying data from a Word document where numbers written in the normal way. How to slove this problem to help us sorting numbers in A to Z order? When I sorted dates, sorting focused on the date not the year.
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Kevin, I am a consultant to real estate appraisers. This filtering function is just GOLD for them and should save an Everest of time for them! Thank you!
You just solve a very huge problem for me that would save me hours of working. Do you know that I have been gathering data and working on them for 5 days already? With this filtering it would take at most 1-3 hours total. Great video, thank you so much Kevin. I always enjoy your videos. Thank you for your time I do appreciate it.
I just came to this video hoping for an answer to some problems in excel, but I saw your channel, and know I understand everything a lot more.
Thank you Kevin.
One more suscriptor
OMG, thanks for making this so simple. I've been using the sort feature for years, but never used filter for some reason. This will make things SO much easier. I love how you make it so simple and clear, thank you!
Thank you Kevin. This has been enormously helpful. I am working on a large spreadsheet as we speak and this video has helped me chop away 95% of the data, leaving the bits I need. Exactly what I wanted.
Thanks, Kevin for the video , it helps me with my first statistics class.
They go too fast in school thinking everyone knows this already, refresher tutorials always help.
I can imagine how much time I have been wasting! Thank you so much for making my work so easy🙏🙏
Great tutorial - starting from the simple and moving towards the more complex, all explained in a clear way with good examples. Thank you!
Very helpful and I appreciate your cheerfulness. This stuff takes some concentration for us in our 60s!
One more excelent tuturial. Thanks.
Again ---> You are the best of the best
Again ---> You are the son of technology
Thank you, just got a promotion and I need to learn this basic stuff!! You are a lifesaver!
Thank you. You have helped me to upgrade my skills with Excel.
Thank you so much for this easy to follow video, exactly what I needed to solve a dead end at work :). Have a great day !
Thanks alot, Kevin! I've got an ICT practical tomorrow, and I knew how to make the table but wasn't quite sure about the filtering part :'( You and your video helped alot!!! Thanks!! :D
I like that: Beginner (that’s me) and advanced (hey! I can do that too!) in the same video. And very clear.
Thanks
I have lab assignment for my data analytics subject. Your video is very helpful 🙏🏼🙏🏼🙏🏼🤍🤍🤍🤍
you are a natural bro - well done kev
Thank you! This really saved me! I didn’t realize you needed to set up a table
Amazing explanation. I like your explanation especially when you come up with some data and explain the concept using that data.
Thanks your a great teacher really helped once I learn how to use excel what is another skill I can learn that will help me with excel
Thank you, I couldn't get it to filter the first way you did it but the second way worked.
thank you so much kevin, this video was very helpful to me and you explains evrything i a very beautiful calm way, thanks again
Hi Kevin, great video as always. And there will never be enough Excel videos on your channel!
I like the way in which you summarize a potentially much wider subject in a 15-to-20 minute video, getting straight to the content without wasting 1/3 of the video with pointless introductions as many You Tubers do.
In the way of requests the list is very long: more multi-media videos, maybe a Photoshop one, now and again a “nerdy” video (what are the basic specs when it comes to replacing my old PC/Laptop...)
Thank you again
You did an awesome job. Was able to follow you step by step. Was not as scary as I thought it would be. Thank you.
Thanks, u have explained in very simple manner!!!
Awesome! Thanks a great deal, Kevin 😊
Thank's Kevin for a great lesson! Greetings,
from Latvia!
Thanks Kevin. It was a very informative video !!!! Take care & Good Luck .
Just what I was looking for. Thanks!!! 😀
Thank you bro-from the Philippines
Kevin..can't thank you enough for the work you have done...one of the best tutorial on the subject ..easy and straight forward with practical examples
Keep the good work .
Very good tutorial. Thank you Kevin
You are great!! Thank you so much for your helpful videos.
Kevin, Awesome explanation. I finally get filtering now.
Thanks, this video has been very helpful and will be very useful.
Thank you, Kevin, very helpful!
Just what I was looking 4!
thanks so much, short and sweet!!!!
This was so easy ! Thank you !! 👏🏻👏🏻
Hi Kevin, Great video! short and sweet and right to the point. Thank you
Hey Kevin, this was very helpful and I wanted to thank you for making this tutorial
Kevin, I learned things here. thanks
I’d love to learn excel from you. I’ve subscribed so I’ll be looking for your notifications thanks!!!’
That was really useful tutorial and helped a lot in saving time. It would be great to have a beginners level tutorial on formulas.Thanks
This is just what I needed -thank you!
Thank you for all your tutorial videos. I hope you can create a new video tutorial for dashboard and model development. Thank you in advance
Kevin, great explanation. Thanks!
Thank you this really helped
So useful! Thank you!
great Kevin.. got to clean up my dB first then I can do testing ❤
We love u yaar....love ur work...love ur representation...
Wow Kevin, you have a $ multi-million dollar cookie company as a side hustle to your side hustle!! Damn bro!
Great video, thanks for sharing!
This was so easy ! Thank you !!
Applying the filter function to my data simplified my tasks. Thank you. Pls produce videos about excel data mining.
Brilliant, thank you!
great video as always.
Thank you! This was very helpful!
I love this stuff. Thanks for an amazing RUclips channel
Very helpful
I'm one of your fan. more videos to come👏
Thanks very helpful and useful
Thank you so much
I love you! Keep doing it man
Thank you. awesome awesome awesome
Hi Kevin, THANKYOU so much for the guides. it did improve my work! could you share with us how can we extra info from internet so that it is updated live in excel? for example, share prices, exchange rates or like any figures we can get online
HI Kevin love your show, can you post something how to use excel DATA Advances
love your show. can you post how to use data advance filter and short thanks
Can you do a video on how to copy from a filtered spreadsheet and pasting onto another filtered spreadsheet?
Hi Kevin, congratulations on your very informational tutorials in excel and powerpoint. I have a concern in extracting the zonal number only in a irregular patern of complete address text string. I hope you can give me advice. Thanks and God Bless your tutorial endevours 😊
Hi Kevin, I was just wondering why you created a table. The Filter function seem to work better with just data without a table. Of course I have ~40k rows of data. Seems redundant since the Filter function is replacing the table filter.
Thank you Kevin, another very helpful tutorial. I have an excel file, it's very wide, to see the filtered selection to the right side is not a good idea. What's your suggestion and the solution please thank you.
Thanks
I would like to filter by color however
I use the high contrast view with a black background. It's just easier on my eyes as someone who spends many years on the computer.
I can't find a way to color boxes in this view
Always great videos.
Thank for sharing! Insightful!
You are rocking today, Kevin. Quick Question - Will the filter function work the same way if you filter against consolidated worksheets,i.e. pulling together data from various worksheets into one worksheet or an external workbook?
Thankyou So much
Fantastic. Kevin we love you, we will do click like, write a comments and subscribe every your vodeo becouse you are the best. Thank you and good luck. 😍
Thank youu!!
unfortunate i dont have microsoft 365 :( but thanks for the filtering part! i was struggling with it at first
Very helpful! Thanks
You are a TERRIFIC Trainer, thanks so much!
Than you so much!!!
very good!
Thank You Kevin!!
Thank you
Thanks a lot
Brill thanks Kevin
Maybe, it's my sub vision talking, but, when you say "click here", "in this part", things like that, I am kind of lost. Again, maybe my sub vision problems are to blame. Anyway, really cool explanation. I learned to do what I wanted. Would it be possible to make the mouse a little bigger and when you click on something you could go like say the names of the tabs? Even if you repeat them. No problem. Love your videos. Thank you.
Great video thanks for making this. I'm new to using Excel. I have a list of 60 names. I need to search and see if all or any of the names appear in other Excel sheets. Can I use the filter feature to do that?
Great 👍
How do you copy data based on a filtered list? Do you need to do anything special or can you just highlight everything you want to copy and paste? I can’t seem to figure out how to paste data into a filtered list either.
Great video. Thank you for sharing. A question: Can Filter command (in 365) handle wild-cat characters, or is there a way to do it, if we do not know exact values? Thanks,
Questions, After using the filter function to copy from another excel table , The Function is fine. but the text color is just disappeared , May I know how can I fix it please? Thanks😘😘
When writing numbers in Arabic, we should write them starting with the year, month, then date to propably read. The problem happens when copying data from a Word document where numbers written in the normal way. How to slove this problem to help us sorting numbers in A to Z order? When I sorted dates, sorting focused on the date not the year.
Going have to watch this again i need help
I am your fan
Super Excelent