Using Excel Slicers to Filter Data

My entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to use Excel slicers to filter out data that you temporarily don't want to see in your Excel spreadsheets. This is a lesser-known, but very useful, feature that you'll find yourself using more and more. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the link to a practice file to go with this tutorial: bit.ly/excelslicers

[@through887]

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

[@jacquelinebautista7002]

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

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

[@ianabarcari7615]

Thank you! Your videos are very useful!

[@FanatiCx9]

Awesome, super clearly explained, thank you!

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

[@jessenguyen4577]

Crystal clear explanation!
Thank you!!

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

[@evelynmuir236]

Simple and short, Thank you!!!

[@syed_hussaini]

Thanks for sharing it in a precise way.

[@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!!

[@brendadowney9717]

You make this easy to learn...thank you

[@myfriend5796]

Nice and clear presentation. Love it. ❤❤

[@m.azaraj]

One of the good lessons...thank u.

[@chiragpatel7094]

Thankyou Sir for neatly explaining 🙏

[@witty_net]

Nice one! Thanks!

[@ayucahya6668]

thank you for teaching us this is very helpful🙏🏻

[@jklal8374]

easy to understand. nice job!

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

[@rajataswar6338]

very nice and helpful video.

[@notawix8542]

thank you so much this is really useful 🤩

[@Excel_Mantra]

*Nice & easy explain* ✌️👍

[@dineshpote4284]

Thankyou so much for knowledge, subscribed

[@juanmontoya849]

Great video, and useful!

[@naujjnaujj]

Great tip, Sharp explanation

[@ryan6978]

i like your video, very helpful! thanks

[@brshankar2010]

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

[@marisolflandez3964]

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

[@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!

[@ningh2118]

so clear, thank you

[@BOOXgaming]

Thank you very much!

[@sahirac7817]

Thank you

[@nickt2159]

Nice job!

[@phemophemo5947]

Best teacher ever

[@rahandfarhang8261]

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

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

[@nellylee1952]

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

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

[@jaymondnanggusi2456]

its very helpful and well explained

[@ayashasweetshugah]

Thanks, this is helpful

[@Malik-ix2kx]

Great job.
Keep it up

[@KhalidAfridi1]

Thank you so much

[@mohammedal-ahmadi8045]

Very useful. Thumbs up

[@nitinshetty856]

wow nice tool ! thanks for sharing

[@bojanbudes1]

Very nice thanks

[@sarfarazahmed8241]

Excellent!

[@surajuaremu7199]

It is interesting and thanks for the information

[@jakariajony2253]

Hello, Are you using office-2010 for this slicer

[@UShruPra]

Thank you for this video😊

[@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!

[@jamesjai100]

Excellent

[@maxwelloketch4401]

Very useful

[@voodoorael]

Thanks
V useful :)

[@bigbrotherwatchesdannyboy306]

Thank you ❤❤❤

[@annalizajimenez2632]

very useful 👌

[@bhartigyanmath2.0]

Nice video

[@mohammadsadrzadeh4067]

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

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

[@sirajhaq7886]

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

[@normanreyes7607]

What excel version did you use? Thank you.

[@orelshema911]

Cool!

[@emadabuhagag222]

helpful

[@animal579]

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

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

[@sharran9]

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

[@ayrotideysarkar4215]

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

[@marksummers463]

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

[@AliFrostinho]

Date slicers are the sexiest thing alive

[@Shyamkumar_Rathod]

too much informative

[@dhivyabharathi3106]

But this slicer option not working in my Excel sheet

[@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

[@imvisionhoti7198]

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

[@glisten_skin]

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

[@7s9n]

💛💛💛💛💛

[@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 😩

[@jemscharania3376]

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

[@jamadahirmohamad8968]

Part 2 for charts

[@shaffieqabdullah6887]

Thanks for sharing 😠

[@abhishekdeshpande6659]

I have to press enter to filter it again

[@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!

[@dusbus2384]

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

[@ceufrscio707]

1:14 2:45 3:25

[@swiftvin]

why zoomed in?

[@rushrush6754]

it starts at 3:30 ....

[@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