Ministry of Manpower Unemployment Dashboard in Excel

By |September 17th, 2009|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

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, [...]

Magazine quality charts in Excel 2003

By |September 16th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

I'd like to show you how we run our Excel Charting courses in Aeternus. I promise that after attending our Excel Charting course, your Excel charting skills will definately go up by several notches. As an example, I plucked out [...]

Drive your business with a dashboard in Excel

By |August 30th, 2009|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

What if there is a dashboard that puts you in the driver seat of your business instead of being drowned by numbers? What if you can understand in a glance all the key business drivers of your business operation? What [...]

How to design a Sales Dashboard in Microsoft Excel

By |August 30th, 2009|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

Sales activity is the life blood for all businesses.  People who are responsible for sales must have their fingers on this vital pulse at all times. Traditionally, managers read sales reports in tables of numbers.  Imagine if all the sales [...]

A Straits Times chart in Microsoft Excel

By |July 12th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I came across a stock maket chart in Straits Times a couple of days ago. Just for the fun of it, I create one in Excel within 5 minutes :).

Create Executive Dashboards in Excel

By |December 25th, 2008|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

Most analysts know how to create charts in Excel. Getting them to look good is another matter. It's hard to imagine you can create magazine quality dashboards like these without dedicated software. Charts like these ARE done in Excel. Excel [...]

Dashboard ideas from Wall Street Journal

By |December 14th, 2008|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

The Wall Street Journal have a lot of good looking charts which I draw my dashboard ideas. You can hardly find any in BusinessWeek or Fortune nowadays.  The chart from WSJ below shows a complex story of European bank revenues [...]

Bullet chart in Excel

By |December 13th, 2008|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

A bullet chart is a relatively new kind of chart invented by Stephen Few.  I was pleasantly surprised to see one in a recent copy of  The Wall Street Journal.  A bullet chart looks like a column chart "within" a [...]

A magazine quality chart in Excel

By |December 12th, 2008|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I know the idea of creating beautiful charts in Excel seems unfamiliar, but I assure you Excel is a very capable platform to do so. At first sight, the chart below does not look like it comes from Excel. But [...]