Using the Slicer to make PivotTables more interactive


show more Using the Slicer to make PivotTables more interactive provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features show less
please wait ...

Using the Slicer to make PivotTables more interactive

PivotTables haven't changed dramatically since the 2007 version, but the Slicer is a new feature that gives PivotTables some interactivity. Now in this workbook, 05_01_ slicer.xlsx, we have two sheets: We have Data, which is the underlying data, and we have Table, which is the PivotTable. So if you're not already in the PivotTable, you might want to go there and click somewhere in it. When we're in there, you see under PivotTable tools we have the Options tab, and we have the Design tab.

We want to insert a Slicer. So go to the Insert tab and choose Slicer, and this tells us what Slicer we can do. Basically, what this means is we can filter the data by any of these items. Let's put in Region and Month, and this is going to create two Slicers, so click OK, and maybe arrange them where they're easier to see. So we have Region, and we have Month. Before we even use them, we can go and format them to make them a little easier to use.

I have Month selected. So you have various ...

Using the Slicer to make PivotTables more interactive
Video duration: 2m 14s 1h 51m Appropriate for all

Viewers:

Using the Slicer to make PivotTables more interactive provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features

Subject:
Business
Software:
Excel
Author:
please wait ...