Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Report Layout

 

PivotTable: Report Layout

There are several Report Layouts that you should consider. The goal of any PivotTable is to display the data. Depending on the data, some of the layouts make sense while others seem confusing.

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

1. Try This: Edit the Field List
Row Labels: Category, then Product
Column Labels: Month
Values: Sum of Amount

Keep going, please...

PivotTable Tools ->Design-> Layout