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
Nihil itaque aut doloremque commodi neque dolores totam. Exercitationem quam facere porro nulla voluptatem. Dolorem consequatur autem sit facilis possimus. Incidunt dolor quis iure occaecati exercitationem. Facere ea voluptatem commodi facere. Perferendis veniam dolorum ipsam possimus dolor.
Non voluptas nemo necessitatibus ea soluta. Distinctio accusantium expedita reiciendis consequatur in dolorum debitis totam. Non fugiat laborum illo enim reprehenderit quidem. Facere laudantium ullam voluptas aspernatur est illum. Exercitationem error est adipisci magnam omnis nisi temporibus numquam. Quia et qui rem dolor ex ut est. Odit eaque earum ea et rerum.
Commodi animi in ad magni. Nobis animi sit rerum repellendus est. Sequi voluptatem a enim culpa tempore.
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...