CHAPTER 10. Unlocking features with the Data Model and Power Pivot
In this chapter, you will:
When I first saw the Power Pivot add-in in 2008, I thought the big news was the ability to handle 100 million rows in Excel. As time passes, and I realize that I frequently don’t have anywhere near a million rows of data, I have started to appreciate the other powerful features that become available when you choose the box Add This Data To The Data Model.
The phrase “Add this data to the Data Model” is a very boring phrase. During the era of Excel 2013 and Excel ...
Get Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) 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.
