STEP 1:Select your Pivot Table by clicking anywhere inside it. STEP 2: Go to Options(Excel 2010)/Analyze(Excel 2013&2016) > Insert Slicer Select the Month and Year Fields. Your slicer is now ready! Go crazy clicking, slicing and dicing your data!

TIP: Hold down the CTRL key to select multiple items in your Slicer. How To Insert a Pivot Table Slicer: 2. Different Ways to Filter an Excel Slicer Excel Slicers are the best thing since sliced bread! They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table. There are several ways that you can filter an Excel Slicer.

Try it now by downloading this free workbook. Add Columns to Slicer Buttons When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout. Say that your Slicer is showing months from January to December, you can change the layout of the buttons to show in 3 separate columns, turning it into a “Quarterly View”.

To do this you need to click on your Slicer and go to Slicer Tools > Options > Buttons > Columns. You can then use the scroll bar to increase and decrease the columns or manually type in the number of columns to show your Slicer. STEP 1:Select your Slicer. STEP 2: Go to Slicer Tools > Options > Slicer Styles Select a style you prefer. Your slicer now has a different style!

Connect Slicers to Multiple Excel Pivot Tables Normally when you insert an Excel Slicer it is only connected to the that you are inserting it from. What about if you had multiple Pivot Tables from the same data set and wanted to connect a Slicer to all of the Pivot Tables, so when you press a button all the Pivot Tables change? Well this is possible with the Report Connections (Excel 2013 & 2016) / PivotTable Connections (Excel 2010) option within the Slicer. This is how it is achieved. (Password to unlock: myexcelonline) STEP 1: Click on a Slicer, hold the CTRL key and select the other Slicers STEP 2: Right click on a Slicer and select Size & Properties STEP 3: Under Properties, “ uncheck” the Locked box and press Close STEP 4: Go to the ribbon menu and select Review > Protect Sheet STEP 5: “ Uncheck” the Select Locked Cells and “ Check” the Select Unlocked Cells & Use Pivot Table Reports STEP 6: Enter a password (optional) and press OK Free Excel Pivot Table Webinar Training! Canon pixma mp240 scanner software. If you liked all the above cool Slicer tips, then you will love my free where I show you more cool Slicer tricks, as well as various Pivot Table features like: Grouping, Year To Data Analysis, Variance Analysis and I will also show you how to create an interactive Excel Dashboard!

Click below to join for free and learn all these cool Pivot Table features that will make you stand out from the crowd.