Maximizing Connectivity & Productivity

Slicer in Excel 2010

Use slicers to view (slice) a pivot table to make the pivot table summarization of data easier to read.

In essence, a slicer will ‘slice’ the pivot table by selected categories, so that only data is viewed.

To use:

Click inside the pivot table -> the contextual tab for Pivot Tables will appear -> Select the Options tab -> Click the Insert Slicer button -> a popup form to select the categories will appear -> select a category or more -> select the category to view -> and there you have the slice of data to view.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500