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
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!
Woo, now we have something to link folks to in every stream!
Thanks for making this video. This is exactly what I’ve been looking for
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?
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!
Thank you for your tutorial. It was really useful!
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!
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.
4K Excel tutorials. Oh how the times have changed.
You’re a great teacher
long waited video... thank you
thank you this is what we neeeed
Amazing video! Thanks a lot!
Thanks for making this - will come back to this video. What keyboard are you using?
very helpful! thank you
wow thank you, now i can have fun!
Thanks! I was going to ask you to do an excel video too!
No F1 key is the way to go. Good vid!
Thank you Ben!
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!
I'm commenting before I start this video. Can't wait to see your shorties
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.
Learned a lot! Would you consider doing a synergy analysis with accretion/dilution or LBO vid?
coming soon in the future~
Thanks for the video, can you elaborate the action done from 9'13'' to 9'20''
This is what I've been waiting for. Take my like sir👍 Love the work man, keep it up
More to come!
🔥🔥🔥 great content Ben!
Very neatly done! Thank you :)
Thank you 🙏🏽
Thank you
Thanks for the video...awesome
Glad you liked it!
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!
Amazing shortcuts💯. Could you make a video on how to build a financial model for the NFT exchange project?
not really possible atm
What laptop would you recommend for excel? Really struggling with my MacBook Air so planning on transitioning to a new laptop..
Keep up the informative content !
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!
Thanks a lot for this, I appreciate your quality of work.
My pleasure!
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!
Wow this is exactly what I needed !
good to hear
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 !
May i know the brand of the keyboard you use in the video? Thanks
thank you！
Does Wall Street prep help with financial modeling for people that want to get into equity research
@rareliquid, what keyboard did you use in this video?
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
What keyboard do you use? Looks v cool!
Did CTRL + "." and CTRL + "," get removed as a shortcuts to add/remove decimal places?
Because it's an excel shortcut video, here is one more : 7:49, to automatically display the date --> CTRL + ";" ;)
Can I know the name of your keyboard, so cool !!!
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
Plz make more vids like this aaaaa
will do!
Is it okay if you do online course of finacial modelling or you have join a hand on class learning
This video is lit
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?
Could you also do a PowerPoint Video with shortcuts? I think there a many investment bankers watching your videos 🙏🙏
For paste special - Ctrl+alt+v
My man!
What keyboard do you use? Is it linked to a laptop????
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
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
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
What kind of keyboard is it ? Many people asked before. Could you please reply?
where did you get the IS for amazon that's from 2013-2021? 10-k shows into 2027.
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
ctrl alt v is alternative paste special
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
CTRL+1 is faster for formatting changes.
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
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
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?
Can you give us the details on that keyboard thooo??
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
3:10 I am listening and ready to learn
3:45 I am completely lost
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
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!
Great stuff! Thanks
Make a video on tumbrules to follow in dcf
great idea for my next excel video!
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
Hi, Ben, I really don't get why you are using offset function
No QAT set up?
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
bruh whats the keyboard reference lmao ty for the content
sooo fuckin lovely: going through this soon: thanks sir.
no prob~
No mouse gang 💪
What kind of keyboard is that?
Any chance finding these shortcuts in Excel for Mac as well? Does anyone know?
Does he say what the keyboard is called?
Please do an analysis on $PSNY (Polestar automotive)!!!
Thanks for the Amazone Video
no probs
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
The pace of the video was just perfect for me. Didn't even realize it had been 30 min until you pointed out.
Thanks for sharing.
it's not the same on macbook. all the keys are different and some of the shortcut combos dont work :(
any tips?
Read the doc file attached below the video, find the alt substitute likely cmd
very good video
For Mac please 🙏