10. Mashing Up Data with Power Pivot

Power Pivot debuted in Excel 2010 as a free add-in with six jaw-dropping features. It was an amazing product, created outside the Excel team. You’ve already seen the Data Model in Chapter 7, “Analyzing Disparate Data Sources with Pivot Tables.” The Data Model is really the Power Pivot engine, and it was first built into Excel 2013.

The Data Model gives you some of the Power Pivot features, but many more ...

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.