🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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.
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!
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!
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
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.
My filters only "Text Filters" when I select the dropdown from the Year Opened or Profit/Loss. How do I make excel recognize the numbers or dates when filtering?
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.
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
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😘😘
How can you add to the drop-down how many entries you have for each category like for example how many stores do you have in New Jersey? I'm not saying filtering for the stores in New Jersey and seeing it in the spreadsheet but on the drop-down just seeing a number next to New Jersey that says how many entries there are for New Jersey? I think I've seen that but don't know how to do it
Anyone know if it's possible to filter with several keywords in the same situation, without having a ton of columns? So like, let's say you want to be able to filter like in an online store, everything that is both x and y and z? But each item has several things to filter for
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.
Hi sir, I was wondering how do we save the filter edits that me make? Everytime I filter the data, save it and close the document it reverts back to being unfiltered.
Hi, yes, you can now filter a shared Excel sheet and it won't affect how other people view the sheet. In the past, this was not the case, but this has now been resolved. Cheers!
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.
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
thanks for the video. I subscribe to MS 365. Can I use the filter function to search and display using multiple criteria? Can the results be displayed in the same space as the original? what would be the syntax?
Hey Kevin, Thanks for your videos. I am looking for a solution to something. I have a table of data for inventory items. In that table, I have a column that says " Requested by" and another that says " Approved by". There is a list of people for those columns in another sheet. I must fix a drop-down in my item master sheet with values from the other sheet only. To explain a bit, Let's say 5 people Abraham, john, adam, lin, and marc can request the item. So when I click the cells in the "Requested By" column only these 5 names will be shown as a drop-down and nobody will be able to manually add any name to the cells of the column. Same for the "Approved by" also. Can you plz help me to set up the task? Thank You.
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.
HI Kevin, i need your help, i have been asked to edit excel sheet of my students but when i try to re-arrange it accroding to alphabet A-Z, the sort or filter button are off. I tried to click them like how u taught in this video but nothing works as they are off and cant be clicked. Please help me
@KevinStratvert - great video. I'd love to know if there is a way to save views so that I don't have to keep going back to click check boxes. I have some fairly large spreadsheets that I need to be able to view in about 4 different views. I used to be able to use the 'custom view' function but this is greyed out now that I've turned all my data into table. Is there any way to save views of tables (so the table updates rather than having to use the filter function) - I have several conditional formats (to colour cells) set up and these won't come through on filters I don't think (the conditions relate to data that wont be in the filter set). Looking to replicate the 'custom view' function to give me several view I can switch between but using data from a table. Any help greatly appreciated.
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
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.
Can Anyone assist as my knowledge of excel is basic... I have set up 2 tables next to each other on excel but when I filter on the one table it effects the other table even though I created separate tables. Thanks in advance for any help
how do you add a filter name or value to a list already made to filter a column Example: make a spreadsheet template for my team that they will fill out and I want them to choose from a pick list?
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,
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 Kelvin, thank you very much for you sharing, may i know is it possible for us to do filtering across worksheet? what i mean is in the same excel workbook, I have created several worksheet, i have added my raw data on one, but hope to do the filtering on another worksheet. thank you!
Hi Kevin, Thank you so much for everything you do. Only one question how I can show the cell (I1) as a dropdown list and keep the same filter function. in the minute 15:16 Thanks again
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. 😍
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?
🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
why is this video so long
Ikr?
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.
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!
A little to fast for someone who has lived in the "sort" function world
One more excelent tuturial. Thanks.
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!
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
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.
My filters only "Text Filters" when I select the dropdown from the Year Opened or Profit/Loss. How do I make excel recognize the numbers or dates when filtering?
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.
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
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😘😘
I used to search by multiple column equal to OR like
MJ*|NY*|DE|DF
and result all 4 countrys shows up.
but I forgot the format, do you know?
How can you add to the drop-down how many entries you have for each category like for example how many stores do you have in New Jersey? I'm not saying filtering for the stores in New Jersey and seeing it in the spreadsheet but on the drop-down just seeing a number next to New Jersey that says how many entries there are for New Jersey? I think I've seen that but don't know how to do it
Anyone know if it's possible to filter with several keywords in the same situation, without having a ton of columns? So like, let's say you want to be able to filter like in an online store, everything that is both x and y and z? But each item has several things to filter for
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.
Hi sir, I was wondering how do we save the filter edits that me make? Everytime I filter the data, save it and close the document it reverts back to being unfiltered.
Wow Kevin, you have a $ multi-million dollar cookie company as a side hustle to your side hustle!! Damn bro!
I am trying to filter address by zip, but not sure how to go about this. Haven't been able to find a successful video on this.
Could we filter it according to the name?
I have a list of 200 people, but I need the record of only three persons. How can I do it?
HI Kevin love your show, can you post something how to use excel DATA Advances
Hi , kevin How do you sort out multiple times rows are in 10, 20, 30, 40 s are repeatedly entering in a multiple
unfortunate i dont have microsoft 365 :( but thanks for the filtering part! i was struggling with it at first
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
Any idea how can we remove sort a-z and z-a from filters options? Its a mess if i press it by accident 😢
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
Sir, I do monthly mail delivery and some addresses are the same and I hate it deleting everything and starting with the new month. Any ideas
With the date, which I have filtered, I want to make a table. How can I do this? Thanks!
What to use instead of filter function because my version is 2019 😢?
Hello Kevin, I am just wondering where the link for the sample data is? I'd like to follow along
I was wondering that too. I’ve found it in the Description of the video, although I’m having trouble copying the data....
Kevin, can you filter a live/shared excel doc? Will it affect how the others see it?
Hi, yes, you can now filter a shared Excel sheet and it won't affect how other people view the sheet. In the past, this was not the case, but this has now been resolved. Cheers!
wow omg great vid help me ooo much keep up the good work kevin🥵🥵🥵🥵🥵🥵🌶🌶🌭🌭
For the advanced filter, what if I want it to filter NY or NJ (show for both)?
I can't see the losses of my profit with just the open and close parenthesis sir, how?
I can’t get the advanced filtering to work it just is blank when I hit enter
Amazing explanation. I like your explanation especially when you come up with some data and explain the concept using that data.
How do you filter empty cells in excel in order to delete them from the spreadsheet?
love your show. can you post how to use data advance filter and short thanks
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.
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
Awesome! Thanks a great deal, Kevin 😊
thanks for the video. I subscribe to MS 365. Can I use the filter function to search and display using multiple criteria? Can the results be displayed in the same space as the original? what would be the syntax?
I have lab assignment for my data analytics subject. Your video is very helpful 🙏🏼🙏🏼🙏🏼🤍🤍🤍🤍
does it work across sheets? I can't seem to make it work. It returns a bunch of zeroes.
Python?
I want to filter data in one columns as the other order of another column
I’d love to learn excel from you. I’ve subscribed so I’ll be looking for your notifications thanks!!!’
Hey Kevin, Thanks for your videos. I am looking for a solution to something. I have a table of data for inventory items. In that table, I have a column that says " Requested by" and another that says " Approved by". There is a list of people for those columns in another sheet. I must fix a drop-down in my item master sheet with values from the other sheet only. To explain a bit, Let's say 5 people Abraham, john, adam, lin, and marc can request the item. So when I click the cells in the "Requested By" column only these 5 names will be shown as a drop-down and nobody will be able to manually add any name to the cells of the column. Same for the "Approved by" also. Can you plz help me to set up the task? Thank You.
Thanks Awesome feature.
Can we filter data with range values full column 1 ....99 rather than single value.
The way we use to do in power query...
Are you able to have the filter column on a separate sheet?
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.
HI Kevin, i need your help, i have been asked to edit excel sheet of my students but when i try to re-arrange it accroding to alphabet A-Z, the sort or filter button are off. I tried to click them like how u taught in this video but nothing works as they are off and cant be clicked. Please help me
@KevinStratvert - great video. I'd love to know if there is a way to save views so that I don't have to keep going back to click check boxes. I have some fairly large spreadsheets that I need to be able to view in about 4 different views. I used to be able to use the 'custom view' function but this is greyed out now that I've turned all my data into table. Is there any way to save views of tables (so the table updates rather than having to use the filter function) - I have several conditional formats (to colour cells) set up and these won't come through on filters I don't think (the conditions relate to data that wont be in the filter set). Looking to replicate the 'custom view' function to give me several view I can switch between but using data from a table. Any help greatly appreciated.
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
IDK But I can't do the advance filter at all! I have excel 365! Filter isn't a formula that's available.
Great tutorial - starting from the simple and moving towards the more complex, all explained in a clear way with good examples. Thank you!
Great
@Kevin Stratvert - How did you remove the color filters, please? You didn't explain. Thank you.
Hi, when you used FILTER function the value of "Year opened" column has changed in filtered table. Kindly check.
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.
Can Anyone assist as my knowledge of excel is basic... I have set up 2 tables next to each other on excel but when I filter on the one table it effects the other table even though I created separate tables. Thanks in advance for any help
Thanks Kevin. It was a very informative video !!!! Take care & Good Luck .
thank you so much kevin, this video was very helpful to me and you explains evrything i a very beautiful calm way, thanks again
Can you make a video on how to remove background from photos on Microsoft PowerPoint?
Hey Mike - thanks for the suggestion! I'll add it to my list. Cheers!
@@KevinStratvert Thanks
how do you add a filter name or value to a list already made to filter a column Example: make a spreadsheet template for my team that they will fill out and I want them to choose from a pick list?
Thank's Kevin for a great lesson! Greetings,
from Latvia!
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,
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 😊
Going have to watch this again i need help
How are you "undoing" your actions? I noticed your cursor didn't move to the "undo" button.
Ctrl + Z
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 !
Thank you. You have helped me to upgrade my skills with Excel.
Thank you, I couldn't get it to filter the first way you did it but the second way worked.
Thank you. awesome awesome awesome
Thank you this really helped
Hi Kelvin, thank you very much for you sharing, may i know is it possible for us to do filtering across worksheet? what i mean is in the same excel workbook, I have created several worksheet, i have added my raw data on one, but hope to do the filtering on another worksheet. thank you!
Thanks, this video has been very helpful and will be very useful.
Again ---> You are the best of the best
Again ---> You are the son of technology
You are great!! Thank you so much for your helpful videos.
If I want to filter with the formula but to return only some of the colomns and not all of them how do I write the formula?
Can I use filters to drag other information from other tabs of the same worksheet?
You are a TERRIFIC Trainer, thanks so much!
great Kevin.. got to clean up my dB first then I can do testing ❤
very good!
Hi Kevin,
Thank you so much for everything you do.
Only one question how I can show the cell (I1) as a dropdown list and keep the same filter function. in the minute 15:16
Thanks again
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. 😍
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?
I can imagine how much time I have been wasting! Thank you so much for making my work so easy🙏🙏
looking for a session $$$
Thank you! This really saved me! I didn’t realize you needed to set up a table
👍👍👍
Thank you bro-from the Philippines
Adding CPI % on excel?
😁
3:03
Can you do a video on how to copy from a filtered spreadsheet and pasting onto another filtered spreadsheet?
Super Excelent
Thanks, u have explained in very simple manner!!!
Can you use the filter function in a shared file to filter by color?