Search for courses or lessons
Redeem a coupon
Start free trial
What is the first thing we do when creating a PivotTable?
Connect to the data source.
Choose our formatting options.
Choose the PivotTable layout.
Usage of a PivotTable solution differs from that of an ad-hoc solution generated in Excel, and can generally be delegated to users with less Excel knowledge to use. Assuming we want to develop a solution that we can hand off to someone with very limited Excel skills, which task would we need to focus on as a developer?
Designing and building the initial PivotTable solution.
Refresh and update the data.
Generating alternate data views.
What primary benefit of developing a PivotTable solution is always true?
We can refresh the solution many times.
The ability to drill into every aspect of the data at all times.
The user can generate their own insights by slicing and dicing the data as they see fit.
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement