How to use Excel Slicers like a PRO: Basics + 5 Advanced Tricks

Excel Slicers can make your pivot tables, charts & dashboards DYNAMIC. They are one of my absolute favourite features. In this succinct yet practical video, learn all about how to set up & use slicers, like a PRO.
Video topics ⏱👇
==============
0:00 - Introduction
0:29 - When to use SLICERS?
1:15 - How to insert a slicer?
2:03 - Advanced Slicer tips
2:39 - Customizing the Slicer look
3:55 - More than one slicer on a pivot
4:26 - Amazing Dynamic chart with two slicers
Example workbook 📗👉
====================
💥 A Detailed article + Tips on slicers - chandoo.org/wp/introduction-t...
📁 Sample workbook - chandoo.org/wp/wp-content/upl...
Learn more about SLICERS & Pivot Tables 🍕💥
======================================
1️⃣ Excel Slicers - Complete Guide (article) 👉chandoo.org/wp/introduction-t...
2️⃣ Connect one slicer to two or more pivots - • Easily link Slicers to...
3️⃣ All about Excel pivots (8 examples in 10 minutes) - • How to use Pivot Table...
4️⃣ Advanced Excel Pivot Table Tricks (playlist) - • Easily link Slicers to...
🐣🐥🐤 Other Excel Basics videos (playlist) - • How to create & use Dr...
😍 Love what I do? Join the classes for more 😀
========================================
If you enjoy my videos, you are going LOVE my online classes for Excel / Power BI. Visit chandoo.org/wp/training-progr... and pick something that you want to learn.
Have a beautiful day 😀🌞🌼
#ExcelTricks #Slicers

[@shauncamilleri4451]

"do you want more slices of this awesomeness?" you had me rolling in laughter!!!

[@chandoo_]

A slicer and pivot go to the bar and have drinks. The bartender asks, "one bill?" Slicer replies, "no, I will split" 🤣

[@DemetriPanici]

Sliders are definitely underutilized! Great tips!

[@chandoo_]

They are one of my FAVs 😍

[@arielanderson08]

Great Video. I was looking for a cleaner way to display this data that users from multiple backgrounds could easily learn. This was it! Thank you!

[@Carrnage101]

Brilliant and so helpful! Cheers.

[@MaayJ100]

What a lifesaver you are! Thanks a ton! 🙏

[@FaysalEasyExcel]

Thanks for sharing the Slicer Settings tips. I will apply it.

[@ourworld86]

Slicers explained in most simple way. Thanks.

[@mrtheasley]

Super helpful instructions, thank you!

[@Seftehandle]

I genuinely LOVE this!!!!

[@vijayarjunwadkar]

Great video Chandoo! Thanks for these tips on Slicers! 😊👍

[@chandoo_]

Thanks Vijay... Be sure to share the knowledge with others at your work / business :)

[@irfanabbassi9202]

You are the man for this job... Legend will remember , Chandoo forever

[@chandoo_]

Thanks Irfan :)

[@ronaldjoanefe]

This is really awesome! This will help me a lot with my reports... Thanks for this sir!

[@kamalmaurya123]

Simple and clear 👍... You got a subscriber... Thanks brother

[@am_9944]

thank you straight to the point awesome video

[@wayneedmondson1065]

Great Chandoo! Always fun to get creative with Pivot Tables and Slicers :)) Thumbs up!!

[@chandoo_]

Slicers are one of my all time favourite feature of Excel. 😍

[@signofshinejobs6391]

Mr.Chandoo is always doing Great videos

[@TheTranspoter3]

Hey, Please need more videos on slicer to use with project management data such hai mitigation plan , Milestones and more in depth summary. Kindly make a video using slicer where more line paragraph is being used and need to slice those paragraph using filter and minimal approach.

[@brulimoliv]

Marvelous!!! Thanks for Tricks. Greetings from Brazil.

[@chandoo_]

You are welcome!

[@sairamadaboina8257]

Thank you sir, your explanation was very good, please upload more and more trending skills videos.

[@deebaxley7800]

You make it look easy. Oh, wait... it is easy once you explain the technique. Thank you

[@chandoo_]

You’re welcome 😊

[@gapobanana1]

awesome sensei.

[@michipasuchi]

Thank you for your amazing video!!!!

[@chandoo_]

You are so welcome!

[@NicO-cm2xo]

Thanks Chandoo this is life saver…🙏

[@chandoo_]

You are welcome Nic.

[@girijavarma5271]

this was super fun and useful to watch 😀

[@chandoo_]

Bingo...

