Big Data skills mean Big Jobs and Salaries?

By |February 28th, 2012|Categories: Excel & PowerPoint Blog, Excel in General|Tags: , , , , |

Try this in any jobs website like Monster.com. Search for any "data" related jobs and you find a huge number of openings even in tough times like these! In fact A quick search of other popular job posting sites shows [...]

The strengths of Excel vs Access

By |February 23rd, 2012|Categories: Consultancy Blog, Excel & PowerPoint Blog, Excel in General|Tags: , , |

As development consultants, we often get the question: "Should we do this project in Access or Excel?". We can certainly see that is this is valid question to ponder in many business oriented projects that have database and reporting needs. [...]

What is an Independent Contractor?

By |February 12th, 2012|Categories: Consultancy Blog, Excel & PowerPoint Blog, Excel in General, PointPoint in General|Tags: , , , , |

Having worked as an independent contractor for Excel VBA development for a number of years, I would like to share some useful expereinces for people who drop by my site and prospective clients. Firstly, I define an independent contractor as [...]

Automate Excel with VBA programming to reduce errors

By |May 7th, 2011|Categories: Excel & PowerPoint Blog, Excel in General|Tags: , |

Having worked as a business analyst I always have this fear of undiscovered errors when I present my Excel reports to my management. Recently, while working on an Excel project, I uncovered about 10 cells of calculation errors in a [...]

Excel 2010. A quick review

By |September 13th, 2009|Categories: Excel & PowerPoint Blog, Excel in General|Tags: |

Just like driving a new car, I will report the new facelifts Microsoft has done to this spreadsheet program! Zippy startup and the familar Ribbon The Excel 2010 starts up quickly and I finally saw how Excel 2010 looks like. [...]

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

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

Work with multiple Excel worksheets at the same time

By |December 20th, 2008|Categories: Excel & PowerPoint Blog, Excel in General|Tags: |

Imagine when you open a workbook, multiple windows will be opened and each window allows you to work on 1 worksheet and they get arranged nicely across a large LCD monitor.  Sounds like a dream?  Well this is easy to [...]