Using Excel Slicers to Filter Data

[@through887]

I've been looking around for office tutorials and so far your channel is the best, thanks !!!

[@marisolflandez3964]

My first lesson on slicer and yes it’s a great movie - Groundhog Day!

[@jacquelinebautista7002]

This page is the most user friendly account for those who are not really tech savvy. Thank you so much👍👍

[@IsThisAvailable550]

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

[@doc.orange209]

how was it larry (19th May 2023) 355k Views, 6.3k Likes, Dislikes: ??? they removed them!!

[@phemophemo5947]

Best teacher ever

[@jurajhanus9499]

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!

[@PrateekRemoteSales-tp3zx]

Nice video for learning about slicer in excel. Instructor is top notch

[@michellemajju1589]

THE best explanation 👏👏

[@paulvanobberghen]

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.

[@ianabarcari7615]

Thank you! Your videos are very useful!

[@nellylee1952]

it is very useful and clear, Thank you very much for this video

[@chiragpatel7094]

Thankyou Sir for neatly explaining 🙏

[@ground2airnerd]

Great video! One of the easiest!

[@techteachersandstudents]

Glad you think so! Thanks for watching my videos and supporting the channel. I really appreciate it!

[@bertvantol9669]

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 ??

[@dineshpote4284]

Thankyou so much for knowledge, subscribed

[@ayucahya6668]

thank you for teaching us this is very helpful🙏🏻

[@salmanagementservices4445]

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.

[@malaikahifzal1582]

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.

[@rajataswar6338]

very nice and helpful video.

[@Success_Mantra82]

*Nice & easy explain* ✌️👍

[@coffeeonice312]

Crystal clear explanation! Thank you!!

[@brendadowney9717]

You make this easy to learn...thank you

[@Malik-ix2kx]

Great job. Keep it up

[@mohammadsadrzadeh4067]

Is there anyway to use Slicer to filter the data per week? Showing records which is created weekly?

[@UShruPra]

Thank you for this video😊

[@FanatiCx9]

Awesome, super clearly explained, thank you!

[@naujjnaujj]

Great tip, Sharp explanation

[@jaymondnanggusi2456]

its very helpful and well explained

[@nickt2159]

Nice job!

[@myfriend5796]

Nice and clear presentation. Love it. ❤❤

[@asadmahboob1123]

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.

[@keithsmith4080]

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.

[@syed_hussaini]

Thanks for sharing it in a precise way.

[@Evy_111]

Simple and short, Thank you!!!

[@juanmontoya849]

Great video, and useful!

[@normanreyes7607]

What excel version did you use? Thank you.

[@bigbrotherwatchesdannyboy306]

Thank you ❤❤❤

[@witty_net]

Nice one! Thanks!

[@ayrotideysarkar4215]

hi sir actually the practice file link is not working can you please check?

[@ningh2118]

so clear, thank you

[@jklal8374]

easy to understand. nice job!

[@animal579]

2:53 make a table 3:11 table design > slicer

[@BOOXgaming]

Thank you very much!

[@rebm3028]

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

[@m.azaraj]

One of the good lessons...thank u.

[@sahirac7817]

Thank you

[@bojanbudes1]

Very nice thanks

[@sharran9]

How to delete slicer box and if we want a new slicer and delete old one

[@nitinshetty856]

wow nice tool ! thanks for sharing

[@notawix8542]

thank you so much this is really useful 🤩

[@ryan6978]

i like your video, very helpful! thanks

[@bhartigyanmath2.0]

Nice video

[@maxwelloketch4401]

Very useful

[@KhalidAfridi1]

Thank you so much

[@imvisionhoti7198]

I am still unable to insert Slicer despite clearing all extra things you mentioned here. Still inactive. What could be the reason plz

[@rahandfarhang8261]

I really love your videos! Thanks alot for sharing these useful information in an easy way.

[@voodoorael]

Thanks V useful :)

[@surajuaremu7199]

It is interesting and thanks for the information

[@mohammedal-ahmadi8045]

Very useful. Thumbs up

[@besslau3570]

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 😩

[@jamesjai100]

Excellent

[@ayashasweetshugah]

Thanks, this is helpful

[@jakariajony2253]

Hello, Are you using office-2010 for this slicer

[@jemscharania3376]

IM UPDATING THE DATA STILL NEW DATED NOT SHOWING WHAT IS THE REASON

[@dhivyabharathi3106]

But this slicer option not working in my Excel sheet

[@brshankar2010]

Thank you, very clearly explained. Is there a way to convert the slicer data to Pie chart? Thanks

[@annalizajimenez2632]

very useful 👌

[@kingdomthings9887]

You zoomed in too far and we can't see some of the screen, or what you are clicking on, on the left side 🤷‍♀️.

[@typicalgamer5560]

No he didnt

[@limitless003]

THANKS

[@rameshabn843]

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

[@ninas.2724]

I’m having the same issue. Did you figured out? The only way I get slicer is through pivot table

[@MakesSens]

Slicers start at the damn halfway point 3:32

[@glisten_skin]

I don't have the "design" option. Can anyone explain why?

[@typicalgamer5560]

Right click on a ribbon, edit, and make sure the "Design" tab is checked

[@sirajhaq7886]

Nice video dear friend By this slicer mean multiple filter step wise M i right?

[@sarfarazahmed8241]

Excellent!

[@abhishekdeshpande6659]

I have to press enter to filter it again

[@emadabuhagag222]

helpful

[@alfredcheng5739]

It seems like Slicer is even more useful than filter, I thought Filter is the only way to sort data from different categories.

[@ts4608]

And I didn't know you could use slicers on regular tables thought they were only available on pivot tables!

[@7s9n]

💛💛💛💛💛

[@AliFrostinho]

Date slicers are the sexiest thing alive

[@shaffieqabdullah6887]

Thanks for sharing 😠

[@dusbus2384]

Seems like a more user friendly way of filtering by using buttons as filters. Still pivot tables are superior

[@orelshema]

Cool!

[@ceufrscio707]

1:14 2:45 3:25

[@marksummers463]

The B-E-S-T!!!!

[@swiftvin]

why zoomed in?

[@jamadahirmohamad8968]

Part 2 for charts

[@Shyamkumar_Rathod]

too much informative

[@rushrush6754]

it starts at 3:30 ....

[@LuisFelipeDelgado-c6r]

Gr

[@LuisFelipeDelgado-c6r]

GggREgREAT tEACHER. tHANKS

[@ajaypanwar7587]

Hindi m koni bolig k ghone

[@Espinoza1938]

you dont know even how to manage the page size on the video.

[@mrCetus]

Crystal clear explanation! Thank you!!

[@Malik-ix2kx]

Great job. Keep it up

[@Malik-ix2kx]

Great job. Keep it up