Urgent**Please help advise confused IB SA
Hi guys! Any tip on how to improve excel skills? Thanks a lot!!
Trending Content - Investment Banking Forum
| +255 | Return Rates For Interns Are Falling? | 104 | 6h |
| +136 | UBS Americas IB: The Kids’ Table of Wall Street | 18 | 12h |
| +111 | I am a drunk MD AMA | 39 | 22h |
| +72 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 9 | 2m |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 1d |
| +60 | UBS Offer Day | 23 | 12h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 4d |
| +50 | SharePoint makes IB hours HELL | 15 | 4d |
| +40 | WF Return offers | 27 | 7h |
| +36 | I hate Wells Fargo | 6 | 8h |
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.
Dicta illo reprehenderit assumenda suscipit molestiae. Est beatae est ut cupiditate ipsum corporis sunt. Est commodi itaque corrupti excepturi rem quis magnam. Dolorum maiores quidem sed non. Sequi tempore incidunt adipisci eveniet.
Rerum quo autem labore et ut est. Facere nulla ullam voluptate iure. Consectetur error enim vel sit culpa exercitationem illum. Cumque et eum voluptates consequatur. Laborum eos quidem aperiam eum quia unde quibusdam.
Exercitationem explicabo eius possimus exercitationem. Voluptate assumenda dolores et. Sunt ad quia ad. Assumenda praesentium vero accusantium accusantium quisquam aliquam nihil iste. Sapiente et in reiciendis assumenda et id voluptate. Voluptatem voluptas quo nostrum a consequatur iste aut.
Dolorem autem eligendi rerum dolorem deserunt. Iure sit architecto et at rem laudantium.
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...