Excel Dashboard Tutorials

Posted by Dashboard Spy | Excel Dashboards | Wednesday 15 October 2008 8:49 pm

Excel for dashboards? Yes, Microsoft Excel is an excellent starting point for business intelligence visualization. It’s everywhere in the enterprise and is a good way to start an organization down the dashboard path.

Chandoo, the Pointy Haired Dilbert, consistently offers amazing Excel Dashboarding Tips over at his blog at chandoo.org. He has a set of 4 great excel dashboard tutorials contributed by one of his faithful readers, Robert from Munich. These excel dashboard lessons are great and come with downloadable excel dashboard worksheets.

Take a look at these screenshots and visit Chandoo for the corresponding lessons.

Post 1 – Implementing a Scrolling Excel Dashboard Table

Create a scrolling dashboard portlet in excel

Post 2 – Add Sorting to the Excel Dashboard

Sort an Excel Dashboard Table

Post 3 – Add Percentile Information to the Excel Dashboard

Excel Dashboards with Quartiles

Post 4 – Excel Dashboards for Data Visualization

Dashboards in Excel with Microcharts for Data Visualization

Very nice job Robert and Chandoo. Thanks!

The Dashboard Spy

excel dashboard template

4 Comments »

  1. Pingback by 2008 Best Excel Dashboard — October 15, 2008 @ 11:32 pm

    [...] 2 of Dashboards by Example for more Excel Dashboards. See this post on Excel Dashboard Tutorials: Excel Dashboards [...]

  2. Comment by Chandoo — October 23, 2008 @ 12:45 pm

    Hi Admin…

    Thanks for featuring the KPI dashboard posts here.

  3. Comment by Lister — November 15, 2009 @ 10:42 pm

    Very Useful, Thanks

  4. Comment by bk — January 28, 2010 @ 9:22 am

    Hi there actually i m a novice and have trouble in creating ur scrolling dashboard can u kindly plz suggest as i could not understand how to insert scroll bar and code language plz mail me will be highly appreciative
    Ps: I am using excel 2007

RSS feed for comments on this post. TrackBack URI

Leave a comment