Google officially announces 10 billion app downloads in Excel

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found this pretty looking 3D column chart.

I have never been convinced that 3D charts are good enough for serious business use. But this chart made me think again. The exponential growth trend jumped at me. Critical milestones were highlighted in rounded textboxes which were freindly to my eyes. I’m not interested in the specifics but I got the strong message that Android is growing strongly from the chart.

I recreated this chart in Excel using a 3D column chart type.

Use the following Excel 3D Rotation settings and with the right colours, this chart can be done quite easily.

To learn more about how to create beautiful charts like these in Microsoft Excel, check out this workshop: Beautiful Excel Charts

From the Global Financial Crisis to Microsoft Excel VBA.

Thomas Friedman a New York Times columnist claimed that he has a theory of everything. In that brilliantly short article, he observed that for decades the middle class had easy credit, easy jobs and easy entitlements. He argued that globalisation and IT have taken these away because brain power became more available and cheaper and people with the right skills gets further ahead.

What he wrote were stuff I learned during the Asian crisis. Jobs were scarce during those years. Competition was tough. University graduates working in coffeeshops made the news. Like what Friedman wrote “employers are finding it easier, cheaper and more necessary than ever to replace labor with machines, computers, robots and talented foreign workers… Good jobs do exist, but they require more education or technical skills.”

I remembered back then, I had the job of automating business reporting with Excel VBA and my colleagues feared that I was taking their work away. Reading these recent events was both nostalgic and foreboding. It is more important than ever before to come up with better ideas, learn more and improve how we work with IT. The rest of the world is increasingly impatient for you to be remarkable.

Learn more about Microsoft Excel VBA programming here.

Your own American Deficit/Debt Chart in Microsoft Excel

In the United States Congress there are currently a number of disagreements between Democrats and Republicans regarding the United States debt. On August 2, 2011, President Barack Obama signed into law the Budget Control Act of 2011, averting a possible financial default. This was the background story of this beautifully rendered chart of the USA public debt in the August 2011 issue of the TIME magazine.

Follow these steps to create your own American Deficit chart in Microsoft Excel.
1. Go to the U.S. Bureau of Public Debt portal to extract the data set.

2. Punch in a start and end date. The portal will generate a list of figures.
3. Select and copy the data set from the web page.
4. In Microsoft Excel, paste the figures as Unicode else it will not work properly. Click in Microsoft Excel: Home Ribbon->Paste->Paste Special->Unicode.
5. Plot out the figures as an Excel chart.

A new data portal www.data.gov.sg

The Singapore government has launched a new portal last month: www.data.gov.sg. This data treasure trove stores more than 5000 sets of data from 50 ministries and public agencies.

Totally free for everyone, you can see data sets from Finance, Health, Education,Manpower ministries, Monetary Authority of Singapore among many others. This is excellent news for app developers looking for reliable public data to use!

Beautiful Forms in Microsoft Excel. More examples.

Here are more examples for form designs in Microsoft Excel.
See pic below. The use of bold fonts in appropriate columns make this form easy to read at a glance. The simple yellow bar on the left highlights the important figures.

See pic below. With careful layout of columns and rows, this form can be replicated in Excel.

See pic below. A simple design that can be created with cell coloring in Excel.

Beautiful forms in Microsoft Excel Example

Entering data on thoughtfully and beautifully designed forms can be a pleasure! Look at these examples.

I loved this form because:

Bold and clear layout that is easy on the eye.

The form explained the underlying work process clearly at the beginning.

Straightforward and clearly marked sections that is easy to understand.

Instructions on how to submit the form was provided right at the end. The user wont have scan and search for it.

It makes me wonder why HR forms always seems more complicated and tedious than they actually are? Human resource folks please take a good look at this!

Here’s another beautiful form example.

Beautiful forms in Microsoft Excel

Entering data is one of the most common tasks performed in Microsoft Excel. That must the reason that Microsoft Excel 2007 has provided thousands of downloadable form templates. You can see them by clicking on the Office Button->New.

Sadly, few of them inspires me enough to take them seriously. While all of them are functional, none of them looked good. This is a typical ugly example:

I feel that entry forms in Microsoft Excel doesn’t have to be all clinical in boring blues and black. Why not inspire your users with good ideas like brighter colours and eye-freindly layouts. Think deeper into the entry process that makes business sense like highlighting useful instructions and highlight error entries. Think of creative ways to cut out the weariness of repeative entries.

There are many hard copy examples I can find which can be translated into Excel! Here are some. I will create a new blog section devoted to this topic. Do check in regularly.

Singapore General Election Results 2011 Microsoft Excel Chart-Part2

This is an alternative interpretation of my previous Excel chart on the 2011 Singapore General Election results by James C Lee.

Below was my original version in a previous post.

In many ways, it is a better version compared to mine. The tight Excel chart was able to show with clarity specific election results between the People’s Action Party with the various opposition in all 26 constituencies. The colour used in the chart was in sync with the chart title which enhanced clarity. The best part of this chart was at a glance, it could tell which side was the clear winner, and when studied in detail each row was a blow by blow account of the election results.

Singapore General Election Results 2011 in an Excel Chart

This is an Excel chart to summarise the lastest election results of Singapore. The People’s Action Party has won almost every contested area in Singapore. They secured 81 out of 87 seats against the total opposition.  Total popular vote share of PAP: 60.1%

Click to see the full pic:

Download an animated powerpoint version here.

Automate Excel with VBA programming to reduce errors

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 forecasting spreadsheet. The executive manually compiles this forecast for a logistic oriented company. He needs to manually calculate 30-50 values using pivot tables and copy them into an Excel report template.

Studies have shown that Excel spreadsheet errors are extremely common. Humans appear to have an error rate floor (ERF) that exists even when they are working very carefully. Everyone has a similar error rate floor, and working more carefully can decrease one’s error rate only modestly. Not a very comforting thought when you are working on an important spreadsheet.

My strongest advice to clients is to automate the most tedious and error prone parts of your Excel spreadsheets to reduce such calculation errors. I always argued that such revamped Excel application can be proven to give productivity gains. The calculated savings will be a key decision factor in whether you find it worthwhile to go forward in this project. Key variables in estimating cost of your present reporting process can include: (reporting freq per month) * (time needed) * (no of people involved) * (potential costs in reporting errors). The future gains will certainly exceed the present costs.

Next Page »