Advertisements

How To… Create a Basic KPI Dashboard in Excel 2010

How To… Create a Basic KPI Dashboard in Excel 2010



Learn how to create a simple KPI (Key Performance Indicator) Dashboard using Conditional Formatting in Excel 2010. In this example you will learn how to add the colours of traffic lights to illustrate visually how a KPI is performing.

KPI Dashboards look great in presentations and reports!

source

Advertisements

27 thoughts on “How To… Create a Basic KPI Dashboard in Excel 2010

  1. Rick Darcy

    Solid. From a design view, my eyes went naturally down the columns. & believe the products should be delineated on the columns & not the rows. The visual of the kpis has more impact looking down the column of the product instead of across the product row as shown above. No big… Easy to swap data columns and rows. Thx

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*