[@nandithan152]

Thank you soooo much Bro

[@pcabove7522]

Thank youuu!!!

[@asmaanees]

Amazing thnk u so much 😊

[@tahirwaseem8684]

like your exploration

[@saanvilifestyle6323]

This video is so much useful. Chandoo, I have asked to calculate the Quality of hire (QoH) of any firm, but it's difficult to get a Performance score or any such confidential info. to calculate QoH. Can you please suggest another method to calculate QoH?.

[@shabchique7149]

Thanks for the great video and love all your Excel jokes 🥰😁

[@lavelclaytorsProjectswPurpose]

Wow, thank you for sharing. And the last part of your video how did you get the total to show up in the upper left corner?

[@amaljose4361]

Hi Chandoo, thanks for your wonderful videos, a huge fan. I have an issue regarding slicers. When I use two slicers (departing State and arriving State) for Indian aviation routes data, how can I get just one slicer for a single State (irrespective of departing or arriving) to represent all routes that are connected to that specific State. As I understand using two slicers will enable intersection of data (rather than union of data). It would be a great help if you could solve this for me.

[@SaveWaterEveryday]

Thanks sir.

[@amanmalalo8653]

Very useful tips.

[@chandoo_]

So nice of you

[@vasimshaikh6163]

Guruji Thank you.

[@Salauddinshaik]

Chandoo garu, meeru awesome 👌 Sir, following your tips since many years, keep up the good work

[@chandoo_]

Thanks Salauddin. Meeru kooda awesome for learning and taking time to write back.

[@shivsharma9153]

i am love the content!

[@chandoo_]

Thank you thank you :)

[@sridharv8432]

Just 5 min , a lot of value addition

[@chandoo_]

😎

[@taizoondean689]

Thank You Sir

[@chandoo_]

Most welcome

[@moisesgoncalves3019]

Awesome video!Whenever I save my dashboard my slicers disappear, how to resolve the issue?

[@Jobin.Thomas]

Nice presentation sir... Started watching ur all videos.. 👍

[@chandoo_]

Wow. Thank you and welcome the channel Jobin.

[@khanmbabar]

Thanks

[@harrisali9034]

Hi Chandoo. Love your channel. But it would be great if you can attach the spreadsheet so your viewers can practice on the trick.

[@chandoo_]

Thank you. The file is in video description.

[@amitdhiman7307]

Great 👍

[@chandoo_]

Thank you! Cheers!

[@umbringmich1820]

thanks cooooool

[@shoaibrehman9988]

Sir you are Excel Champ! teaching us lot. I am stuck in situations how can we consolidate multiple pivot table into one. Same data source. Like Jan data, feb data, march data etc with running total in 3 separate pivot table. Now i hv to consolidate as one. Reason true running total of each month will be different.

[@chandoo_]

Thanks Shoaib. You can use Power Query to consolidate the tabs to one table and then make a pivot from it. See my detailed Power Query tutorial here 👉kzbin.info/www/bejne/hpqpcpSVn8-Ue6s

[@ajit9411479473]

Kindly suggest a way I can add search in power bi numeric slicer.

[@pankajSDG]

Thank you nam myoho renge kyo ❤

[@gameanand]

Born to Excel 👍👍😎😎

[@chandoo_]

We all are...

[@jaganathannj5337]

Hi chandoo, I have use pivot tabel my garment office work. Would it be possible to filter the filed based on cell color. I hope you for your response.

[@chandoo_]

Not directly. If you code the cell color as a column then you can use slicer / report filter.

[@mohammadsadrzadeh4067]

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

[@VictoriaAHamilton]

How do you add multiple slicers or a filter and slicer in one sheet?

[@sozenkemal]

how about the data sheet and slicer sheet connection , thanks in advance

[@srinivasavanigadda6941]

Sir please do a video how we can use the slicers in Power Point !

[@donjohn6517]

I want to know how to make a button that when clicked, it’s going to insert a specific text into a selected cell. It is for products on a diagram, I can’t use data validation. Help please.

[@tapanojha8085]

can we add tool tips to the slicers heading???

[@surajbhardwaj428]

Nice Video...👌 But can we delete any option from Slicer..., Because if in one slicers more than 25-30 countries, so I want selected countries ...How can we do this...??

[@callramesh]

Can I just copy the slicers and the chart into PowerPoint and show that as a slide with interactive experience?

[@teoxengineer]

Chando thanks, Can we convert the slicer section names into shapes?

[@chandoo_]

Thanks Emre... Not easy, but there are some tricks you can do. I have another video coming up 2 weeks time on this. Stay tuned.

