Sunday, December 13, 2009

For everyone who is using excel, here's a little advice

For everyone who is using excel, here's a little advice from

I’m sorry to break this to you, but if you spend your time analyzing data and Excel is your primary tool, then you must use VBA. I’m not telling you should be a programmer, far from it. But you should be able to record a macro and make some simple tweaks. There are many repetitive tasks that can easily done using three lines of code.

Unfortunately lost the source of the quote but very true.

Here's the learning stairs route that I can suggest for anyone wanting to master excel.

  1. Learn the 50 common basic formulae.
  2. Learn the useful shortcuts of excel
  3. Then go for recording small macros!
  4. Then start tweaking it.
  5. Next read more about VBA and apply it in editing your macro.
  6. After this to excel help file and pour over it's documentation.


This are the steps. There is no direct lift to VBA programming. Learn this via this steps you will climb much faster.


Good luck!

Search This Blog