Search Contextures Sites
Custom Search

 

More Videos

Videos - Index

 

 

 

 

 

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.

Excel 2010 Pivot Table Slicers Introduction

Excel 2010 Slicers Connect to Multiple Pivot Tables

Excel Pivot Table Report Filters

Select Date Filters in Excel Pivot Table

Pivot Table Top 10 Filters

Hide Filter Arrows in Pivot Table

Excel 2010 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.

Excel 2010 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.

Excel 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 Excel 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

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 31, 2016 7:33 PM