If you can measure it, you can definitely dashboard it!

By |May 7th, 2010|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

Dashboards can be used to show important KPIs (key performance indicators) for all sorts of industries and work processes. If you can measure it, you can definitely dashboard it! I've made a short list of useful KPIs along with the [...]

Klipfolio, a beautiful dashboard software. Free!

By |February 13th, 2010|Categories: Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I have always been a fan of Klipfolio (http://www.klipfolio.com). This tiny software features beautifully made dashboards that run on your desktop. It's useful and very clever. Download it, try it. It's a low risk way to see how dashboards can [...]

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

Where Microsoft Excel Fails

By |August 31st, 2009|Categories: Excel & PowerPoint Blog, Excel in General, Excel Training Courses|Tags: , |

Your company may have spent thousands of dollars on a fancy financial application but nothing beats the comfort and familarity of a spreadsheet. They are indispensible tools for budgeting and analysis in all sorts of corporate functions like human resource, [...]

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

Analysts don’t be shy. Get Noticed!

By |December 28th, 2008|Categories: Excel & PowerPoint Blog|Tags: |

Most business analysts aren't the outgoing types. They would prefer to work quietly in the background, hoping their attention to detail and accuracy to numbers are appreciated. I assure you those attributes are certainly valued, but it won't [...]

Problem of Labour Intensive Reporting in Excel

By |December 27th, 2008|Categories: Excel & PowerPoint Blog, Excel in General, Excel Training Courses|Tags: |

If you are a business analyst like I was, chances are you create and compile tons of reports in Excel. The business of generating reports is a business itself. The process of collecting your raw data and distilling it into [...]

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