Ministry of Manpower Unemployment Dashboard in Excel

MOM’s website (www.mom.gov.sg) contains a wealth of labor data. An example is on unemployment rates in Singapore. I took two sets of data: Unemployment Rate (Seasonally Adjusted) & Resident Long-Term Unemployment Rate (Non-Seasonally Adjusted).

They look like this. As individual charts, they may not present a strong overall picture.

Ministry of Manpower Unemployment charts

I redesigned the presentation into a dashboard using Excel 2003. You can download a copy here: Excel Productivity Cafe Files.

The effect of a well designed dashboard is you are able to survey more data in a glance, and make quicker assessments for faster decisions. I did this dashboard in 20mins, you can do it too.


Learn more about Creating Dashboards in Excel.

Related posts:

  1. Drive your business with a dashboard in Excel Share What if there is a dashboard that puts you in the driver seat of your business instead of being drowned by numbers? What if...
  2. How to design a Sales Dashboard in Microsoft Excel ShareSales activity is the life blood for all businesses.  People who are responsible for sales must have their fingers on this vital pulse at all...
  3. If you can measure it, you can definitely dashboard it! ShareDashboards can be used to show important KPIs (key performance indicators) for all sorts of industries and work processes. If you can measure it, you...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

trust

How to trust an Excel VBA application?

Share A trust worthy person should be: 1. Honest & true. 2. The person is honest and true in many different situations. 3.The person is honest and true over a long period of time. Trusting an Excel VBA application is like trusting a person. When you trust a person, you have an expectation that this [...]

Continue Reading

Just as I was about to get used to Excel 2010. Now the game changed again!

Office 15, Word 15, Excel 15 & PowerPoint 15 screenshots.

ShareIt didn’t seem too long ago that Microsoft released Office 2010 (Office 14) upon us. Continuing the Windows 8 momentum we soon will hear about Office version 15! Here’s what going to happen. According to a Bloomberg report, Microsoft plans to finish up all work on Windows 8 by summer 2012 and release the new [...]

Continue Reading

Connect with us on Social Media

Twitter
Discussion forum, directions to office, new ideas, discounts and offers.

Any questions?

  1. (valid email required)
  2. (required)