Introduction

The pivot table is the single most powerful command in all of Excel. Pivot tables came along during the 1990s, when Microsoft and Lotus were locked in a bitter battle for dominance of the spreadsheet market. The race to continually add enhanced features to their respective products during the mid-1990s led to many incredible features, but none as powerful as the pivot table.

With a pivot table, you can transform one million rows of transactional data into a summary report in seconds. If you can drag a mouse, you ...

Get Excel® 2016 Pivot Table Data Crunching now with O’Reilly online learning.

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