Using PowerPivot with Excel 2010 to Mash Up Data

Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

Microsoft Excel MVP Bill Jelen, that’s Mr. Excel for those in the know, take a great look at why you should be Using PowerPivot with Excel 2010 to Mash Up Data including how to join data from different sources in PowerPivot. If you’re not using PowerPivot with Excel 2010 and Dynamics GP now is the time to start looking at it.

Original article: https://blogs.msdn.microsoft.com/mvpawardprogram/2010/10/25/mvps-for-office-and-sharepoint-2010-using-powerpivot-with-excel-2010-to-mash-up-data/