The Project Botticelli website came up with another very nice post on how to make dashboards in Excel. You can find it here.
The instruction video is made by Carmel Gunn. She is a Data Management Specialist in Dublin, specialising in enterprise business intelligence. Let her show you Excel as an enterprise-grade BI client. She gives perfect examples which are very useful for iqbs BI as well.