Mohammad Daoud like my new book Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013.
Mohammad R. Daoud: Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
Reporting & BIExcel & OfficeGP 2013
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.