fbpx
Search
Close this search box.

Announcing Dashboard Week – Submit your entries now!

Share

Facebook
Twitter
LinkedIn

Hello there,

I am glad to announce this week (21-25 March, 2011) as Dashboard Week on Chandoo.org

Excel Dashboard Week - Chandoo.org

What happens in Dashboard Week?

As you can guess, during this week, I will be posting exclusively about Excel Dashboards. This is the tentative agenda:

Monday:

  • Announcement & Survey

Tuesday:

  • Health-care Dashboard [shared by Alberto]
  • Customer Service Dashboard [shared by Mara]
  • Executive Review Dashboard [shared by John]

Wednesday:

  • KPI Dashboard – Revisited

Thursday:

  • Making Excel Dashboards – Recommended Resources

Friday:

  • Your Tips & Contributions (more on this below)

How can you Contribute for Dashboard Week?

Obviously, doing a dashboard week is a mammoth task. I need your help 🙂

You can contribute tips, screen-shots, excel workbooks or links that I can share with our readers on Friday (25th March).

(In order to share screen-shots, images, files you must first upload them to a public file sharing website like skydrive.live.com)

Click here to send your tips & files for Dashboard Week

Rules for Contribution:

  1. Please share Excel files only if you are the owner of them (ie you made or manage them)
  2. You can share images / snapshots of dashboards even if you do not own them. Make sure you mention the source if required.
  3. Please submit your entries before March 25th.

So go ahead and contribute to the Dashboard Week.

Learn How to make Excel Dashboards - Join Excel School

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

10 Responses to “Announcing Dashboard Week – Submit your entries now!”

  1. Hui... says:

    I'd like to nominate a 4 color traffic light technique, that will work in All Excel Versions and you can customise the colors to suit yourself.
    Instructions here: http://chandoo.org/forums/topic/mixing-icon-sets-in-conditional-formatting-and-only-using-one-icon-from-set-2

  2. Hui... says:

    I'd also like to nominate my Excel Age dashboard which I contributed to Chandoo's Excel Age Survey http://chandoo.org/wp/2011/02/25/excel-age-survey-results/

    The dashboard is available for download from:
    http://img.chandoo.org/d/My-Excel-Age-hui.xlsb

  3. Barry says:

    I want to submit an Excel/VBA dashboard that follows the style/user interface of QlikView:

    http://www.qlikfix.com/2011/03/16/excel-and-vba-the-poor-mans-qlikview/

  4. Prem Sivakanthan says:

    Woohoo! This is going to be an awesome week, how exciting. I've just started making a new dashboard yesterday, this will give me the motivation to finish it by the end of the week! Anyway here are a couple of ones I have developed in the past. Probably my fav tip to share is to create a super fast dynamic range with index (free plug for Daniel Ferry's EHA). Use this in a named formula, so it can be used in a chart, and hey presto - no need to update the source data every month! 🙂

  5. [...] blogera koji se pojavio u zadnjih nekoliko godina ovaj tjedan 21. – 25. 3.) na svom blogu ima Dashboard Week. U to vrijeme ekskluzivno ?e pisati samo o izradi dashboarda u Excelu uz prikaze i objaÅ¡njenja [...]

  6. [...] you’re interested in Excel Dashboards, Chandoo.org is having a dashboard week from March 21st to March 25th, 2011 [...]

  7. [...] Dashboard Week at Chandoo’s Blog, so head over there for more [...]

  8. Prem Beejan says:

    Hi Chandoo
    I have posted a screen on a dashboard at http://cid-75f325168218cdd9.office.live.com/view.aspx/.Public/Dashboard%5E_prem.xlsx
    This is a stock market trading model which I built in 2005 using Excel 2003. I will rebuild all my models by applying the new techniques I have learnt from you and all the friends.

    There are 6 charts with price and volume indicators in different time frames. My trades are shown on the line chart (blue for buy and red for sell) over the 2 yr and 60-day horizon. My last 7 trades for the security is pulled from my trading details which record all trades. From a droplist, I can choose any of the securities in my favourite (some 60) or from my portfolio set ( some 350 securities which I have identified as trackable. The daily price update is save in a single file, which contains all the securities (some 1850). A data file extracts the chosen securities and my model brings in the price-volume data at the click of the mouse from a drop list.
    My target was to decide to buy or sell within 3 seconds and I have been doing this for quite long. The dashboard also computes statistical data, update the links to the company's website and registry, etc

  9. Rush says:

    Hi Chandoo - Learning a lot about graphing from your site - someday when I have time I will take a class with you. In the meantime - I am looking for a bigger picture or a template of the chart you use in the headline for Dashboard Week (sorry I am late to the party by a few months). The graph with the pink to red to yellow to green to gray? Can you tell me which article that dashboard is referenced?

Leave a Reply