Chapter 16

Ten Ways to Raise Your PivotTable Game


Bullet Changing the PivotTable view

Bullet Getting fancy with PivotTable styles

Bullet Modifying PivotTable options

Bullet Extracting PivotTable values for your formulas

Excel comes with so many powerful data-analysis tools and features that you might be wondering why you need to learn yet another: the PivotTable. The short answer is that the PivotTable is a useful weapon to add to your data-analysis arsenal. The long answer is that PivotTables are worth learning because they come with not just one or two but a long list of benefits.

Let me count the ways: PivotTables are easy to build and maintain; they perform large and complex calculations amazingly fast; you can quickly and easily update them to account for new data; PivotTables are dynamic, so components can be easily moved, filtered, and added to; and, finally, PivotTables can use most of the formatting options that you can apply to regular Excel ranges and cells.

Oh, wait, there’s one more: PivotTables are fully customizable, so you can build each report the way you want. That customizability ...

Get Excel Data Analysis For Dummies, 4th Edition now with O’Reilly online learning.

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