Thursday, June 21, 2007

Multiple Sources

It has recently occured to me that the reason why many people are still using Excel for their work despite the availability of powerful systems in their work place. It is because Excel provide a common platform for the systems to communicate with each other and the linking can be handled by any non-technical users. The interface for these system to export data in the csv and text format means Excel is able to format these files and place in an Excel worksheet. When this is done, they are able to link the files from mulitple sources together to create the report they want.

And these reports cannot be prepared during system planning stage because the need arises as the business environment changes. Or it could be due to budget constrains and/even system constrains.

Therefore, Excel comes in handy as a tool to merge the data from theses systems together.

No comments: