Sunday 19 July 2015

Getting started with Excel VBA

Are you tired of doing commands in excel over and over again?
The same routine but you did it from the scratch?
Then you realized it's just a waste of time.
Microsoft Excel application is ultimately powerful tool when it comes to manipulating complex data.

Just to give you a heads up, you can do program in excel even though you have no background in programming. In this tutorial you will be able to learn the basic macro recording in excel and I will guide you all throughout this tutorial.
All you need to do is to be patient, practice more problems and of course your dedication.
If your boss give you a task in data management,don't grumble instead grab this opportunity. This is your stepping stone to learning excel vba.

Way back in 2010, I was not well-versed in excel as I am now. I just knew basic operator such as plus, minus, divide and multiply?Funny isn't it? As I browsed documents in our server, I usually saw formulas in the excel. Tremendously irritating, mind blowing, long formula. I didn't even bother to understand what are those alien functions.It's so happen that I had a Mechanical Engineer colleague at that time. He was so clever, smart and intelligent. Surely, he has high IQ. He did all documents in excel automated? I was surprised how come there's a program in excel? He showed it to me and I was curious enough to find what it was. I was eager to learn. I downloaded all ebook tutorials and studied it. What was most surprising is that I bought my own laptop just to learn excel. Yes, it's as crazy as it may sound but I spend my money for it. I studied every now and then until i get used to it. And, it's worth it a lot. Unfortunately, that guy resigned in our company. He turned over all automated documents to me. It's a big challenge for me and I accepted wholeheartedly. Blessing in disguise I had a super duper manager. She had all the ideas and was very particular when it comes to documentation. I made all her requests. Chances are, I learn more every time she gave me more tasks . After all, It's a good foundation for me.
To cut the story short, I learned excel with the help of my colleague and my boss.

In the next article, I will cater you to the step-by-step tutorial.