Using Excel Slicers to Filter Data 

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

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!

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.

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.

Thank you so much

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 🤷‍♀️.

Great video, and useful!

Thanks V 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.

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

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