Urgent**Please help advise confused IB SA
Hi guys! Any tip on how to improve excel skills? Thanks a lot!!
Hi guys! Any tip on how to improve excel skills? Thanks a lot!!
+149 | Investment Banking US League Table YTD 2024 (FactSet) | 84 | 7h | |
+144 | Big Layoff at Barclays - 5/1/24 | 76 | 8h | |
+89 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 12 | 1m | |
+87 | “Americans just work harder” | 53 | 18h | |
+83 | Would comitting to ATL İB be stupid? Please give feedback. | 45 | 2d | |
+68 | Sleeping on Jefferies??? | 32 | 18h | |
+66 | A shitter's comprehensive guide to sophomore year recruiting | 7 | 17h | |
+59 | NEED NY RESTAURANT RECOMMENDATIONS | 38 | 2d | |
+58 | What's up with RBC nowadays? | 24 | 17h | |
+50 | 5-Step (Borderline Psycho) Pre-Superday Routine I Used to Land Every IB Internship Offer | 4 | 2d |
Career Resources
Look for windows of opportunity (read: when the other analysts / associates / staffer aren't swamped) to ask to help.
Thank you!! :)
Not to be a shill for Patrick, but the Breaking Into Wall Street "Excellence With Excel" course was fantastic for me. (And, at $99, incredibly priced compared to the other $299 courses.) The videos were good, but the printouts and guides were huge, as were the "after" excel files. I keep the Quick Reference Guide and the Keyboard Shortcut Guide by my desk.
Start by learning these: http://www.wallst-training.com/resources/WST_Excel_Shortcuts.pdf
Then force yourself to stop using a mouse. You will be unbearably slow at first, but if you actually force yourself to only do things by shortcut then you will pick up speed and muscle memory over time.
Agreed with CRE, pick up a few tricks in BIWS. Learn what you use most via google. Also knowing vba (how to code) helped me a lot during my internship.
Thank you so much guys!
Take away the mouse.
this is pretty decent to get you started: https://www.wallstreetprep.com/excelshortcuts/
As said above, use all those shortcuts wihout a mouse. You'll be slow the first day, then you'll start remembering each shortcut - until it becomes second nature to use them. If youre dragging a formula (ctrl d or ctrl r) copy them and then use alt esv so you can find the values later on if you need to (Ctrl F). Also, remember that when you press ctrl anad an arrow, it takes you until the last number on that row / column, which makes itt a lot faster than keeping an arrow pressed for about 20 seconds.
I was impressed by Wall Street Prep's excel crash course.
I'm not exaggerating when I say that it would have saved me an hour or two a day when I was an operations officer in the Army.
Harum quod et unde quia ipsa. Odit magni et sed sunt voluptas cupiditate et. Consequatur debitis rerum nulla blanditiis sequi officiis et eligendi.
Rerum sint sunt earum. Aut qui ut ipsam est architecto nostrum. Repellendus at ipsum et nemo. Quod veritatis quasi quo tempore cum.
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...