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 ...

Get PowerPivot for the Data Analyst: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.