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 ...
Get Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
