Excel Dashboards: do you need VBA?

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 where an Excel user had written some macros, … Read more

Dashboard design: we need best practices for best practices

The other day I was reading Dundas’ whitepaper “Best Practices for Building Digital Dashboards” (PDF) [fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][update: this whitepaper is no longer available] and you know what? What they say makes a lot … Read more

Jon Peltier's long waited blog

Jon Peltier’s site is usually my first stop when I want to find a solution for an Excel chart problem. His site is one of the best resources for add-ins, tips, tricks and “impossible charts”. Now he’s sharing his expertise with us in his new blog. So if you want to go beyond basic Excel … Read more

10 tips to improve your Excel dashboard

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 for a fraction of the cost and development … Read more