As a full time investment banker, how useful and important is VBA and macro in your daily work life?
I would like to make full use of this extra summer time to learn something useful for future internship but am unsure how important and useful it is to learn VBA and macro. Thought it would be good if any full time banker could answer my question. Many thanks.
Anything to help you get faster/more efficient in excel would be helpful. That stuff, along with shortcuts, let you leave the office earlier. That being said, I don't use VBA and only a few macros and do just fine. I'd say learn excel without a keyboard first (use and customize the quick access toolbar!!) along with the necessary shortcuts and then macros
Also, don't spend all your time memorizing excel shortcuts/macros. I work in powerpoint more than excel and wish I was better at it when I first started out (set up a quick access toolbar for this too!) You should do just fine if you have this attitude already
In what circumstances / teams would you use VBA? Is the time investment to learn it worth it ?
What are your recommended personalized shortcuts in pwp/excel ? Did any of you do anything to get better at PWP/Excel before you started?
I'd say it's not worth your time to learn it. I've only used VBA stuff for spreading financial statements sometimes, but those can be done just fine without. I'm sure people that are more well-versed use them more often, but they're not necessary.
Powerpoint: align (left, center, etc.), group, order (bring to front, back, etc.) Excel: Insert/delete rows/columns, sort, filter, are just a few
I made sure to customize the QAT to how I like it before I started and made sure I knew the recommended keystrokes to them. PM me and I could send you mine
Ipsa dolore voluptatem nihil laborum tempore. At dolores non accusamus sint dolorem et. Dolorem vitae impedit nihil impedit veniam dolor ipsum molestiae.
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...