Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

Creating KPI Dashboards using Excel – Part 1

What are KPI Dashboards?

KPI stands for Key Performance Indicator. KPIs are very common in many business settings to keep track of performance. As the name suggests, KPI Dashboards help us visualize various KPIs. The original dashboard (shown below) is designed by Robert Mundigl (of clearlyandsimply.com) for chandoo.org in 2008. In this and next few lessons, we will learn how to create similar dashboard using MS Excel.

KPI Dashboard - Snapshot

What is in this lesson?

  • Introduction to KPI Dashboards
  • Examining Original Dashboard Design
  • Possible enhancements to dashboard in Excel 2007 and 2010
  • Understanding in-cell charts
  • Our KPI Dashboard – Step 1
  • Using Radio Buttons in Dashboards & Charts
  • Understanding the sorting problem
  • Implementing Dashboard Sort
  • Conclusions and What happens in next part?

Continue reading “Creating KPI Dashboards using Excel – Part 1”

Dashboard Design Tips & Tricks

What is in this lesson?

  • Dashboard Design Principles
    • MVC Rule
    • 4 Important Design Principles
    • 3 Examples of Well Designed Dashboards
    • 6 Dashboard Layout Ideas
    • Colors, Fonts & Other Design Elements
  • Excel Tips & Secrets for better Dashboards
    • Using Shapes
    • Conditional formatting
    • Tables
    • Freeze Panes
    • Hiding columns / rows
    • Hyperlinks
    • About Box / contact details
    • Going Beyond Excel
  • Closing Thoughts on Effective Dashboard Design

Continue reading “Dashboard Design Tips & Tricks”