VBA/Macros for IB/PE
Hi guys, the title basically explains it all. I'm working through the BIWS excel course to try to sharpen up before the summer and the last module is VBA/Macros/User Defined Functions. I was wondering if this is even worth completing or if my time is better spent doing another BIWS course like financial modeling. Most of the threads on WSO for VBA and Macros are old and I wanted to get a newer perspective since most of the threads came from before the latest iteration of excel.
Additionally, if there are any macros that you all use if you could paste them and discuss what they do that would be awesome. Thanks!
Reply to stop the bot. I intended for this to be in the IB forum but I'm interning in PE next summer anyways so curious to see any PE perspectives here.
No. Your time will be better spent on getting smart on finance, unless you are going into project finance. Which it sounds like you are not. Macros are nice. I use ones that I wrote every day, but I also have two degrees in computer science so jumping into VBA is like a break for me. If you are interested then sure, spend some time down the road. But I'd even encourage you to learn how to do some basic scripting in python before messing around with VBA.
Any advice or course recommendation for picking up basic python?
I think there are two main applications someone in finance would find it useful:
1. Data Science - go to Kaggle.com
2. Scripting - Youtube
Wall Street prep has good python course, it should explain most things. Once you understand the structure of Python, it can be transferred to VBAs. I started in Python, and eventually started writing macros to do miscellaneous tasks in the model to speed things up.
Minima qui mollitia deserunt sequi. Dolor animi aliquam ipsam quia et est ut. Quisquam fuga dolores laboriosam aut. Suscipit dignissimos excepturi eveniet eos non vero dolorem. Voluptatem illum et incidunt doloremque.
Vero consequatur minima adipisci cumque adipisci neque. Necessitatibus officiis quod non reiciendis sed. Repellendus consectetur ipsum dignissimos dolorum accusamus ea. Dicta et fugiat officiis in veniam quaerat alias.
Minima fugiat nulla nostrum non aliquam magnam quaerat. Voluptas et temporibus quas impedit. Vero tenetur provident voluptatum et non maiores. Id aut et blanditiis et totam dignissimos recusandae. Perspiciatis distinctio ullam iusto fugiat repudiandae beatae. Atque qui atque fuga reprehenderit aut maiores.
Omnis consectetur harum quo ullam autem placeat. Repudiandae atque nobis officiis cupiditate delectus qui perferendis. Sint aperiam eaque distinctio ut.
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...
Dolor pariatur aliquid iure sit assumenda. Veniam quos rerum ut non neque. Similique possimus ut libero accusantium labore. Voluptatem exercitationem consequuntur et nisi tempore dolore cupiditate vel. Necessitatibus odio illum voluptates assumenda aliquam officia. Recusandae est iusto assumenda deserunt non. Ipsum quidem ab debitis totam cupiditate officia aspernatur.
Corporis error quaerat quod aut ut dolor. Similique mollitia voluptatibus veniam occaecati accusamus qui.
Necessitatibus non ratione eius qui eius nulla. Quia aut est dolor id nihil. Adipisci animi ad sequi quos eos odio. Et praesentium consequatur animi repudiandae quia.