Matt Grisham demonstrates Getting in Control of Your Excel Dashboards: Combining Cube Functions and Form Controls.
Getting in Control of Your Excel Dashboards: Combining Cube Functions and Form Controls | Dynamics Care Services
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.