Hey everyone, I have been learning VBA and python and have been able to automate a lot of excel tasks! These tasks are very specific and repetitive for some side stuff I work on. However I’d really like to make some programs to help reduce valuation times. Any ideas on what tasks I should automate?
| +91 | [2026 - October] Unbiased Prestige Rankings | 53 | 1h |
| +87 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 19 | 17h |
| +74 | You should probably leave IB | 26 | 1d |
| +45 | Why Do We Turn Comments? | 10 | 1d |
| +43 | Tomorrow Will Be Better | 5 | 4d |
| +41 | Moelis PCA vs Lower tier BB Coverage | 30 | 21h |
| +25 | Banking (Un)fortunately Still Needs You: My Case for Bankers in the AI Era | 3 | 1d |
| +24 | How much should you ask questions / seek feedback as an intern? | 9 | 2h |
| +23 | Lateraling as Analyst | 21 | 24m |
| +23 | UBS IB #24 in US M&A in 2026 | 10 | 18m |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Honestly, I don’t trust VBA for anything math related. Let me rephrase this, I don’t trust my VBA skills for messing around with formulas and values to the point where I’d confidently use it for important models. VBA is far more helpful for formatting stuff (making sure that all numbers and headers are aligned, hardcoded cells and inputs are the right color etc)
I haven’t run into huge problems with that yet. I could always have python do the math and then place the numbers where it needs to be. However that sounds way more complex. I’ll have to play around with it more!
Facere et necessitatibus porro. Culpa deserunt ut aperiam fugiat enim corrupti.
Ab nihil ex corrupti nihil. Ratione et sit et laudantium et. Similique autem eius omnis excepturi. Aut voluptatem blanditiis possimus ut tempora ab quasi.
Expedita facilis nobis et amet. Illum omnis quibusdam facilis expedita dignissimos. Qui consectetur quia consequatur nisi. Aut aspernatur est rem et.
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...