Using Excel Slicers to Filter Data

Рет қаралды 467,978

Technology for Teachers and Students

Күн бұрын

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

Пікірлер: 95

@jacquelinebautista7002 3 жыл бұрын

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

@through887 2 жыл бұрын

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

@ianabarcari7615 4 жыл бұрын

Thank you! Your videos are very useful!

@FanatiCx9 2 жыл бұрын

Awesome, super clearly explained, thank you!

@jessenguyen4577 2 жыл бұрын

Crystal clear explanation! Thank you!!

@IsThisAvailable550 4 жыл бұрын

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

@evelynmuir236 3 жыл бұрын

Simple and short, Thank you!!!

@malaikahifzal1582 3 жыл бұрын

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.

@syed_hussaini 3 жыл бұрын

Thanks for sharing it in a precise way.

@myfriend5796 3 жыл бұрын

Nice and clear presentation. Love it. ❤❤

@m.azaraj 4 жыл бұрын

One of the good lessons...thank u.

@asadmahboob1123 3 жыл бұрын

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.

@witty_net 4 жыл бұрын

Nice one! Thanks!

@brendadowney9717 3 жыл бұрын

You make this easy to learn...thank you

@rajataswar6338 4 жыл бұрын

very nice and helpful video.

@paulvanobberghen 4 жыл бұрын

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.

@keithsmith4080 4 жыл бұрын

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.

@Excel_Mantra 4 жыл бұрын

*Nice & easy explain* ✌️👍

@marisolflandez3964 6 ай бұрын

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

@chiragpatel7094 Жыл бұрын

Thankyou Sir for neatly explaining 🙏

@sahirac7817 4 жыл бұрын

Thank you

@phemophemo5947 Жыл бұрын

Best teacher ever

@jurajhanus9499 4 жыл бұрын

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!

@jklal8374 3 жыл бұрын

easy to understand. nice job!

@sarfarazahmed8241 4 жыл бұрын

Excellent!

@notawix8542 3 жыл бұрын

thank you so much this is really useful 🤩

@ningh2118 2 жыл бұрын

so clear, thank you

@ayashasweetshugah 3 жыл бұрын

Thanks, this is helpful

@ayucahya6668 2 жыл бұрын

thank you for teaching us this is very helpful🙏🏻

@naujjnaujj 3 жыл бұрын

Great tip, Sharp explanation

@juanmontoya849 2 жыл бұрын

Great video, and useful!

@ryan6978 3 жыл бұрын

i like your video, very helpful! thanks

@dineshpote4284 Жыл бұрын

Thankyou so much for knowledge, subscribed

@mohammedal-ahmadi8045 4 жыл бұрын

Very useful. Thumbs up

@nickt2159 27 күн бұрын

Nice job!

@ground2airnerd 7 ай бұрын

Great video! One of the easiest!

@techteachersandstudents 7 ай бұрын

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

@nellylee1952 8 ай бұрын

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

@rahandfarhang8261 4 жыл бұрын

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

@brshankar2010 2 жыл бұрын

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

@nitinshetty856 3 жыл бұрын

wow nice tool ! thanks for sharing

@surajuaremu7199 3 жыл бұрын

It is interesting and thanks for the information

@jaymondnanggusi2456 Жыл бұрын

its very helpful and well explained

@BOOXgaming Жыл бұрын

Thank you very much!

@UShruPra Жыл бұрын

Thank you for this video😊

@bhartigyanmath2.0 4 жыл бұрын

Nice video

@annalizajimenez2632 4 жыл бұрын

very useful 👌

@KhalidAfridi1 3 ай бұрын

Thank you so much

@bigbrotherwatchesdannyboy306 2 жыл бұрын

Thank you ❤❤❤

@Malik-ix2kx 2 жыл бұрын

Great job. Keep it up

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

@bojanbudes1 2 жыл бұрын

Very nice thanks

@orelshema 4 жыл бұрын

Cool!

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

@jakariajony2253 4 жыл бұрын

Hello, Are you using office-2010 for this slicer

@maxwelloketch4401 2 жыл бұрын

Very useful

@jamesjai100 Жыл бұрын

Excellent

@sirajhaq7886 4 жыл бұрын

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

@voodoorael Жыл бұрын

Thanks V useful :)

@kingdomthings9887 4 жыл бұрын

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

@mohammadsadrzadeh4067 Жыл бұрын

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

@rebm3028 3 жыл бұрын

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

@normanreyes7607 Жыл бұрын

What excel version did you use? Thank you.

@7s9n 4 жыл бұрын

💛💛💛💛💛

@emadabuhagag222 2 жыл бұрын

helpful

@alfredcheng5739 4 жыл бұрын

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!

@animal579 11 ай бұрын

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

@marksummers463 4 жыл бұрын

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

@Shyamkumar_Rathod 4 жыл бұрын

too much informative

@ayrotideysarkar4215 Жыл бұрын

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

@imvisionhoti7198 2 жыл бұрын

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

@sharran9 Жыл бұрын

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

@jamadahirmohamad8968 2 жыл бұрын

Part 2 for charts

@dusbus2384 2 жыл бұрын

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

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

@glisten_skin 2 ай бұрын

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

@dhivyabharathi3106 6 ай бұрын

But this slicer option not working in my Excel sheet

@abhishekdeshpande6659 Жыл бұрын

I have to press enter to filter it again

@jemscharania3376 10 ай бұрын

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

@rameshabn843 3 жыл бұрын

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 2 жыл бұрын

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