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...!

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Analyze

PivotChart Tools ->Analyze