Fully Automated Dashboard with Excel VBA

By |February 19th, 2014|Categories: Excel & PowerPoint Blog, VBA Development|

Client Problem: A local airport operator seeked us out to create a fully automated dashboard using Excel VBA. The airport operator collects customer satisfaction surveys using Ipads and the results are stored in an Oracle database. They run weekly management [...]

Excel-based Expense tracking tool for Ship Management

By |October 3rd, 2013|Categories: Excel & PowerPoint Blog, VBA Development|

Client Problem: A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships. We [...]

A Trading Database in Excel

By |September 23rd, 2013|Categories: Excel & PowerPoint Blog, VBA Development|

A commodity trader approached us to create an Excel VBA database application to store and manage trading records. The objective of this app is to increase productivity of coal traders to create SELL trades, manage multiple BUY trades, and execute [...]

5 steps to create meaning charts & infographics in Excel

By |March 11th, 2012|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , , , , , |

Nathan Yau has given me alot to think about in his book "Visualize This" (book.flowingdata.com). I borrowed some ideas from him to create this long-styled infographic in Microsoft Excel.

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

Project Management: Why you always don’t have time.

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

In every project we undertake, we are always held hostage by two contraints: "time" and "quality". By "we", I mean you the sponsor and me, a contractor. Some would add "money" as another constraint but to me that's "time" in [...]

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

For Excel dashboards and powerpoint slide designs. Beautiful, imaginative, futuristic interfaces from Corning Glass.

By |February 11th, 2012|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, PointPoint in General|Tags: , |

This video from Corning Glass shows some cool concept technologies. Take a look at the beautiful and interactive computer interface designs. I can see some good ideas for dashboard designs and PowerPoint slides. http://www.youtube.com/watch?v=jZkHpNnXLB0& Some screen shots here: [...]

Google officially announces 10 billion app downloads in Excel

By |December 8th, 2011|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found a pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business [...]