I'm in 'lockdown' & came across this I don't know if I will ever use this, however, it looks to be a useful feature and you presented it very well indeed. Thank you. 👍 (9th April 2020) 16,749 views, 816 likes, 5 dislikes
Hello, I think, you may forget to zoom out during your demo, please check it from 02m 45s, you call functions which are not seen in your screen. Anyway, I am a big fan of your tutorials. Excellent job!
I see you cannot add anymore data to the Table at this point, but i love learning this user friendly trick. I could implement this, then lock the sheet for protection, before sending out. Thank you.
Hi, Thank you for the video. It's very informative, Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked? If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.
GREAT !!! Thanks. Now I have a question: I have a year calendar and have a second sheet with different appointments. I want to make a selection to show selected appointments in the year calendar. Is this possible to selct from that year calendar ??
hello, thanks for the this, great video.. would you know how to do a slicer to show data that covers a particular date range? say i just want to see the data (from my table) for the month of january 2023 only.
Hello, With the slicers of a pivot table, I can't keep the format (example wraps) As soon as I click on another segment, there is no more wrapping and the box is unchecked ...
I tried to do but without pivot am not getting insert slicer, once converting into pivot then only I can get slicer can you help me without pivot how do I can get slicer
I've been looking around for office tutorials and so far your channel is the best, thanks !!!
I'm in 'lockdown' & came across this
I don't know if I will ever use this, however, it looks to be a useful feature and you presented it very well indeed.
Thank you. 👍 (9th April 2020) 16,749 views, 816 likes, 5 dislikes
how was it larry (19th May 2023) 355k Views, 6.3k Likes, Dislikes: ??? they removed them!!
Hello, CTRL+CLICK on the 2d, 3d, etc..., label in the slicer is doing the job. SHIFT+CLICK will select a range of labels in the slicer.
Hello, I think, you may forget to zoom out during your demo, please check it from 02m 45s, you call functions which are not seen in your screen. Anyway, I am a big fan of your tutorials. Excellent job!
Thank you! Your videos are very useful!
Crystal clear explanation!
Thank you!!
This page is the most user friendly account for those who are not really tech savvy. Thank you so much👍👍
Nice video for learning about slicer in excel. Instructor is top notch
very nice and helpful video.
My first lesson on slicer and yes it’s a great movie - Groundhog Day!
*Nice & easy explain* ✌️👍
Thank you
Thankyou Sir for neatly explaining 🙏
Best teacher ever
it is very useful and clear, Thank you very much for this video
Nice job!
Great video! One of the easiest!
Glad you think so! Thanks for watching my videos and supporting the channel. I really appreciate it!
I see you cannot add anymore data to the Table at this point, but i love learning this user friendly trick. I could implement this, then lock the sheet for protection, before sending out. Thank you.
Nice one! Thanks!
Great job.
Keep it up
thank you for teaching us this is very helpful🙏🏻
You make this easy to learn...thank you
Hi,
Thank you for the video. It's very informative,
Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked?
If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.
Thank you so much
Hi there, thanks for showing this as this helped me with my ict course work and I had no idea how to do it but with your video, I know now.
Awesome, super clearly explained, thank you!
Thankyou so much for knowledge, subscribed
its very helpful and well explained
Great tip, Sharp explanation
Nice video
Simple and short, Thank you!!!
Thanks for sharing it in a precise way.
so clear, thank you
Thank you for this video😊
GREAT !!! Thanks.
Now I have a question:
I have a year calendar and have a second sheet with different appointments.
I want to make a selection to show selected appointments in the year calendar.
Is this possible to selct from that year calendar ??
Thank you very much!
2:53 make a table
3:11 table design > slicer
hello, thanks for the this, great video.. would you know how to do a slicer to show data that covers a particular date range? say i just want to see the data (from my table) for the month of january 2023 only.
easy to understand. nice job!
One of the good lessons...thank u.
Excellent
Nice and clear presentation. Love it. ❤❤
You zoomed in too far and we can't see some of the screen, or what you are clicking on, on the left side 🤷♀️.
Thanks
V useful :)
Great video, and useful!
Very nice thanks
wow nice tool ! thanks for sharing
Very useful
How to delete slicer box and if we want a new slicer and delete old one
Thank you ❤❤❤
It is interesting and thanks for the information
i like your video, very helpful! thanks
thank you so much this is really useful 🤩
Thanks, this is helpful
Very useful. Thumbs up
Is there anyway to use Slicer to filter the data per week? Showing records which is created weekly?
I really love your videos! Thanks alot for sharing these useful information in an easy way.
But this slicer option not working in my Excel sheet
Thank you, very clearly explained. Is there a way to convert the slicer data to Pie chart? Thanks
I don't have the "design" option. Can anyone explain why?
helpful
Excellent!
very useful 👌
Hello, With the slicers of a pivot table, I can't keep the format (example wraps)
As soon as I click on another segment, there is no more wrapping and the box is unchecked ...
I have to press enter to filter it again
I don’t know why I can’t click on the slicer it’s blank,I have made a table already can you tell me why… thanks 😩
Date slicers are the sexiest thing alive
IM UPDATING THE DATA STILL NEW DATED NOT SHOWING WHAT IS THE REASON
What excel version did you use? Thank you.
Part 2 for charts
Slicers start at the damn halfway point 3:32
Nice video dear friend
By this slicer mean multiple filter step wise
M i right?
Hello, Are you using office-2010 for this slicer
I am still unable to insert Slicer despite clearing all extra things you mentioned here. Still inactive. What could be the reason plz
hi sir actually the practice file link is not working can you please check?
too much informative
It seems like Slicer is even more useful than filter, I thought Filter is the only way to sort data from different categories.
And I didn't know you could use slicers on regular tables thought they were only available on pivot tables!
Seems like a more user friendly way of filtering by using buttons as filters. Still pivot tables are superior
Cool!
💛💛💛💛💛
Thanks for sharing 😠
The B-E-S-T!!!!
I tried to do but without pivot am not getting insert slicer, once converting into pivot then only I can get slicer can you help me without pivot how do I can get slicer
I’m having the same issue. Did you figured out? The only way I get slicer is through pivot table
why zoomed in?
1:14 2:45 3:25
it starts at 3:30 ....
Hindi m koni bolig k ghone
you dont know even how to manage the page size on the video.
Crystal clear explanation!
Thank you!!
Great job.
Keep it up
Great job.
Keep it up