graphic1

Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2 Create and Manage PivotTables: Create New PivotTables

Hello, PivotTable

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

 

The Analyze Ribbon includes:

PivotTable

Active Field

Group

Filter

Data

Actions

Calculations

Tools

Show

 

The Design Ribbon includes:

Layout

PivotTable Style Options

PivotTable Styles

 

Keep going, please...

Insert ->Tables->PivotTable

graphic2
graphic1