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


Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
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...
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 ...
Pivot Chart Formatting Copy Trick in Excel - Excel Quickie
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
4 Tips to Camouflage Slicers in Excel
Tutorial: Blend slicers for pivot tables into the design of your spreadsheet. This video tutorial i...
Tutorial Details
Downloadable Files: Excel File
Similar Content
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...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
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...
Excel Forum