Pivot table slicers are the easiest way to slice and dice your data with just a few clicks.

Notice that when we do this, it adds to the selection of the data inside of the pivot table. Customize your Excel Pivot Table Slicer selections for more specific views of your data. I could also make multiple selections on my data by holding control on the keyboard and clicking on another option inside of a window. The slicers stack so each box that we choose narrows down the data further. I can further refine my selection in the other box by clicking on one of these options. So if I click on only one client for example, the pivot table updates to match. Stack Your Slicers to Narrow Your View Further Instructor Now, one of the coolest options when it comes to filtering data with pivot tables is the ability to use things called slicers and timelines. Use Excel Pivot Table Slicers to filter your selection. When I click on one of the options in these windows, it filters the data inside of my pivot table to my selection. Now you can see these boxes that we checked in these windows of their own. Let's check a box on a couple of fields to create slicers from them. Filter Your Data View Based on Your Selections The menu that pops up will show each column of data in your spreadsheet. After that, you can see Pivot table is created in another sheet. A Dialogue box is open as shown below now select a Table/Range of table. Click on the Pivot Table option under the Tables section. Click on any cell in the table and go to the Insert tab. With the pivot table selected, find the Analyze tab and click on Insert Slicer. Step 1: First, create a Pivot table for the given data. I'm working in a pivot table here and I'll add my first slicer. Add Your First Slicer to Your Excel Pivot Table To use the Slicer, simply select one of the fields in the Slicer to filter your data by that field.Note : Watch this short tutorial screencast or follow these quick steps that compliment this video: 1.In the Insert Slicers dialog box, check the field or fields (Yes, you can create multiple slicers at once!) to use to 'slice' your data, then click OK.On the PivotTable Tools Analyze tab ( PivotTable Tools Options tab in Excel 2007/2010), in the Filter group ( Sort & Filter group in Excel 2007/2010), click the Insert Slicer command (and then select Insert Slicer in Excel 2007/2010).This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016. To add a Slicer to a pivot table, follow these four steps. Adding a Slicer is similar to adding a second Page field ( Report Filter) but is even easier to use. Slicers make it really easy to filter data in a pivot table. How to Insert a Slicer in a Pivot Table in Microsoft Excel See Microsoft Excel: Tips and Tricks for similar articles.

How to use slicers in excel