EXCEL PIVOT TABLE - Index Page

← Back to document page

EXCEL PIVOT TABLE David Geffen School of Medicine, UCLA Dean s Office Oct 2002 2Table of Contents Part I Creating a PIVOT TABLE EXCEL What is a PIVOT Creating PIVOT Tables (Step-by-Step) ........................................ ...............5 Setting up the Layout Graphing Your Editing your Part II Customizing a PIVOT TABLE Redesigning the PIVOT TABLE Including an Additional Data Field ........................................ ...............11 Using the Page Displaying Pages on Separate Representing Your Dollar Amounts as Percentages of a Column or a Displaying the Detail Data Behind a Summarized Sorting a PIVOT TABLE Collapsing and Expanding a PIVOT Hiding a Row or Column Suppressing Copy Paste Special Value a PIVOT TABLE Changing Field Button Labels.

7 When done, click “OK”. Here is the result of your pivot table. The pivot table is created on a new sheet in the workbook. You can rename the sheet that contains the pivot table by double clicking on the sheet tab name and typing your new

  Excel, Table, Here, Click, Pivot, Excel pivot tables