Excel - Add Slicers to Filter a Pivot Table - Episode 2009
1,821 views · Published 3 September 2016 · 3:08 · Indexed 24 October 2026
Channel: MrExcel.com · 2016 · Education
Microsoft Excel Tutorial - Slicers to Filter a Pivot Table. Welcome to the MrExcel Podcast, where we teach you all about Excel and its amazing features. In this episode, we will be discussing Pivot Slicers, a powerful tool that allows you to filter your Pivot Tables with ease. I'm Bill Jelen, and I'm excited to show you how to use this feature to enhance your data analysis. If you've been using Pivot Tables for a while, you may be familiar with the old way of filtering, which involved using the filter next to the Pivot Table. However, this method had its limitations, such as not being able to print multiple selected items on the report. But fear not, because Excel 2010 introduced us to Slicers, a game-changing feature that makes filtering a breeze. To use Slicers, simply go to the Analyze tab and click on "Insert Slicer". You can choose which fields you want to filter by, and the Slicers will appear on your screen. By default, they are tiled in the middle, but you can easily rearrange them to your liking. You can also change the number of columns, size, and color to make them more visually appealing. One of the best things about Slicers is the ability to select multiple items with just a click. This is especially useful for touch screen devices, as you don't have to hold down the control key. And the best part? You can use Slicers with both Pivot Tables and Pivot Charts, making it a great tool for creating dynamic dashboards. In our next episode, we will show you how to connect Slicers to multiple Pivot Tables and Charts for even more powerful data analysis. Don't forget to subscribe to our channel and check out our book, which covers everything we discuss in our podcast episodes. Impress your boss with your newfound knowledge of Pivot Slicers and take your data analysis to the next level. Thank you for watching, and we'll see you in the next episode! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction to Pivot Slicers (00:11) Building a Pivot Chart (00:21) Comparison to traditional filters (00:55) Customizing Slicer options (01:44) Using Slicers for filtering (02:26) Benefits of using Slicers (02:39) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #pivottable #excelslicers This video answers these common search terms: how to use pivot slicers in excel what are excel pivot slicers why do you use pivot slicers in excel how to create a slicer in pivot table excel what is a slicer in excel pivot table how to use slicers in excel pivot table how to add a slicer in excel pivot table how to create slicer in excel pivot table how to create a slicer in excel pivot table how to add slicer filter in excel how to add slicer in excel how to create slicer in excel Slicers are visual filters for a pivot table. Pivot Filters have been around They have to live near the pivot table They are awful when you want to select multiple items Visual filters were introduced in Excel 2010 as Slicers When you insert slicers, they are tiled in the middle of the screen You can change number of columns Arrange the size Change the colors Great for multi-select Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153836/ Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153836/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920