Top 4 mistakes of Excel Charts

By |September 1st, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

As you know, an Excel chart can make complex relationships much clearer than words and numbers can. But more often than not, most of us stumble to achieve this. How many times have we come across charts that confuses more [...]

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

Microsoft Excel Training Course for Human Resource

By |April 21st, 2009|Categories: Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

Excel is a powerful tool that allows you to analyze data and create various reports for decision making. Being Excel savvy is an invaluable if not necessary skill to be a successful HR professional. Further more, it is no longer [...]

Develop Robust Excel Spreadsheets with Checks & Controls

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

The use of spreadsheets has crept into daily business operations at the highest levels. Given that many spreadsheets are developed by self taught professionals, there is a likelihood that many critical spreadsheets (eg. balance sheets, portfolio investment models, risk analysis [...]

Control your Excel spreadsheets!

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

Consider these shocking stories on how a simple Excel error can cause you sleepless nights: A cut and paste error cost TransAlta $24 mil when it underbid an electricity supply contract. A missing minus sign caused Fidelity Magellan Fund to [...]

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