O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

17. Mashing Up Data with PowerPivot

A revolutionary add-in called PowerPivot, which debuted in Excel 2010, enabled you to build pivot tables from multiple tables. For Excel 2016, that core functionality of PowerPivot is built directly into Excel. This chapter starts by showing you how anyone with Excel 2016 can build pivot tables from multiple tables.

Certain versions of Excel 2016 also ship with the full PowerPivot add-in. If you have one of these versions, you can activate the add-in and access additional tools, such as a powerful Data Analysis Expressions (DAX) formula language. The latter part of the chapter describes the additional benefits of PowerPivot.

Joining Multiple Tables Using the Data Model

When you see the term Data Model in Excel ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required