Excel 2010 Tutorial – Pivot Table Slicers

excel-tutorial-pivot-table-slicersPivot Tables are covered in detail on our Advanced Excel Training course. However,  for some basic pivot table tips, read How to Create a Pivot Table and How to Change the Function of a Pivot Table. If pivot tables are a bit advanced for you and you’re looking to start afresh then our beginners Excel Training might be perfect for you. Click the link to read the full course description.

Pivot Table Slicers Tutorial

In a Pivot Table you can apply filters to your data, using the report filter and by filtering within the row or column fields. When using the multiple items in a report filter it is not obvious which criteria you have specified and likewise with the row and column filters.

So what can you do? The answer is to use Slicers in Excel 2010 and this is how to do it:

1. Ensure that you are not working in compatibility mode. (If you are convert your workbook first.)

2. Refresh the Pivot Table by clicking on the Refresh button on the PivotTable tools, Options tab.

excel-2010-tutorial-pivot-table-slicers-refresh

3. Click on the Insert Slicer button  and select Insert Slicer.

excel-2010-tutorial-pivot-table-slicers-inset-slicer

4. Tick the fields you want to use to filter with, and a Slicer box will be displayed with items in the fields.

excel-2010-tutorial-pivot-table-slicers-insert-slicers

5. Specify your criteria by clicking on the item, or hold the Ctrl key and click to select more than one. The PivotTable will change to show only the data meeting your criteria.

6. To clear a Slicer filter, click on the clear filter button in the top right of the slicer box.

7. To remove a slicer box, click on the edge of the box and press delete on the keyboard.

Think pivot tables are a piece of cake? Want to take your Excel skills to the next level? Our VBA for Excel course is designed for experienced users of Microsoft Excel. Create and edit macros from scratch with comprehensive instruction on VBA code.

Tags

, , , , , , , , , , , ,
Andy Trainer


Connect with Andy on Google.

View all posts by Andy Trainer

Leave a Comment