Series: Prepare Dashboard Using Excel

“A dasboard is a collection of data and/or graphic elements that allow the reader to make better sense of what’s taking place.”

That’s my definition and I’m sticking to it!!!

Often times authors will make this definition more complex. A dashboard no matter how complicated or sophisticated, is in the end, just a compilation of data and possibly, graphics. What they do……well they allow the reader “to make more sense of what’s taking place”. Special emphasis on “more sense”. A dashboard will not make conclusions and decision for the reader. The reader HAS to have an informed idea of what he’s looking at…..and therefore be able to distinguish between the exception and the norm.

In this series of posts, I’ll walk you through a step wise process on how to create a “world class’ dashboard. With the time available to me, I guess it will maybe take me about a month to complete the series but I think it’ll be worthwhile putting all the things together. Needless to say, all of this has been done before, by people brighter than me and in others ways than I propose. As Newton once said, “If I can see further than anyone else, it is only because I am standing on the shoulders of giants”. For the time being, I’ll be happy just to stand on their shoulders !

Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


Keep up with the latest stories - Delivered right to your inbox


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel