Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.3. Apply and manipulate PivotTables

PivotTable Tools ->Options Pivot the Table What is a PivotTable, anyways? To Pivot means to move the data from the Rows into the Columns. This is cool. Before You Begin: Select the PivotTable. The PivotTable Tools should be available.   3. You Gotta Try This: Pivot the Table! Go to the Field List Drag and Drop the Category Field from the Column Labels to the Row Labels.   Make sure the Category is ABOVE the Product field.   Really, keep going...