Second Best Excel Dashboard of 2008

The Excel Dashboard that placed second best in the MicroCharts 2008 Excel Dashboard Competition was created by Jim Uden. His Outpatient Surgery Center Dashboard shows the metrics for the operations of a health care facility. Owned by a partnership that demands comprehensive reporting, the ambulatory center operations generate large volumes of data that must be digested and presented in a clear and concise manner.

We’ll examine the Excel dashboard itself in a moment, but I wanted to point out this dashboard received a special mention on account of the great documentation and project background that the developer provided with the dashboard. Take a look through this Dashboard Walk-through Document and you’ll be impressed as well. A nice document to emulate in our own dashboard projects, for sure.

Here is the screenshot of the Second Best Excel Dashboard of 2008. It’s a large screenshot, so please click on the image to bring it into full view.

Second best excel dashboard of 2008

We’ll pull some backgound material from that great project document that I mentioned earlier, so please join me in reading the rest of this post by clicking on the “read more” link below.

Continue reading

Customizing Ribbon Buttons for Excel 2007 Dashboards

Excel Dashboard Update:

Here are some recent pointers to resources that are very helpful to excel dashboard builders and users.

This is an excel sales dashboard template for you to download and reuse:

Sales Dashboard in Excel

This is a video on excel reporting and how a dashboard view can enhance excel reports:

This is the link for future info on these excel management reports:

http://budurl.com/exceldashboards

Building a dashboard with Excel 2007? Don’t forget to make use of the Excel 2007 ribbon. You can add your own custom tabs and buttons to the Excel ribbon using XML or RibbonX code. Thanks to Mike Alexander, author of Excel 2007 Dashboards & Reports For Dummies, there is a freeware Custom Button Builder for Excel 2007.

As this Excel 2007 Custom Ribbon Buttons video tutorial shows, the utility asks you to fill out a table of values and it provides a sample worksheet with your custom tabs/buttons (complete with icons and code that can call your macros).

Let’s have a look at some screenshots I captured from the video:

You can select from the billions of icons on your machine:

Excel 2007 Ribbon Icons - Datapig utility

Click to see more of this Excel 2007 Ribbon Customization utility:

Continue reading