Excel Dashboard Tutorials

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

Excel Dashboard Update:

All excel users are encouraged to watch the new Excel Dashboard Tutorial.  It’s a 65 minute lesson on how to design and construct an excel dashboard.

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