The Excel team has a great new post on the Top 5 Ways PowerPivot Helps Excel Pros . These tips work really well for Excel pros who use Dynamics GP too!
Top 5 Ways PowerPivot Helps Excel Pros
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.