Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table.

They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity in their reports!  I show you how to insert a Pivot Table Slicer below:




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.

Click OK.

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:

Insert a Slicer

Helpful Resource:

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

GETPIVOTDATA Function What does it do?A formula that extracts data stored in a Pivot TableFormula breakdown:=GETPIVOTDATA(data_field, pivot_table, , ,...)What it means:=GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...) T...
Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis.DOWNLOAD WORKBOOK...
Sort by Largest or Smallest With Excel Pivot Table... There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with Excel Pivot Tables, is it allows me to sort virtually anywhere!Let us start off with this Excel Pivot Table showing the Sum of SALES for...
Pivot Table Calculated Item Pivot Table Calculated Items allow you to do mathematical calculations with your Item List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Items can be used to calculate chan...