I am a moderately advanced Excel user. This means “a dangerous person” for the IT department, but I like this daily fight, and Excel dashboards are among my preferred weapons. Let’s see how they can be used. Excel is the best tool for executive dashboard prototyping, because of
Read more →I am sure Albert Einstein was thinking of Excel dashboards when he said “everything should be made as simple as possible, but not simpler”. Let me tell you why. Demographic Dashboard: The VBA edition I published some time ago a first version of my Demographic Dashboard to
Read more →Bonavista Systems announced today an Excel Dashboard Competition. Participants stand a chance to win an iPhone, a workshop hosted by Stephen Few and a copy of Few’s “Information Dashboard Design”. Unlike other competitions, there is no data set. You just have to use Excel and MicroCharts, their
Read more →Do you need VBA to create an Excel dashboard? Our recent discussion clearly shows two lines of thought: a) you should use it because there are things you just can’t do without VBA and if you have access to a powerful tool you should put it to
Read more →Do you need VBA to create an Excel dashboard? Should you take the plunge and go beyond Excel formulas? Well, I think you should, but feel free to disagree. Charley Kyd, commenting on my review of his e-book, disagrees: As a consultant, I visited too many clients
Read more →If you google for “Excel dashboards”, 6 out of the first 10 results link to Charley Kyd’s ExcelUser website or some of his affiliates. MrExcel calls Charley Kyd “the king of Excel dashboards”. There is a good reason for that. Three years ago, Charley Kyd published an
Read more →Excel is a great (but underrated) BI tool. Several BI vendors gave up fighting it and offer Excel add-ins as front-ends for their BI solutions. So, if you want to create a dashboard you should consider Excel, since it really offers better functionalities than many other applications
Read more →This is the last post in a series where I examined the possibility of creating a Crystal Xcelsius dashboard using my Demographic Dashboard as a benchmark. I’ll discuss here my overall conclusions. I must say from the start that I am very disappointed. Let’s start by the
Read more →
Recent Comments