Useful macros for banking
Hey guys
Im preparing for when i start full time in a EB this summer
Im fairly new to macros and VBA but i heard it could be useful for some things in excel like: Conditional formatting checks for: - Net income PL flowing correctly to the cash flow statement - Balance sheet balancing - Anything pulling data etc..
Is there anyone with experience who can confirm that macros are useful for such stuff? and if so, is there anywhere to learn this or just straight up get ready-to-go macros?
Thx
Ive been told VBA's and macros aren't really used in banking. Your probably far better served learning shortcuts for everything vs. learning macros.
The VBA macros that will be useful are mainly to automate repetitive shit, rather than doing actual calculations. A common one I use is a loop script that runs through scenarios in a model and pdfs outputs for each scenario. Lately I've been using a model that has 100 separate identical sheets for different assets within a broader project, the macro deletes then re-copies the master sheet if anything needs to change on the template - a huge time saver. You will pick it up over time, it's not that hard once to learn the basic principles of VBA which you can do on any number of websites/free online courses.
You don't need VBA and macros for banking. Full stop. Not trying to crush your enthusiasm, just being honest.
Focus on the fundamentals first, and then when you're bored one day a year in, you can fuck around with macros
In my team we use macros for 2 things mainly: - pulling data from bbg (betas and multiples basically) - anything repetitive in models such as debt sizings
For the second thing you can also use the goalseek option in excel but it just depends on the analyst/associate. We have a really good associate who is very efficient at coding VBA and he wants us to use macros, also, my team is a very technical one and I can confirm that other teams in my M&A group do not use macros whatsoever
I wrote a macro to send a resignation e-mail, very helpful
Eos nam pariatur consequatur dolorem vero in. Tempore quaerat quas laborum et non officiis.
Fuga consequatur neque cum officia est doloribus omnis. Aut delectus quasi architecto eligendi accusantium molestiae. Voluptatem consectetur facilis qui velit consequatur similique aperiam. Quia commodi nisi aut dolores.
Labore ipsa blanditiis sed repellat eligendi et. Consequuntur et dolores eius nostrum dignissimos et. Expedita neque quas aut voluptate voluptas eos.
Facere at facere explicabo aut optio optio. Architecto reiciendis impedit quibusdam laboriosam eaque. Nihil veniam quia quae ut numquam quisquam. Rerum aut quod harum sit illo. Ipsam quibusdam blanditiis ipsum quis nemo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...