The Slicer tool allows us to filter data easily and quickly. By using the slicer, we can select from a set of buttons to filter data rather than using drop-down lists. It is easy to see what exactly is being filtered, especially when multiple items are being filtered. Also, multiple slicers can be created that are associated with specific PivotTables. Slicers make it much easier to understand the data that is being displayed in a PivotTable.
We will create two slicers that will be associated with this PivotTable.
Step1. Switch to the Analyze tab on the Ribbon.
Step2. To open the Insert Slicers dialog box, in the Sort & Filter group,
Step3. To choose specific fields for the slicers,
Click the Specialty checkbox,
Click the Doctor Name checkbox, Click
Step4. Move and resize the slicers to appear side by side:
5. To choose an item, in the Specialty slicer,
NOTE: To select multiple items that you want to filter in a slicer, hold down the Control key and Click the items you want to filter.
Step6. To choose a doctor, in the Doctor Name slicer,
Clickany doctor name that is highlighted
NOTE: You can also apply styles to give the slicers a consistent look. To do this, Click the slicer you want to format and choose any slicer style within the Slicer Styles group.
Step7. To remove the doctor name filter, in the Doctor Name slicer,
Step8. To delete a slicer,
Click a slicer, press: Delete key
Step9. To save the workbook, press: