When creating a PivotTable, it is good practice to begin by turning the Excel data into an Excel table. Using Excel's table feature has several benefits including using the column headers as filters, formulas propagating to all the cells in a column, and the option to add a total row. Possibly the most important benefit, when working with a PivotTable, is that the PivotTable can be refreshed when new rows or columns are added to the table; the user doesn't have to manually adjust the source data range to include the new data.
A table can be created either from an empty range or from an existing range of data. We will convert existing data to a table.
Step1. Verify that the Acad Programs worksheet tab is selected.
Step2. To select the Insert tab, on the Ribbon,
Click the Insert tab
Step3. To create the table, in the Tables group,
Step4. To complete the table,
Step5. To change the name of the table, in the Properties group,
Click, type: StudentInfo Enter
Step6. To deselect the table,
Click in any cell within the table