Excel and GP are a Dynamic Duo as per Mark Polino. He has presented extensively on this before -
The Microsoft Dynamics GP Team is currently carrying out a Business Intelligence Investigation. Go check it out and give your feedback.
The Microsoft Dynamics GP team, are hoping to provide some ideas on how you can use Microsoft
technologies to improve your business intelligence experience with the data
from your Dynamics GP database. To that end, we are creating some example
dashboards that you can use with GP, and looking for feedback from you on your
business intelligence needs.