Search
Contextures Sites
| |||
|
|
|
|||
Contextures Inc., Copyright ©2013
All rights reserved.
Search Contextures Sites
Excel Video Tutorials -- Pivot Table Filters
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
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
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 22, 2013 7:41 PM
