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:


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