Excel® 2016 Pivot Table Data Crunching

Introduction

In This Introduction

What You Will Learn from This Book

What Is New in Excel 2016’s Pivot Tables

Skills Required to Use This Book

Invention of the Pivot Table

Sample Files Used in This Book

Conventions Used in This Book

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