Home > Pivot > Filters > Videos Excel Videos - Pivot Table Filters Excel videos show how to use Slicers with a pivot table, show only the top 10 items, and more pivot table filter tricks

Pivot Table Slicers Introduction

Use slicers in Excel 2010 to filter one or more pivot tables. Quickly see the filtered items, and identify the dependent items in another slicer.

For detailed instructions and an explanation of the Excel 2010 slicers, see Excel Slicers blog article.

Slicers Connect to Multiple Pivot Tables

Excel slicers can be connected to multiple pivot tables that are based on the same pivot cache. Instead of manually filtering each pivot table, you can filter them all at once.

This video shows the steps in Excel for Office 365, and the written steps are on the Pivot Table Slicers page. (For Excel 2010 steps, see the next video)

This video shows the steps in Excel 2010. For detailed instructions and an explanation of the Excel 2010 slicers, see Excel Slicers blog article.

Pivot Table Report Filters

With report filters, you can focus on specific items in an Excel pivot table.

For more pivot table tutorials, see the list of articles: Excel Pivot Tables

Select Date Filters in Pivot Table

Use Date Filters in an Excel pivot table, to focus on specific dates or date ranges. Select a specific date or dates, or enter a date range, or choose a dynamic date range.

For more pivot table tutorials, see the list of articles: Excel Pivot Tables

Pivot Table Top 10 Filters

Use the Top 10 filter feature in an Excel pivot table, to see the Top or Bottom Items, or find items that make up a specific Percent or items that total a set Sum.

For written instructions for this Excel tutorial, see the Excel Pivot Table Filters - Top 10  

Hide Filter Arrows in Pivot Table

After you set up a pivot table, you might like to prevent people from selecting items in one or more of the heading drop downs. Watch this video to see how to use a bit of programming, to hide one or more of the drop down arrows in the headings. For detailed instructions, visit the pivot table protection page.

More Videos

Videos - Index