Excel Your VBA

Excel VBA or popularly known as Excel Macros is an incredibly powerful tool sitting on our computers which is never explored. VBA Macros has the potential to change the course of your career and make you the most sought-after person in the office.

"I myself being a finance profession would like to share an example where I automated a tedious and complex work paper which saved me more than 40 hours of painful glaring into the laptop screen and no one in the office was interested to take up this monthly activity. This activity involved analyzing 800 plus rows of data for each entity and we had more than 280 entities so you can understand how bad the things can get. I decided to spend few hours coding the logic using the excel macros to automate the task, this was the time well spent and I made excel do the things that were done manually which involved looking at the value in each cell and then passing the journal entry depending on the cell value. In this situation I just built the logic and Excel followed the same logic again and again till the time the code is repeated for all the entities without worrying even if I have many more entities or rows of data to analyze. I have coded and designed many more projects like this to save cost and time."