Excel Slicers - The Cool Way to Filter Data!

This is a look at Excel Slicers, including tips, and how you can use them with Pivot Tables.

Contents 0:00
Load Sample Data 0:12
Slicer Tips 3:13
Pivot Table Slicer 7:02
Conclusion 9:34

#seletraining #excel #slicers

[magedmahmoud]

Thanks a lot .. Now i can use, modify & create the excel slicers ..Awesome !!

[jaredgoor]

This was extremely useful, thorough with good pacing.

[albertokusmic]

Brilliant explanation, thanks for sharing!

[NixonBranch]

Thank you very much for the excellent training video. Great video. Learned something new today!.

[eawhit]

Excellent tutorial. Extremely helpful, efficiently demonstrated, great cadence, and thoughtful scoping. Subscribed as a result and looking forward to watching more of your videos. Thank you!

[arunkhanal]

The video was really interesting and insightful. I got an opportunity to learn things in a smart way.

[chrisbain]

Very clearly explained. Very easy listening voice too!

[davidmanhire]

Great easy to follow tutorial. Slicers are no longer mysterious!

[wayneedmondson]

Awesome Jason! Slicers are so handy. Thanks for sharing your tips :)) Thumbs up!!

[ezammaze]

Very informative and helpful. Thank you very much.

[muhidrehman]

Great video. Learned something new today!

[claryfurtado]

Thank you very much for the excellent training video

[amad_ksa]

thanks ❤
Video summary

This video demonstrates how to use Excel slicers to filter data in a more interactive and user-friendly way. It covers loading sample data, creating slicers, and using them with pivot tables.

00:00
Introduction to Excel Slicers
Explanation of slicers
Loading sample data
Clearing formats for clean data
01:10
Creating and Using Slicers
Steps to create slicers
Filtering data with slicers
Multi-select feature
03:13
Tips for Managing Slicers
Right-click options
Adding and filtering blank data
Using subtotals with slicers
05:02
Advanced Slicer Features
Managing slicers in Name Manager
Highlighting multiple items
Customizing slicer appearance
07:07
Slicers with Pivot Tables
Creating pivot tables with slicers
Linking slicers to multiple tables
Adjusting slicer settings for pivot tables

[Aleicas]

Thank you for this video! Very useful! I have a question though. I created a table and added one slicer to filter data. I then added 3 pivot tables to have total amounts for the same table. When I select an item on the slicer, it filters the table and it gives me the totals on the pivot tables. However, the clicked item matches on the data table but it gives me a the total for a different item on the pivot tables. What am I doing wrong? Also, the “report connections” option is grayed out on the slicer.

[Scienyhuman]

Ver nicely explained: Quick question can you do a 'simplified' slicer with values, meaning instead of showing all data indivually you can click, ask to show as range for example "1000-200" dollars, button on the slicer ? Thanks so much !

[emmajohnston]

Excellant. Can you tell me how i can reduce a particular amount by 75%, - when applying a discount for example? Thank you

[MasonsLiberty]

How would one go about using a column value filter as a header for a print-friendly report? Say I wanted to print one report for each category, and have the category name at the top of the report. e.g. one each for BIKES, SHOCKS, HELMETS etc.

[sharran]

Hi thanks. Suppose my name column is too long so when we just do filter and put name then that name appears soon. But when we put slicer and same scenario and i want to see a particular name but since name list is too long in column slicer then how do I see that particular name ? So i need to scroll the entire slicer name column or how i put filter for that name which would be some where far which would not be initially seen on slicer column as it's too far somewhere

[rogerdeoliveira]

can you make a slicer depend on another slicer? example: I have a set of data for everyday for the last 3 years. I just want to show the last 10 days as options on the slicer...I'm having a hard time figuring out how to remove the other options from the options that my users can select. (im using an external data source on a pivot table)

[siyadoll]

hello sir i added 4 slicers on my dashboard but i have a problem when I click on the top filter button on my 4th slicer It starts showing the blank button on the other slicer but i have clicked the check box to hide item with no data ten why blanks buttons started appears