Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Design Layout

 

PivotTable Design

There are two sets of PivotTable Tools. The following pages will walk through the PivotTable Tools Design Ribbon.

Review the Design Ribbon

The Layout Group lets you format the:

Subtotals

Grand Totals

Report Layout

Blank Rows

 

The PivotTable Style Options are:

Row Headers

Column Headers

Banded Rows

Banded Columns

 

Keep going...

PivotTable Tools ->Design-> Layout