News

To create the PivotTable, click somewhere in the list of data, choose the Insert tab, and click PivotTable. Excel will automatically select the area containing the data, including the headings.
By the end of the course, users will also know how to create a Pivot Chart and add sparklines and slicers and create a basic macro to refresh PivotTable data.