Top Excel Shortcuts For Finance and Modeling From an Ex-JP Morgan Investment Banking Analyst!

In this video I talk about the macros and shortcuts that I use while modeling in excel.

🙌Download the Excel File Below🙌

🖥️Wall Street Prep🖥️
► Use code RARELIQUID for 20% OFF on any course!

💧rareliquid💧

🎥Related Videos🎥

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

📱Interact With Me📱

🧑‍🎓Career Resources👩‍🎓

🔎Disclaimer🔎
All content in this video is for entertainment purposes only. I am not a professional financial advisor and my statements are not to be taken as instructions or directions. In addition, some of the links above are affiliate links, meaning that at no additional cost to you, I may earn a commission if you click through and make a purchase.

#excel #excelshortcuts #modeling

[rareliquid]

Follow along using the Excel file below

Also, if you want to REALLY improve your excel skills, highly recommend either the Excel or Financial Modeling courses at Wall Street Prep! I dug into these courses myself and really like how the modeling course has you dig into real financial statements to build models, which is exactly what I did at JPM.
► Use code RARELIQUID for 20% OFF on any course!

[giorgioramba]

My school paid for the excel course, M&A and LBO modelling. I would definitely recommend it!

[thebishanmethod]

Me after watching this tutorial:
Alt How-T-F am I going to remember all this!

Practise makes perfect I guess. Time to start today.

Thanks for these videos man. As a new Investment Analyst your videos have helped me in my job tremendously. Shoutout from Singapore :)

[darrelldas]

This is what i was waiting Thank you so much.

[mattiacampagna]

I think the best tutorial for modelling shortcuts!! Keep up the good work and hope you continue with these tutorial on Excel modelling.

It would also important to see all the useful modelling formulas, for example: offset, index, indirect etc...

Many thanks from Italy!

[tomduan]

4K Excel tutorials. Oh how the times have changed.

[spencer]

Super helpful after watching you build DCFs in real-time at lightning speed. Super helpful knowing your thinking behind each keystroke.

Thanks so much & keep them coming pls!

[GabrielMacari]

You could make one video with most recurring use formulas, would be much appreciated. Thanks in advance, you have a solid content.

[adioskratos]

This is what I've been waiting for. Take my like sir👍 Love the work man, keep it up

[robertochanliang]

For the paste special short-cut, you can actually do crtl+Alt+V. It's smoother than alt+e+s since we are all used to crtl V.

[deborahs.]

Really useful! Shoutout to you Ben from Singapore, enjoyed your vids, gained a lot of new insights about macro and crypto, took notes as well, definitely helpful for my analyst work!

[TheNarker]

In training with WSP now, great company you're working with. Sweet video, thank you for walking through this. Can you do a walk-through of a 3-statment model next?

[danielchan]

I’ve heard people said if u’re an excel-pro, u rarely use the mouse
I finally get it now lol
Great skills and hard-work behind!

[barryaherne]

Woo, now we have something to link folks to in every stream!

[tranthithuytrang]

Thank you so so much!! This is exactly the file I am finding for a long time. Thank you again

[Azizdesign_]

This video was so satisfying. Thank you

[ChourPower]

Thanks for making this - will come back to this video. What keyboard are you using?

[tharitchaichintawachanon]

Thank you for your tutorial. It was really useful!

[clementbielle-biarrey]

Because it's an excel shortcut video, here is one more : 7:49, to automatically display the date --> CTRL + ";" ;)

[andrewrebak]

Learned a lot! Would you consider doing a synergy analysis with accretion/dilution or LBO vid?