Top Excel Shortcuts For Finance and Modeling From an Ex-JP Morgan Investment Banking Analyst!
Вставка
- Опубліковано 22 чер 2022
- In this video I talk about the macros and shortcuts that I use while modeling in excel.
🙌Download the Excel File Below🙌
► www.dropbox.com/s/jzeuntjni5x...
🖥️Wall Street Prep🖥️
► Financial Modeling Courses - gv142.isrefer.com/go/rliquid/...
► Excel shortcuts - www.wallstreetprep.com/knowle...
► Use code RARELIQUID for 20% OFF on any course!
💧rareliquid💧
► Join the rareliquid community: / rareliquid
► My free daily investing newsletter: www.rareliquidnews.com/
► rareliquid careers channel: / rareliquidcareers
🎥Related Videos🎥
What is a DCF? (For Beginners): • Discounted Cash Flow (...
What is a DCF? (Advanced): • How Investment Bankers...
Amazon DCF Model: • Amazon DCF Valuation M...
Explaining What's Happening with the Markets: • Explaining What's Happ...
How Interest Rates and Inflation Affect the Markets: • Explaining Why Interes...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
📱Interact With Me📱
► Instagram: / rareliquid
► Twitter: / rareliquid
► TikTok: / rareliquid
► LinkedIn: / ben-chon-8b0ba34a
► Business Inquiries: ben@rareliquid.com
🧑🎓Career Resources👩🎓
► Buy my resume and cover letter: rareliquidcareers.com/
► Books I recommend: amzn.to/3gy28xv
► My filming equipment: a.co/cf97WjW
🔎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
Follow along using the Excel file below
► www.dropbox.com/s/jzeuntjni5x042q/Excel%20Shortcut%20Master%20Key.xlsx?dl=0
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.
► gv142.isrefer.com/go/rliquid/rareliquid/
► Use code RARELIQUID for 20% OFF on any course!
What is the difference btwn wallstreetprep and fe?
My school paid for the excel course, M&A and LBO modelling. I would definitely recommend it!
Thank you so so much!! This is exactly the file I am finding for a long time. Thank you again
This is what i was waiting forrrrrrrrrr!. Thank you so much.
no prob~
This video was so satisfying. Thank you
Woo, now we have something to link folks to in every stream!
4K Excel tutorials. Oh how the times have changed.
Thank you for your tutorial. It was really useful!
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?
You’re a great teacher
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!
glad to hear it's helpful!
Was looking for this comment!
Thanks for making this video. This is exactly what I’ve been looking for
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!
will be making a formula video in the future!
long waited video... thank you
thank you this is what we neeeed
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!
Amazing video! Thanks a lot!
very helpful! thank you
Thanks for making this - will come back to this video. What keyboard are you using?
Thanks! I was going to ask you to do an excel video too!
You could make one video with most recurring use formulas, would be much appreciated. Thanks in advance, you have a solid content.
In IB/Modeling it doesn't get very complicated. The most advanced formula is maybe xlookup. it does not get more difficult.
Thank you Ben!
Learned a lot! Would you consider doing a synergy analysis with accretion/dilution or LBO vid?
coming soon in the future~
wow thank you, now i can have fun!
Thank you for the video - super helpful! Just curious why the IS has D&A for more years than the CFS does? And why do we take D&A from CFS and not IS? Thanks!
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 :)
hahaha you pick it up fast after some practice i promise
Got an internship in 3 days, better be fast ahah
Just an FYI, I learned this by forcing myself to do it in school (Any Excel assignment, I made sure to not touch the mouse). The beginning is brutal cause you'll go really slow/very frustrating, but once you get it, it's muscle memory and you'll HATE using the mouse. Long run it's worth it (till Excel's obsolete).
Also alt + D when you're on the internet gets you directly to the search bar which has been helpful.
No F1 key is the way to go. Good vid!
Thanks for the video...awesome
Glad you liked it!
Thank you 🙏🏽
Amazing shortcuts💯. Could you make a video on how to build a financial model for the NFT exchange project?
not really possible atm
I'm commenting before I start this video. Can't wait to see your shorties
Very neatly done! Thank you :)
Waouh thank you so much for that !
Thank you for showing off the shortcut magic!
Glad it was helpful!
Oh my god this is insane!
🔥🔥🔥 great content Ben!
Thank you
This is what I've been waiting for. Take my like sir👍 Love the work man, keep it up
More to come!
Hi Ben! I hope you are doing well. Thank you for the video. I would really appreciate If you could make a video about the formulas that you used in JP while constructing DCF model. Formulas like offset, or more complex ones. Again thank you for the video, keep up bro. Cheers!
These are more like easy lookup fucntions. Look for Lambda or similar type of complex or VBA to master Excel !
thank you！
Keep up the informative content !
Thanks for the video, can you elaborate the action done from 9'13'' to 9'20''
Hi, these tips are pretty useful. But I still wonder if you can recommend a systematic
Excel course series for engineering(computer science) background students?
hm not sure about this one sorry! think it'd be better to have the youtube community answer this one
Wow this is exactly what I needed !
good to hear
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.
one advantage of alt+e+s+v over ctrl+alt+v is that you dont have to hold all the keys at the same time i.e. you can press Alt > e > s > v in a sequence but you have to press ctrl, alt and v key at the same time. Its a bit more comfortable and baby proof :)
great alternative i agree!
My Alt+E+S is not working, do you have any idea what is going on? The only way it's working for me is the Crtl+Alt+V shortcut. Befere used to work, but suddently stopped!
Can I know the name of your keyboard, so cool !!!
What keyboard do you use? Looks v cool!
May i know the brand of the keyboard you use in the video? Thanks
Plz make more vids like this aaaaa
will do!
Thanks a lot for this, I appreciate your quality of work.
My pleasure!
This video is lit
Could you also do a PowerPoint Video with shortcuts? I think there a many investment bankers watching your videos 🙏🙏
Does Wall Street prep help with financial modeling for people that want to get into equity research
My man!
What laptop would you recommend for excel? Really struggling with my MacBook Air so planning on transitioning to a new laptop..
Awesome video!
For the ctrl + "." and ctrl + "," to expand/decrease decimals. Is there anything special you needed to set up to do this shortcut. Tried it out on my Mac and Windows, no luck. This shortcut would be be super helpful in my day to day!
I guess for that to work you have to setup a special macro sheet which by default opens everytime you open excel but reamins hidden.
Same here
Does anyone have a tip
Hi there, many thanks for the video!
Just have one question, at 10:32 you use ctrl+"," to add decimals but this didn't work in my excel. I use alt + h + 9 for that but it takes longer to type it. Did you make any modification in your excel to use ctrl+","?
Same here
hm no i didnt it might be the excel version but i'm not sure it's always worked for me and i didn't configure anything. if u google ur issue u may be able to adjust it
Same here
It could perhaps me a language thing? So if you change the language on your computer, it might work
May be a factset addition, CapIQ has similar shortcuts
@rareliquid, what keyboard did you use in this video?
Hey man, I am a sub to both of your channels, and I absolutely love your content. I can’t even lie, as a college student, you really have inspired me so much. I just had a quick question and it may sound stupid, but I have a MacBook and the short cuts are not working whatsoever. When I use alt and use a certain key, it just types stuff out in a cell. Do you know if there’s anything in doing wrong?
the alt chain commands do not exist on mac
these shortcuts are only for the PC unfortunately
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!
Is there a specific type of keyboard used in investment banking? I am in real estate finance for a relative's firm and always searching for ways to improve my efficiency
Is it okay if you do online course of finacial modelling or you have join a hand on class learning
would you recommend wall street prep or financial edge for investment banking training?
to work in investment banking you need at least a masters of science in finance.
@@astonmartinone100 not true, just need bachelor's degree
@@astonmartinone100 you're actually preferred with bachelor's since they only want to you to work 24/7, they don't care whether you have any knowledge whatsoever
Because it's an excel shortcut video, here is one more : 7:49, to automatically display the date --> CTRL + ";" ;)
What keyboard do you use? Is it linked to a laptop????
Is there a way of getting an internship after being out of school for a while? I have a finance degree and have literally done nothing with it. My resume is full of retail jobs. I have been doing a valuation analyst program, DCF, 3-statement models etc. What can I do?
Just subscribed to your channel! Thanks for the content!
sadly I don't think so. It seems that the bulk of people who intern/entry level are 22 year old schlubs who they can abuse and they don't know any better. You're too wordly for them
For paste special - Ctrl+alt+v
just curious on why you switched from financial edge to wall street prep?
wall street prep reached out to me and i looked into their courses and liked how their financial modeling package went directly into company financial statements while modeling which financial edge didn't do. they also have a lot more courses that cover a ton of different industries and topics so i liked that as well.
in the end though, i think both are great companies and you can't go wrong with either! i just liked WSP more so decided to only partner with them now
Hi Ben!!
Rly thanks for introing and going thru this with us. Can I ask if Wall Street prep also provides other data related courses as well (SQL, VBA) etc?
The Quick Access toolbar is also pretty nifty for repetitive actions!
yup i need to add those i used to use them all the time
Make a video on tumbrules to follow in dcf
great idea for my next excel video!
Did CTRL + "." and CTRL + "," get removed as a shortcuts to add/remove decimal places?
CTRL+1 is faster for formatting changes.
What keyboard do you use? I'm looking for a new one and want to try yours✌✌
Cloud nine ergo split keyboard 👍🏻 he uses that keyboard
Please do an analysis on $PSNY (Polestar automotive)!!!
Can you give us the details on that keyboard thooo??
Great stuff! Thanks
lets goooooooo
What kind of keyboard is it ? Many people asked before. Could you please reply?
ctrl alt v is alternative paste special
sooo fuckin lovely: going through this soon: thanks sir.
no prob~
How can I find the income statements for companies that show a 5 year history? I can only find the income statements for the previous quarter. Thanks
bamsec.com is good but only goes for past 3 years. looks at 10k's not 10q's
where did you get the IS for amazon that's from 2013-2021? 10-k shows into 2027.
No mouse gang 💪
Thanks for the Amazone Video
no probs
bruh whats the keyboard reference lmao ty for the content
I'm a banker and I'm always wondering if modelling is actually useful, or is it more like something bankers invented just to make them seem helpful?
I looked through some SPAC models and they gave every company the same one LOL. I mean fair enough only so much you can do with likely fraudulent predictions but still some intern saved a lot with the ctrl c + ctrl v and then just change the company name
For Mac please 🙏
Does he say what the keyboard is called?
No QAT set up?
Excel works better on a PC than a Mac.
I’d rather buy a $500 PC than install parallels, which runs around $120/ year.
What kind of PC was this model constructed on?
3:10 I am listening and ready to learn
3:45 I am completely lost
What kind of keyboard is that?
very good video
Hi, Ben, I really don't get why you are using offset function
hi ctrl + "." does not work on my excel do you know why?
Try this: Alt + H + 9--- to add decimal
Alt+ H + 0-- to remove decimal
Maybe I don't understand excel because I usually use R, but aren't you worried about corrupting the raw data? I prefer to import and do stuff so I can never accidentally overwrite it. I know you always keep a data backup but it just seems like solving the problem is so much harder once something breaks than if you use a programming language
Any chance finding these shortcuts in Excel for Mac as well? Does anyone know?
If I am copying a format using 'Alt + H + FP' is there a way to be able to format paint more than one cell? or skip a cell and format the next?!
Thanks for the video, very helpful!
Why use offset instead of choose?