12  The Create PivotTable dialogue box will appear. To Insert a Pivot Table: A pivot table is a data summarization tool within Excel. A pivot table can sort, count, total and average  the data within a table or spreadsheet.  Header Row  – Creates a row at the top of the table for headers. Total Row  – Creates a row at the bottom of the table populates a total sum for each column.  Banded Rows  – Shades every other row in the table. First Column  – Shades the entire first column the same color as the header row. Last Column  – Shades the entire last column the same color as the header row.  Banded Columns  – Shades every other column in the table.  3. Select the desired checkboxes to change the format of the table. 1. Select any cell in your data range. 2. Select Pivot Table located on the Insert tab. Pivot Tables 