Contextures

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.

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.

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

 

More Videos

Videos - Index

 

Search Contextures Sites

More Links

Videos - Index

 

Free Pivot Table Tools

 

 

excel chart tools by peltier tech

 

 

 

Pivot Power Premium

 

 

Excel UserForms for Data Entry

 

Last updated: December 13, 2016 3:11 PM
Contextures RSS Feed