The one option in the Load To menu that we didn’t look at was the ‘Add to Data Model’ option. The Data Model is another name for PowerPivot which is a very neat piece of software upgrading Pivot Tables significantly. We don’t go into Power Pivot extensively in this course, as it’s worthy of several courses dedicated exclusively to it, but we do scratch the surface of it as it links so well with PowerQuery.
In this lesson, we’re simply going to show you how to get to it as it’s an add in to standard Excel.
Really simple this one…
Go to File and then to Options.
Choose Addins from the list and then at the bottom of the resulting screen, you’ve got a drop down menu that says ‘Manage Excel Addins’. Select this! From the drop down listing select ‘Manage COM Addins’.
From the resulting menu, select ‘Microsoft Power Pivot for Excel’ and then ‘Ok’.
The Power Pivot tab will then be available in Excel.