O'Reilly logo

Excel® 2013 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

25. Mashing Up Data with PowerPivot

In Chapter 24, “Using Slicers and Filtering a Pivot Table,” you learned how to build pivot tables from a single data source. A revolutionary add-in called PowerPivot debuted in Excel 2010 that enabled you to build pivot tables from multiple tables. For Excel 2013, that core functionality of PowerPivot is built directly into Excel. This chapter starts by showing you how anyone with Excel 2013 can build pivot tables from multiple tables.

Certain versions of Excel 2013 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 ...

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