Comma Training Page 111

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