Writing from Pakistan, imtiaz looks at how easy Excel Dashboarding in GP 2010 can be.
Excel Dashboarding in GP 2010
Reporting & BIExcel & OfficeGP 2010
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.