pic1

Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2   Create and Manage PivotTables: Format Data (PivotTable Styles)

PivotTable: Styles

A PivotTable can be formatted with Styles.


Before You Begin: Select the PivotTable. The PivotTable Tools should be available.

1. Try it: Format the PivotTable Style

Go to PivotTable Tools ->Design.

Go to PivotTable Styles.

Select: Pivot Style Medium 3.

 

What Do You See? The PivotTable Styles formatted the Column Headers (Sum of Amount, Category, Product)  as well as the Row Headers (Corporate, Educational, etc.)

 

Keep going...
graphic1

PivotTable Tools ->Design-> PivotTable Styles

graphic2