Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
What characteristics are required in the source data to create a PivotTable?
A contiguous data range with headers
A list or table with values in it
The data must be housed in an Excel table or covered by a named range
2
Advanced
How do you remove an item from a PivotTable?
Drag it back from the Pivot fields into the field well
Right-click the item in the field list and choose Remove
Delete it from the source data, then refresh the PivotTable
3
Advanced
If you change something in your source data:
Then you must manually refresh your PivotTable in order to see the change show up there
The PivotTable will update automatically
You must close your workbook and re-open it to get the PivotTable to update
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement