Page 167 - Ms Excel Note and Workbook
P. 167
MICROSOFT EXCEL NOTE AND WORKBOOK
Slicers
Slicers make filtering data in PivotTables even easier. Slicers are basically just filters but are easier
and faster to use, allowing you to instantly pivot your data. If you frequently filter your PivotTables,
you may want to consider using slicers instead of filters.
To add a slicer:
1. Select any cell in the PivotTable.
2. From the Analyze tab, click the Insert Slicer command.
3. A dialog box will appear. Check the box next to the desired field. In our example, we'll
select Salesperson, then click OK.
TIP
Slicers make filtering data
in PivotTables even easier.
158 | P a g e
