Example of a Hopelessly Complicated Dashboard

Dashboards are at their best when they are outrageously simple. Their “at-a-glance” nature takes advantage of universal human perception into order to bring instant understanding of data trends.

This example is outrageously complicated instead of simple. Sorry, but I would hate to have to attempt to understand this particular excel dashboard. See if you can make heads or tails out of it.

Conditional Formatting in Excel

I was working in Microsoft Excel and got a bit stuck on an issue with a formula, so I immediately went in search of the answer from my favorite Excel teaching resource, chandoo.org. I did find the answer, but while I was there, a very helpful article caught my eye so I thought I’d pass it along.

Conditional formatting in Excel is one of those foundational techniques that you must employ when creating business intelligence dashboards with excel. I’m talking about coloring certain cells a different color depending upon the value of that cell value.

For example:

Conditional Formatting Excel

Click here to read exactly how to accomplish this effect. It’s very important that you master it as you’ll use it over and over in your work.

Format cells with conditional formatting

And be sure to check out Chandoo’s School for Excel and his modules on Excel Dashboards.

If you are interested in using Excel for Dashboards, click on this banner to learn more about Excel School for Dashboards:

Excel School for Dashboards

 

Excel Dashboard Classes in Australia

Calling all Dashboard Spy readers in Australia:

Chandoo, master excel dashboarder and guru, will be conducting a series of Advanced Excel Dashboard Masterclasses in Australia this coming May and June.

If you are close to Brisbane, Sydney, Melbourne, Canberra or Perth, take this chance to brush up on your dashboard skills.

Info here:

Australian Excel Dashboard Master Classes by Chandoo

The two day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Excel Dashboards.

In this masterclass you will learn:

Day1: Our first dashboard in Excel

  • Excel formulas for dashboards
  • Applying advanced conditional formatting for dashboards
  • Building our first dashboard – hands-on exercise

Day 2: Advanced dashboard skills

  • Selecting right charts for any situation
  • Enhancing dashboards with Excel 2010 – sparklines, slicers
  • Customizing Excel charts – top 5 problems
  • Building our second dashboard – hands-on exercise
  • Q&A

Not in Australia?

Be sure to check out Chandoo’s School for Excel and his modules on Excel Dashboards.

If you are interested in using Excel for Dashboards, click on this banner to learn more about Excel School for Dashboards:

Excel School for Dashboards