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:

 

DOWNLOAD EXCEL WORKBOOK

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials