How To Create a Pivot Table in Excel 2007
Then under the Insert tab tap on the PivotTable button. The PivotTable dialog box opens and the table or data range we already selected will show in that field. For our demonstration we will put it in a new worksheet because it makes things less cluttered. The PivotTable Field List opens up and the PivotTable tools become available. snag the fields you want to include in the table by dragging them to the different boxes below....