PivotTable Drill
Exercise 7: Filter to New York with a slicer
Task
Insert a slicer for Branch and show only New York.
Moves 0 (target 2)
FileHome
| Row Labels | Sum of Amount |
| Johnson | 33500 |
| Smith | 57500 |
| Williams | 45500 |
| Grand Total | 136500 |
Insert a slicer for Branch and show only New York.
This drill is for computer screens. On a phone you can review the steps.
- PivotTable Analyze > Insert Slicer
- Check Branch and click OK
- Click New York in the slicer
Key takeaway
Slicers are handy for switching views on the spot in a meeting.
See Pivot Tables for details.