3 Slicer Tricks for Pivot Tables in Excel

Add to Favorites
Author: | Edits: don

3 ways to better use Slicers for Pivot Tables in Excel.

These tips will show you how to avoid common mistakes, make Pivot Tables more quickly, and, generally, make life much easier when filtering your Pivot Data.

Slicers seem simple enough, but it is weirdly easy to get them tangled up with one another and with unsuspecting PivotTables and this tutorial sets out to tackle 3 of the most commonly encountered issues.

 


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Remove Deleted Items from Slicers & Pivot Tables
Tutorial: How to remove items from a Slicer that are not actually in the data set that the Slicer f...
Quickly Consolidate and Compare Data in Excel Using a Pivot Chart & Pivot Table
Tutorial:   Visually combine and compare data in Excel in less than 1 minute! This technique takes ...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Hide Formulas in Excel
Tutorial: How to hide a formula in Excel so that a user cannot see it, select it, or change it - th...
Print Preview Display for Specific Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview mode or window in Excel for ...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course