Excel

Salam,

EXCEL ... This is an interesting piece of software.

Dibuat oleh Uncle Microsoft, hasil perahan idea Abang Bill Gates etc.

Why did I say its interesting ?

Its interesting bcoz:

It can show you a quick page of lines across a screen..... ha ha ... not so terror la this one.

To the beginners:

• you can quickly have sheets with many self calculated totals i.e. autosum function

• its has many built-in functions that will speed-up your work
• you can set-up a quick What-Ifs scenarios of your various calculations and projections
• its useful for almost everybody - students, accountants lawyers

To the advance users:

• it can be programmed to create self styled tools to impress ........ your boss is a great candidate
• eliminate key-in error in that huge data compiling task that you're doing
• save time ..... you save time when you let the codes do it for you
• And down here is just a sample how I manipulate those codes to do the dirty work for me and saving my shoulder from that ache...
  

In the sample above, what I've coded is:

• Excel to open my data file from designated folders
• Extract data from the opened file
• put it into my pre-prepared template
• process the data
• and give me results

This is actually part of my month end routine, to process about 300 over files, and this can be completed in just about 3 to 5 minutes.

So, if you think this is something useful and great that you want to know more.... search for Excel VBA in your search engine.

The result page should be able to give you more insights to what it is all about.

For a start you may read these article .....
http://www.math.vu.nl/obp/edu/project-obp/VBA-intro.pdf

If you want to buy a book.... consider books from Mr Walkenbach...
http://spreadsheetpage.com/

There you have it. Pick that heavy butt from that lazy chair and learn something new today....


OK then.....