Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.3. Apply and manipulate PivotTables: Column Header   PivotTable: Column Header We began this PivotTable to answer the question: what did you sell? The next question would be: Who bought what?   In this spreadsheet, the clients are tagged as Corporate, Education, Government and Private in the Category field. So, how many Breakfast Buffets were served to our corporate clients? Who bought what?   The Category field will be added to the Column Header. Here are the steps. Before You Begin: Select the PivotTable. The PivotTable Tools should be available. 1. Try it: Add Another Field Go to the PivotTable Field List. Drag the Category to the Column Label.   Keep going, please...

PivotTable Tools ->Options-> Show> Field List