O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9. Cool Tricks New with PowerPivot

The PowerPivot add-in enables you to build multiple pivot table elements on one worksheet that are all controlled by the same set of slicers.

This is just your run-of-the-mill pivot table and pivot chart that have been moved to be adjacent to each other. You can build pivot charts that show different summaries and have them all respond to a single set of slicers.

The PowerPivot add-in has a drop-down that offers eight layouts. You’ve already seen the single pivot table, single pivot chart, and flattened ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required