[@SirChiefUK]

Is there a way to remove the colour background on the slicer? I’ve tried several times modifying it but it looks like it’s stuck on a white background? Thanks

[@chandoo_]

You can't do it. But you can make the color same as whatever background you have.

[@tlee7028]

How to update Slicer say if Australia and Canada are not in data anymore?

[@skyzane2735]

Can we also use Slicers for “tags”? Say there is Movie with title and genre column The genre column will be comma-seprated values. But in slicer we only want it to display as separated values too without the comma. How do we do this?

[@chandoo_]

You can't. Split the values so you have a two column table, movie & tag and then use slicers. You can automate the split with Power Query or the new TEXTSPLIT() functions in Excel.

[@krishnanseshamanikrishnan1950]

Could you please upload Multiple drop down lists in excel . Ex , when u select county then u should get list of states and when u select state then third drop down list should give list of areas with in a state

[@chandoo_]

Sure. I have a video on this topic already. Please watch it here - kzbin.info/www/bejne/h4HGdGONi8-miqs

[@barttitulaerexcelbart9400]

Nice video ! short and to the point. You can't explain everything in 5 minutes, but if you use more slicers at the same time you should be careful. It takes a lot of memory. If you have small datasets its irrelevant....

[@chandoo_]

Good point Bart. I haven't had any issues with "too many slicers" on my dashboards. That said, I am some what conservative with them.

[@barttitulaerexcelbart9400]

@@chandoo_ Sorry Chandoo, it is not the number of slicers it is the way they work together. I can't remember where I have read this in the past, but on the internet I found this phrase: Disabling the cross-filter behavior of a slicer essentially prevents that slicer from changing selections when other slicers are clicked. This prevents the need for Power Pivot to evaluate the titles in the disabled slicer, thus reducing processing cycles. To disable the cross-filter behavior of a slicer, select Slicer Settings to open the Slicer Settings dialog box. Then simply deselect the Visually Indicate Items with No Data option. Btw: you can easaly harvest a value from a slicer with a pivot table (page field). But recently I found out how to harvast a value in an Excel table. curious?? 😉

[@chandoo_]

Woo.. that looks interesting. If I can guess, are you using the new UNIQUE() on the sliced column?

[@Spud_E_Buddy]

😳🤯😍👍🏼👏🏼♥️🙏

[@arthurAzx]

very well but you didnt show how to change to different font or size

[@AbhinavKumar-mm1ys]

At 0:52 there is a checkbox above ok, u can use it for multiple select. Just informing nothing much.

[@chandoo_]

Awesome tip. 🍩 Donut for you Abhinav...

[@pslovelife6]

Good video, but too much of background music to distract the person viewing it.

[@jmrth]

Hi sir, I am from India

[@chandoo_]

Hey Jagan...

[@jmrth]

@@chandoo_ Your vedios , explanations was awesome sir. Great work.

[@finnpj]

Thank you - could you please turn down the music :-)

[@selvakumarm4382]

While scrolling the table, slicer moves upwards. How to make the slicer locked .

[@chandoo_]

You can freeze the rows to do this.

[@bagavathram6726]

I'm planning to restart my career from automotive design to data analyst ... I know the path but with out experience it's being tough How I can proceed

[@chandoo_]

Instead of thinking about it as "restart", think of it as "pivot". Try to find data / Excel / automation opportunities in the automotive industry. That should be a lot easier. All the best.

[@ipadize]

that one name "Gunar Cockshoot" lmao

[@justwatch564]

Hi sir

[@chandoo_]

What's up?

[@sujithortan5773]

Do you know Karnataka??

[@chandoo_]

Yes, I do. It is on the West coast of India 😂 But if you mean to say, do you know Kannada, unfortunately not enough.

[@yoongiwifeinthenextlife]

Hmm, if a boss doesn’t know how to filter a pivot table, should that person be your boss? “Slicers…for bosses who can’t filter good.”

[@chandoo_]

That depends... What if they are a chef / mechanical engineer / construction boss / banker / or anything else? We can't expect everyone to know how to use Excel.

[@biswajitjena1112]

EXCEL , Part Time Online job or website address Excel or data analyst job

[@mrswagz100]

Microsoft has ripped us off on Power BI.

[@chandoo_]

hmm.. Power BI offers even more interactivity and shareability. Here is a video comparing Power BI with Excel. kzbin.info/www/bejne/hXy2eomcgqtjh6s

[@frenan82]

Thanks

[@chandoo_]

You are welcome :)