What are VBAs/macros? Do you use them a lot in IB/PE? Is it worth learning? I'm new to excel, so please educate me on the value of knowing this. From the little I know, it seems like too much for what you get out of it.
Bookmark/Search this post with:
I am familiar with macros
I am familiar with macros (used for automating repetitive tasks) and occasionally use them but not so much with VBAs. Have yet to hear anyone mention anything about VBAs on the job so I don't think I am missing out on much. I agree, seems like it is not worth the effort to learn. Most banks have some sort of program like DealMaven with Excel add-ins that can make modeling a lot easier. If you don't have one of those you can create macros to do a lot of the same tasks. I also found a site (maybe from WSO?) that has some handy excel add-ins if you don't have a DealMaven type program.
http://www.matthodan.com/projects.php
VBA... is Visual Basic for
VBA... is Visual Basic for Applications, basically a programing language for excel & other Office applications.
VBA is the same as a macro... When you record a macro, it writes the VBA code for you. But for more advanced needs, you can write the VBA code yourself.
I learned VBA in high school
I learned VBA in high school and to be honest I forgot most of it by the time I started working in banking. I can say that you don't need to know it whatsoever to work in excel. At most you can create macros to make your life easier in big models (print area setup and print functions, running multiple case scenerios for output pages, etc.). I've only made a handful of macros in the past few years and everytime I've used the "record macro" function, no straight VBA programming here.