Creating Performance Dashboards in Excel

I have met many managers having various Excel reports that they need to analyse periodically so as to make decisions on the way forward to improve performance. This can be quite a laborious process depending on how it is performed. Excel is a very powerful tool and is able to make this process more efficient. With the use of micro-graphs and conditional formatting, it is possible to develope a one pager that gives the manager a comprehensive view of the key performance indicators. This can easily be placed into powerpoint for a presentation.