Search for courses or lessons
Redeem a coupon
Start free trial
If you wanted to add the following slicer to your PivotTable, how would you do it?
Right-click the PivotTable > Add Slicer > Click the checkbox next to Category
Select the Pivot > PivotTable Tools > Analyze (Options in Excel 2010) > Insert Slicer > Click the checkbox next to Category
Select the Pivot > PivotTable Tools > Design > Insert Slicer > Click the checkbox next to Category
How do you select multiple items as shown in the following slicer?
Select the first item, hold down the CTRL key, and select each subsequent item
Click the clear filter icon at the top right, then left-click each item you’d like to select
Select the first item, hold down the SHIFT key, and select each subsequent item
Why are slicers better than report filters?
They filter PivotTables in more efficient ways than a report filter
They invite user interaction with your PivotTable
They are easier to use with PivotTables than report filters
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement