Quick And Easy Way To Insert Slicers In Excel

In this video, you’ll see a fast way to easily insert slicers in your Excel worksheet.

Related Videos:

How to Add a Search Box to a Slicer in Excel:

Setup a Slicer to Sort or Filter Another Slicer for Quick Navigation:

#MsExcel #ExcelCampus
00:00 Introduction
00:16 Pivot Table Fields List
01:15 Insert Slicers

[Reegs]

HUGE TIP: Right click on the slicer, go to slicer settings and click the checkbox for "Hide items with no data". Huge. Great job on the video, Very simple and easy!

[Newtome]

You are a gem! Your teaching style flows so well making it fool proof for someone like me. I am getting comfortable with pivot tables thanks to you.

[rammer]

Thank you Jon! I use slicers quite regularly and this tip will sure make the work quicker and efficient. Awesome, awesome, awesome :)

[maggieblyth]

Brilliant video. I'am busy studying for my MOS Exams and pivot tables are my weakest thing.

[redfeathersa]

I learnt something I didn't know !! I always do with your fantasticly presented elegant, efficient & effectual Videos Jon. Thank you !! 🙏

[wayneedmondson]

Hi Jon. Great Slicer tips! Thanks for sharing :)) Thumbs up!!

[GeertDelmulle]

I only have a couple of videos on my Excel-YT-channel, and this trick is one of them: it's a good one. :-)

[benjiwong]

Hello thanks for sharing. can you show how to insert slicer in google sheet? thanks

[ayeshaindunil]

Hi john!.your lessons are very helpful to me.I have question, how to link a source data sheet and the pivot table with a one slicer?

[adaariina]

*Hello Sir, New subscriber here. I want to learn Excel for Data Analyst. Someone refer your channel that he learns from your channel. If this is good I will surely refer to others who want to become data scientists.* _Thank You._

[roadtotech]

How can I get this Excel sheet. I'll like to use it to train.

[mahathavenramasamy]

How to slicer windows 2007 pl. Guide me

[sabduljabbar]

In excel i have 24 columns with dates and values and alternate columns. I want to extract the Maximum value and it's corresponding date in that year. And I want to extract the cell address of the value and the date .Can u please help me out of it.

[brandonbowman]

I have to Google how to insert Pivot Table right out of the gate...starting from Square 1 is the first step...

[sotampacane]

In 34 seconds you make two assumptions but neither worked so I had to give up. Pivot Table Fields are not always visible so you should have told us how to do that. Then if we create the slicer, how to get it where we need to is next. Moving on to hopefully finding a better answer.

[subhadeepsn]

I am not good in excel but this video did not helped me a lot to create pivot table with slicer. As when I click on clicer its not working :(