Hello, PivotTable

4. What Do You See? When you click on OK, Microsoft Excel will create a new, blank PivotTable in a new worksheet. The Pivot Table Tools should be available. There are two PivotTable Ribbons: Options and Design.

 

The Options Ribbon includes:

PivotTable

Active Field

Group

Sort and Filter

Data

Actions

Calculations

Tools

Show/Hide

 

The Design Ribbon includes:

Layout

PivotTable Style Options

PivotTable Styles

 

Keep going, please...

Insert ->Tables->PivotTable

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables