PivotTable: Summary

2. Try It: Group the Data

Go to PivotTable Tools ->Options.

Go to Group-> Group Selection.

 

What Do You See? When you click on Group, you should see an Outline on the left side of the spreadsheet. At the top of the Outline are two Levels. In the Example on this page, we are on Level 2. OK, that will do...

 

This lesson looked at PivotTables and the PivotTable Tools. In the next lesson, we will review the options for PivotCharts.

 

OK, OK. Allez allez in free. You done good. Go get a cookie!

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Report Layout

PivotTable Tools ->Options-> Group-> Group Selection