Slicers — Making Pivot Tables Easier

You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table.

Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data.

To insert:

  1. Click in your Pivot Table.
  2. From the Pivot Table Tools > Analyze toolbar, Click Insert Slicer.
  3. Select the fields to provide a filter.
Insert slicer

4. To filter select the value on the slicer dialog box.

Slicers with Pivot Table

To select multiple values, click on the Multi-Select icon then click on the desired values. To clear the filter, select the Clear Filter icon with the red x to display all values.

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: