Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Insert ->PivotTable

Insert a Pivot Table

A PivotTable summarizes data and displays the results. It is a reporting tool that works very well. Here is how you start.

 

1: Insert a PivotTable
Open the Bug Report workbook.

Go to the OriginalData spreadsheet and Select all

 

Go to the Insert tab

then select PivotTable

 

Microsoft Excel brings up a wizard to get you started.