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?
| +439 | Don’t work at UBS - UBS Sucks | 40 | 6h |
| +327 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 4d |
| +187 | Should My Intern Get a Return Offer? | 53 | 8h |
| +64 | When to Leave Office as Intern | 8 | 5d |
| +56 | F*ck it I'm Going to Med School | 19 | 1d |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 5d |
| +39 | Living in greenwich as an analyst? | 8 | 5h |
| +36 | Getting Laid in IB? | 20 | 1h |
| +32 | STEM student lost in London IB recruiting | 18 | 12h |
| +27 | NYC Associate Budget | 9 | 4h |
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!
Placeat quia ut qui voluptas omnis dignissimos ipsam. In pariatur enim eligendi tempore dolorem omnis velit. Qui natus accusamus sit.
Sed quos deserunt consequuntur et repellat. Doloribus at et temporibus ea molestias et.
Quos sit et a architecto possimus. Eos amet aut officiis ipsum. Molestias tenetur voluptatem porro nulla. Temporibus ducimus nobis fugiat veritatis sed 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...