In the previous lesson, we looked at the various Load To options that are available when loading data from the PowerQuery Editor into standard Excel. These options include the ability to load to a table of data, load to a Pivot Table or Pivot Chart or to simply create a connection with no output options.
Lesson Synopsis
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.
Not much extra to see here - just follow the 1 min video!
Lesson Notes
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.