fbpx
Search
Close this search box.

Health-care Dashboard in Excel [Dashboard Week]

Share

Facebook
Twitter
LinkedIn

This post is part of Excel Dashboard Week

As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto.

Health-care Dashboard Snapshot:

Health-care Dashboard in Excel Snapshot

[Click here to view large version]

How is this Dashboard Made? – An Overview:

Alberto put together an excellent dashboard to visualize hospital performance and understand what is going on.

Here is what I like about the dashboard:

What can be improved in this dashboard?

  • Formulas: Alberto used IF formulas to fetch the values for each half-year (semestre). Instead using INDEX or OFFSET would make his job simpler.
  • Hardcoded targets: The target values for each metric are hard-coded. Instead, they should be put in a separate table, just like actual data.
  • Solid Fill bars: Instead of using gradient fill data bars, it is better to use solid fill bars thru in-cell charts.

How is the dashboard constructed? – An overview Video:

I have made a short video to explain this dashboard to you. Watch it to understand how this dashboard is made and how you can use similar techniques.

[Watch the video on Youtube]

Download the Health-care Dashboard Workbook

Click here to download the excel workbook for the Health-care Dashboard.

Thank you Alberto

I am really thankful to Alberto for taking time to share this file with us so we all can learn from his work.

If you enjoy this Dashboard, say thanks to Alberto.

Contribute to Excel Dashboard Week:

Share dashboard tips, snapshots, excel workbooks or links by filling out this simple online form. Go ahead and share what you got so that we all can learn from each other and become awesome.

Learn How to Make Excel Dashboards:

If you wish to learn how to make Excel Dashboards, join my Excel School online training program. We have 4 completed dashboard tutorials that teach you how to make a KPI dashboard, a Sales dashboard, a Business dashboard and a Website dashboard, all using MS Excel.

Click here to join Excel School program.

Join Excel School Online Training program by Chandoo to learn Excel Dashboards

Additional Resources:

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.

5 Responses to “Health-care Dashboard in Excel [Dashboard Week]”

  1. Busymanjohn says:

    This is nice layout and format, I can see how management would be able to get a lot of information from this, especially with the alerts for focus areas, the use of alerts seem key to the data within this Dashboard and that is what management want to see, what areas need focus right now ( so enables quicker decision making and less analysing data ). Well done Alberto.

  2. Aislan says:

    Where can I setup or see the "goals" for each topic on this spreadsheet?
    Regards,
    Aislan

  3. Aman says:

    This dashboard is great however I am unable to save onto my desktop

    Thanks

    Aman

Leave a Reply