Analysis Tools
One of the
newest tools in Excel is the Slicer. The Slicer can be found
on the
Analyze Ribbon as part of the PivotChart Tools.
We'll start with the options for the Active Field and then work with
the Slicer.
Before You
Begin: Select the PivotChart. The
PivotChart Tools should be available.
1.
Try it: Review the
Analyze
Tools
The
Analyze Tools include:
Active
Field
Data
and
Show/Hide.
Keep
going...!