Search for courses or lessons
Redeem a coupon
Start free trial
What characteristics are required in the source data to create a Pivot Table?
The data is housed in an Excel table or covered by a named range
A contiguous data range with headers
A list or table with values in it
How do you remove an item from a Pivot Table?
Right click the item in the field list and select Remove
Delete it from the source data, and then refresh the Pivot Table
Drag it back from the Pivot fields into the field well
Suppose you change something in your Pivot Table's source data. What are the implications?
The Pivot Table will update automatically
You must manually refresh your Pivot Table in order to see the change show up there
You must close your workbook and re-open it to get the Pivot Table to update
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement