MO-201 · Question #14
On the "Sales Analysis" worksheet, insert a slicer that allows users to filter the PivotTable by "Category". Then use the slicer to display only "Psychology" books.
Excel PivotTable Slicer - Explanation Overall Goal The task asks you to add a slicer - a visual, clickable filter panel - to a PivotTable so users can interactively filter data by "Category" and then immediately apply it to show only "Psychology" books. Slicers are the preferred
Question
Explanation
Excel PivotTable Slicer - Explanation
Overall Goal
The task asks you to add a slicer - a visual, clickable filter panel - to a PivotTable so users can interactively filter data by "Category" and then immediately apply it to show only "Psychology" books. Slicers are the preferred approach over row/column label filters because they are visible, persistent, and user-friendly.
Step-by-Step Breakdown
1. Navigate to the "Sales Analysis" worksheet
You must be on the correct sheet first. Slicers are scoped to the sheet and PivotTable they're inserted from. Acting on the wrong sheet means the slicer won't connect to the right data.
2. Click anywhere inside the PivotTable
Excel only reveals PivotTable-specific menu options (the PivotTable Analyze tab) when your cursor is within the PivotTable. Clicking outside it hides these contextual tools entirely.
3. Open PivotTable Analyze → Insert Slicer
PivotTable Analyze (or Options in older Excel versions) → Insert Slicer. This is the correct entry point because slicers created here are automatically linked to the PivotTable. Using Insert → Slicer from the main ribbon also works in newer Excel, but requires you to then manually connect it to the PivotTable - an extra error-prone step.
4. In the Insert Slicers dialog, check "Category" → click OK
This tells Excel which field to expose as a filterable button list. Only fields in your PivotTable's data source appear here. If "Category" doesn't appear, the field isn't in the dataset.
5. Click "Psychology" in the slicer panel
Single-clicking a slicer button applies that filter. The PivotTable immediately updates to show only rows where Category = Psychology.
What Goes Wrong If Steps Are Skipped
| Skipped Step | Consequence |
|---|---|
| Not clicking inside the PivotTable first | PivotTable Analyze tab doesn't appear; you can't access Insert Slicer |
| Inserting slicer from wrong location | Slicer may not be connected to the PivotTable automatically |
| Checking the wrong field | Slicer filters by the wrong dimension; PivotTable won't filter by Category |
| Forgetting to click "Psychology" | Slicer exists but no filter is applied; all categories still show |
Memory Tip
Think: Click In → Insert → Check → Click Filter
"I need to be inside the table, insert a slicer, check the field I want, then click my value."
This mirrors the Excel UI flow exactly and prevents the most common mistake - trying to insert a slicer without first activating the PivotTable context.
Topics
Community Discussion
No community discussion yet for this question.