O'Reilly logo

Excel Power Pivot and Power Query For Dummies by Michael Alexander

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

Chapter 3

The Pivotal Pivot Table

In This Chapter

arrow Getting to know pivot tables

arrow Laying out the geography of a pivot table

arrow Building your first pivot table

arrow Creating top and bottom reports

arrow Understanding, creating, and formatting slicers

arrow Sprucing up slicers with customization

arrow Controlling multiple pivot tables with slicers

arrow Using timeline slicers

When creating Power Pivot data models, you will have to use some form of pivot table structure to expose the data in those models available to your audience.

Pivot tables have a reputation for being complicated, but if you’re new to pivot tables, rest easy. This chapter gives you the fundamental understanding you need in order to analyze and report ...

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