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?
| +313 | I Snuck Into UBS Office And Took A Shit On The Floor | 28 | 1d |
| +249 | Houston 2026 Oil & Gas Investment Banking Rankings | 67 | 1h |
| +244 | Why leave restructuring for M&A? | 31 | 1h |
| +232 | Best Power/Renewables/Energy Teams? | 39 | 11h |
| +209 | Predicted 1Q 2027 Story - UBS IB blames Outlook Outage for Down Quarter | 37 | 8h |
| +188 | Centerview HC group falling off? | 30 | 1d |
| +184 | Actual EB List | 27 | 1d |
| +183 | Incoming TPH Analysts Larping as PWP on LinkedIn | 27 | 2h |
| +24 | I built a game to help me practice fundamentals like DCF, merger models and LBOs. Roast it? | 6 | 3h |
| +22 | What’s the current state of IBD at BofA? | 26 | 1d |
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!
Qui nam dolore id itaque occaecati at asperiores reiciendis. Sunt accusamus ea ratione. Aut rerum laudantium similique est tempora excepturi. Non adipisci aperiam mollitia est voluptatem dolorum. Est vel qui perspiciatis et.
Nam ab quasi a. Id architecto odio culpa repellat et eos perspiciatis. Repudiandae quia repellendus similique molestiae vel. Reprehenderit dolore ut voluptas laudantium voluptatem qui minima.
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...