Excel Power Pivot & Power Query For Dummies, 2nd Edition

Chapter 3

The Pivotal Pivot Table

IN THIS CHAPTER

Getting to know pivot tables

Laying out the geography of a pivot table

Building your first pivot table

Creating top and bottom reports

Understanding, creating, and formatting slicers

Sprucing up slicers with customization

Controlling multiple pivot tables with slicers

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