Singapore Management University (SMU) recently published in The Straits Times the results of a customer satisfaction survey which indexes the customer satisfaction levels of different companies and different industries. A copy of the news report is presented below. Consider this, if you only have 5 minutes to digest the figures in the report, what conclusions would you be able to derive?
If you ask me, I would present the results differently, such that they communicate the key messages with maximum impact in those 5 minutes. The same criteria can be applied when you are preparing a business report for your management. It is important that you prepare a business report that allows your manager(s) to draw the necessary conclusions in the quickest time. To show you what I mean, I have compiled the customer satisfaction indexes from the Straits Times report using Excel and present them in this report with a table and 3 charts. The first table and chart are as follows:
Contrary to what many business managers would expect, Excel CAN create impactful professional looking charts. You DON'T have to use macros. All you need is some in-depth knowledge of Excel functions, formulas, and a few tricks, and the following can happen:
Here is what Raul from Philippines say about report:
Thanks for sharing the Business report with Excel. It was an eye opener for me that such report can be prepared using Excel. The presentation is clean and logical that enhance quick understanding of the facts through graph or figures in a the form of bar charts. I am wondering how it was done it only shows my limited knowledge regarding Excel. Was it done with excel visual basic programming? Was it prepared by using just the Excel functions and formulas and wizards? It is really worthwhile learning how to prepare such report for the appreciation of management.
My answer to Raul's questions:
The report is prepared using existing Excel functions, formulas and wizards that are readily available to all Excel users. No macro or VBA programming is required for this report.
To see this smart business report using Excel, request for it now!
I want a FREE copy of the Customer Satisfaction Index Report created using Excel.
P.S. Your e-mail address will never be sold, shared or rented.
Remember: Your privacy is safe and you may stop further mailings at any time.
PS: We will send you a confirmation email to make sure that it is really you who wish to sign up for the challenge. Do remember to whitelist our email address to make sure that our emails are delivered to your inbox.