Scorecards using MS Exel

[Sayan Ghosh]

Hi,

I am looking for some decent walkthroughs on creating scorecards using
Excel. I have seen some samples on the net and they don't focus much on the
details of implementation. Would appreciate if someone can point me to some
detailed walkthroughs on this.

 

[Ed Ferrero]

Hi Sayan,

I am looking for some decent walkthroughs on creating scorecards using
Excel. I have seen some samples on the net and they don't focus much on
the
details of implementation. Would appreciate if someone can point me to
some
detailed walkthroughs on this.

What sort of scorecards?

Simple list type like darts? Golf? Business scorecards?

The more specific you can be, the better help you are likely to receive
here.

Ed Ferrero
www.edferrero.com

 

[Sayan Ghosh]

Hi Ed and Everyone,

Sorry for the missing pieces. Truly speaking I am looking for creating
Business Scorecards and Dashboards using MS Excel. In fact, the focus is even
more towards Dashboards. Here are a few links I have found on the net -
http://charts.jorgecamoes.com/how-to-create-excel-dashboard-lookup/
http://charts.jorgecamoes.com/how-to-create-an-excel-dashboard/
http://www.exceluser.com/dash/startdash.htm
http://www.excelling.it/excel/dashboard_en.asp

These are very informative in terms of "what" but don't provide a working
walkthrough ("how") which can be followed to get oneself started. I am
actually looking for such a walkthrough and any pointers would be much
appreciated.

 

[Ed Ferrero]

Hi Sayan,

Sorry for the missing pieces. Truly speaking I am looking for creating
Business Scorecards and Dashboards using MS Excel. In fact, the focus is
even
more towards Dashboards. Here are a few links I have found on the net -
http://charts.jorgecamoes.com/how-to-create-excel-dashboard-lookup/
http://charts.jorgecamoes.com/how-to-create-an-excel-dashboard/
http://www.exceluser.com/dash/startdash.htm
http://www.excelling.it/excel/dashboard_en.asp

What you will find on the web are pointers on techniques for building your
own dashboard components. Complete dashboards that are any good will not be
available for free. Exceluser.com is a pretty good place to get started with
dahboards. My own site has free tutorials on some useful techniques - see
the Excel Database tutorial, as well as a Balanced Scorecard workbook that
you can buy.

Ed Ferrero
www.edferrero.com