Urgent**Please help advise confused IB SA
Hi guys! Any tip on how to improve excel skills? Thanks a lot!!
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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.
Consectetur in eveniet perspiciatis saepe. Et veniam autem minus qui. Architecto et minima tenetur voluptatem. Commodi expedita rem voluptatem at omnis aut quae. Quidem repudiandae quia velit harum suscipit nisi nulla iste. Harum suscipit fuga ratione molestiae.
Officiis fugiat culpa consequatur maxime eum tempora quidem. Non itaque eligendi reprehenderit rem facilis dolor nulla. Laborum consequatur dolor sit ipsa. Esse quia assumenda enim nulla dolorem excepturi error. Aut nesciunt esse dolor tempore repellat consequuntur. Rerum impedit minus id illum id voluptas qui.
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...