In Microsoft Excel 2013, you can apply a filter to limit the data in your PivotTable. When you do so, you'll find there's no visual representation of which values are in or out of the PivotTable. Filtering a PivotTable using slicers is the best way you can achieve this goal. In this online training video, you will learn how to use slicers and the Analyze contextual tab to represent visually the current filtering status of your various PivotTable fields.
When you apply a filter to a PivotTable, Excel limits the data that appears in…the body of your worksheet.…The problem is that there is no clear indication of which values are included,…and which values are excluded from the current state of the PivotTable.…In this movie, I will show you how to use slicers, which do give a strong visual…representation of values that are either in or out of the PivotTable.…I will use the Slicer sample workbook, which you can find in the Chapter03…folder of your Exercise Files archive.…
This PivotTable contains quarterly customer acquisition data for a company, and…it's based on a year and region.…Let's say that I just want to focus on the East region. I can create filters…using the tools that I've shown in other movies that you can access form the…PivotTable Fields pane.…But let's say that I want to have a strong visual representation of which…regions are displayed in the PivotTable.…To do that, I can click any cell in the PivotTable, then click the Analyze…contextual tab on the ribbon, and then in the Filter group, click Insert Slicer.…
Author
Released
4/11/2013- Creating a PivotTable
- Summarizing multiple data fields
- Managing subtotals and grand totals
- Grouping PivotTable fields
- Filtering with selections, rules, slicers, and search filters
- Applying PivotTable styles
- Formatting cells
- Creating PivotCharts
- Enabling PowerPivot
- Using DAX operators
- Visualizing data with matrices, cards, and tiles
- Building charts and maps
Skill Level Intermediate
Duration
Views
Related Courses
-
Office 2013 New Features
with David Rivers2h 31m Intermediate -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Intermediate -
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate
-
Introduction
-
Welcome58s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables3m 14s
-
Creating a PivotTable2m 37s
-
Pivoting a PivotTable3m 13s
-
Configuring a PivotTable3m 17s
-
Managing PivotTables3m 48s
-
-
2. Summarizing PivotTable Data
-
Grouping PivotTable fields2m 40s
-
3. Sorting and Filtering PivotTable Data
-
Sorting PivotTable data3m 41s
-
Creating a custom sort order3m 52s
-
Formatting slicers3m 7s
-
-
4. Formatting PivotTables
-
Applying a PivotTable style2m 36s
-
Creating a PivotTable style4m 27s
-
-
5. Applying Conditional Formats to PivotTables
-
6. Creating and Manipulating PivotCharts
-
Creating a PivotChart2m 34s
-
Pivoting a PivotChart2m 24s
-
Filtering a PivotChart2m 48s
-
Formatting a PivotChart3m 38s
-
-
7. Printing PivotTables
-
Printing a PivotTable2m 53s
-
Printing a PivotChart1m 14s
-
-
8. Manipulating PivotTables Using Macros
-
Running an Excel macro4m 4s
-
9. Starting with PowerPivot and the Data Model
-
Introducing PowerPivot4m 32s
-
Importing PowerPivot data3m 24s
-
Managing table columns3m 21s
-
10. Introducing Data Analysis Expressions (DAX)
-
Introducing the DAX language2m 29s
-
Using DAX operators4m 35s
-
Surveying DAX functions2m 35s
-
Adding calculated columns2m 11s
-
Adding calculated fields3m 7s
-
-
11. Visualizing Power View Data Using Matrices, Cards, and Tiles
-
Starting out with Power View2m 16s
-
Creating a card3m 30s
-
Creating a tile3m 18s
-
Filtering Power View objects3m 31s
-
-
12. Visualizing Power View Data Using Charts and Maps
-
Creating a pie chart2m 7s
-
Creating a line chart2m 40s
-
Creating a map2m 31s
-
Creating chart multiples2m 38s
-
Conclusion
-
Next steps54s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Filtering a PivotTable using slicers