How to Filter in Microsoft Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Pedro
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.
reply
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.
reply
Nadia
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
reply
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
reply
Bhanuprasad
-Kevin, I have data in two columns with different count, i want to map column A to column B
Example : Column A has value but column B doesn't, In my result, for that row column A should have value and Column B should have blank value, This should be applied to all rows. How can we do this?
reply
-Kevin, I have data in two columns with different count, i want to map column A to column B
Example : Column A has value but column B doesn't, In my result, for that row column A should have value and Column B should have blank value, This should be applied to all rows. How can we do this?
reply
Yannie
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!
reply
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!
reply
Jeremy
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
reply
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
reply
Earning
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
reply
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
reply
itech
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!
reply
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!
reply
David
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.
reply
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.
reply
Ahmed
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
reply
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
reply
Marcelo
In your exemple tou used a small table and had some 2, 3 or 4 items as results after filter. Thats easy to count. But in case of massive sheet. Does Excel count the filters results?
reply
In your exemple tou used a small table and had some 2, 3 or 4 items as results after filter. Thats easy to count. But in case of massive sheet. Does Excel count the filters results?
reply
Add a review, comment
Other channel videos
