Back to lesson
1. What is the easiest way to create a PivotTable?
Select a cell inside your data range > Insert > PivotTable
Go to Insert > PivotTable Select your data
Select your data > turn it into an official Excel Table > Insert > PivotTable
2. Assume that our data source has only three fields: Class (containing Alcohol and Food), Category (Appetizers, Bottled Beer, etc…) and Sales $, how would you configure the Pivot Table shown below?
Category on Rows, Sales on Rows, Class on Columns.
Class on Columns, Category on Rows, Sales $ on Values.
Class on Rows, Category on Columns, Sales $ on Values.
3. An important concept of PivotTables is to realize that the data is not “live”. What is the fastest way to refresh the data in this PivotTable (only) to ensure that it is up to date?
Right click any cell in the PivotTable and choose Refresh.
Close and re-open the file.
Select a cell in the PivotTable > Data tab > Refresh > Refresh
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement