BEST Excel Shortcuts for Business & Finance

[@KenjiExplains]

Get 25% OFF any Financial Edge course using code KENJI25: bit.ly/3Ds47vS

[@ShawnFX]

So grateful to have found out your channel! I'm a senior in college studying finance and accounting and about to start my MBA this January. These videos help me understand more what I learn in classes because our professors just reads off of powerpoint slides. Thanks Kenji, God bless!

[@nickstiles4045]

Hi Kenji, I love these excel videos. As a student in Finance, this material is always helpful! Thank you!

[@KenjiExplains]

Glad it was helpful and thank you for watching ✌️

[@timmagaling]

@@KenjiExplains same kenji, student of finance here as well, Thanks!

[@lawowo2270]

These shortcuts will save me a whole lifetime, please do make more of these videos!

[@KenjiExplains]

Thanks for watching I've noted your comment!

[@KenjiExplains]

Learn Excel for Business & Finance: learn.kenjiexplains.com/

[@KrishnaShah-hp7su]

Much needed a Part 2 . Eagerly waiting for it

[@mrCetus]

These shortcuts are so helpful and clearly explained! Thank you!!

[@SidBharti]

Hi Kenji, these are definitely very useful. Please do make a part 2.

[@KenjiExplains]

Noted!

[@scottburton7883]

Thank you for posting this, I didn't realize how many nifty little tricks I didn't know. Brilliant resource :)

[@jmds6660]

Saw the disclaimer so clicked all the links. Thanks for the nifty little video, liked that it covered some things that just save mouse work or improve the look of work a bit

[@KenjiExplains]

Haha thanks James, glad it was helpful!

[@alkovachev]

Great video once again! Packed with useful info. Here is another useful one for part two. Ctrl + T - automatic table formatting…. Also double clicking format painter is super useful.. i wonder if you press the shortcut twice if it will have the same effect

[@KenjiExplains]

Thanks for sharing Alex! Appreciate the insights could be interesting for a pt2 :)

[@samvitsaroj4757]

Part 2 as well please

[@kingbk1592]

Do a part 2!

[@KenjiExplains]

Noted!

[@rehanqureshi2609]

You are doing great work, keep it this way. Videos are concise and to the point. Also, can you do a little more videos on financial news?

[@KenjiExplains]

Thank you Rehan! You mean like "what's going on in the finance world this week type" or going over something more specific?

[@brandonlopliach3609]

Thanks so much for the videos Kenji! I have been prepping for a new job as a financial analyst and your videos have been pivotal in that

[@KenjiExplains]

Great to hear Brandon!

[@Perfectsound88]

Amazing Amazing and Amazing Bro.Subscribed and watched all the ads.

[@SothearithKONGMrMuyKhmer]

Thanks Kenji! That’s really helpful 🎉

[@christiancoronado]

Great video, I am a CPA and work a lot with excel. Super helpful

[@KenjiExplains]

Glad it was helpful!

[@nickalvaro5834]

Such an underrated channel. Keep it up

[@KenjiExplains]

Much appreciated!

[@Crystalbomb321]

This was so informative! Thanks so much.

[@javierjp8549]

Thanks!

[@crizzamarie]

Thank you so muchh

[@nachoroman6102]

Super useful one! By the way Kenji , just wanted to drop an idea for a possible video: I'd love to see from you a video about: "The top 5 hard skills for business students" with the main skills that later on might be useful in business positions, and therefore might be interesting to train and invest time in being proficient during our university period.

[@KenjiExplains]

Hi Nacho, not sure what you mean. Hard skills for business students as in specific coursework that can be helpful? (financial accounting etc.?)

[@nachoroman6102]

@@KenjiExplains Yes! Actually I explained myself pretty bad, but I was maybe thinking of technical tools that might be useful (Maybe Excel, Python, PowerBI, SQL, etc). But technical skills as financial accounting or any other in specific would be super interesting as well :D

[@KenjiExplains]

@@nachoroman6102 I see! I'll note it but overall I'd recommend Excel first and one you master it SQL. SQL is useful for managing large datasets for example if you're in financial planning.

[@tahaelqatib2840]

Really helpful, thanks a lot ! can't wait for the second part

[@KenjiExplains]

Thanks for watching!

[@googleaccount3286]

Amazing content. Thank you very much, can't wait for part 2 !!

[@KenjiExplains]

Thanks for watching!

[@hoabinhnguyen1249]

Great lecture. Thanks a lot

[@oscarcanales1230]

Are you in Barcelona? Outro photo got me 😅

[@KenjiExplains]

Yes, that's from Barcelona, good eye haha

[@ahsicuhvihenvrinvhui]

Awesome video man! I am soon starting my job in consulting and wanted to step up my Excel game a little bit, your video defintely helped! Would love to see more of this!

[@KenjiExplains]

Glad it was helpful! best of luck with your new job :)

[@aminelazreq5614]

Amazing video ! Thanks man !!

[@lucasgarciaickes1602]

Vamooos Kenji!! Que bien te enseñaron en la AUP hermano...

[@KenjiExplains]

Lucas!! Un abrazo crack!

[@KenjiExplains]

Te acabo de enviar un whatsapp tío sigues con tu numero español no?

[@trebron9512]

Moooore Excel Videos Pls! Btw, where is the video about excel formulas? Thank you! :)

[@muhammadimtiazimtiaz3210]

great it is very helpfull

[@theparamountcreators]

Hello Kenji, Am finding it difficult downloading the file. Is there anyway on how you can directly share it to me please. ?🙏🙏

[@mramazing2539]

Hi Kenji, let's please do one for powerpoint as well, thank you!

[@KenjiExplains]

Noted! Thank you

[@shubhisingh8937]

Please make some more excel videos

[@cesarduquehincapie7733]

Nice video Kenji, thanks a lot!

[@KenjiExplains]

Glad you enjoyed it!

[@abhishekkashyap_ak]

Thanku Kenji for your informative video. I'm desperately waiting for your financial modelling video. pls make a financial modelling video from scratch with valuation.

[@KenjiExplains]

Hi a full financial modelling video will have to wait for now...just takes a long time to make so I'm hoping during January/winter break sorry

[@abhishekkashyap_ak]

@@KenjiExplains Okay Thanks.

[@adrians9479]

please part 2 bro

[@adrians9479]

10:42 for me in germany all these shortcuts arent working unfortunatly

[@uttamkalika597]

great work

[@brandons.9086]

You know, it's funny. I have been doing programming for Supervisory Controls and Data Acquisition (SCADA) for over 8 years and have used excel VBA and formulas that entire time to generate my programs which were usually CSV imports. And i never used shortcuts.

[@TheSwingState]

Hey what would you say is the best keyboard for productivity ? Logitech MX ?

[@hieuieu9194]

Thank you for your sharing

[@KenjiExplains]

Thanks for watching!

[@hieuieu9194]

@@KenjiExplains I was always wondering about how to read and understand economics news. Can you make a video about that topic?

[@KenjiExplains]

@@hieuieu9194 Will note it thank you, not sure if I have great insights on this so lets see if I do it

[@tristanchiu6944]

wow time to vlookup what financial edge is about

[@KenjiExplains]

Hahah very creative comment Tristan, thanks for watching!

[@YuvrajSingh0407]

Hi Kenji. I’m about to start my BSc in Economics and was wondering what kind of laptop you and your colleagues use as I’d like to keep mine for some years into my career. Windows or Mac for example? Thanks

[@KenjiExplains]

Hi! The majority of companies in business fields use windows. That said you’re usually given a company computer so you wouldn’t be using your personal one

[@YuvrajSingh0407]

@@KenjiExplains Thanks Kenji👍👍👍

[@omarcuppini7072]

Is there an alternative and hopefully faster way for the black cross function of Excel? (I'm using alt+H+F+I+S then shift+tab+F then Enter). For example if u have Monday and Tuesday and you want to autofill the rest of the week without the need of the mouse

[@KenjiExplains]

Good question, I haven't found any so I just use the mouse for that, seems the fastest I've found. Would love to hear a more efficient alternative though!

[@solomonbhandari-young4154]

Amazing

[@lynnfrank8388]

Hi Kenji. I would like to take advantage of the financial edge course you mentioned. My question: Which courses exactly would you recommend me to take? My aim: I want to work in finance (investment banking / private equity / wealth management / trading - i am not sure everything seams so interesting) For that I would want to start as a investment banking summer analyst. So what would be important for that (which courses?) Thank you in advance, Lynn

[@KenjiExplains]

Hi! If you want to work as an investment banking summer analyst it probably makes sense to take the investment banker course (its the same content as what the interns learn on their first week of training). Best of luck with recruiting!

[@lynnfrank8388]

@@KenjiExplains thank you so much kenji! So you woul recommend (only) doing this course? Or are there other courses you would recommend. (e.g excel, power point, valuation of a company courses etc.)?

[@KenjiExplains]

I don’t know your budget/time available but it can’t hurt to be more knowledgeable. The business toolkit course is nice in that it’s useful for any business/finance job and not exclusive to any division

[@willzinner8813]

The autosum is sick

[@KenjiExplains]

haha i know!

[@user-xm1jx6be1r]

Truly it is!

[@irynaparfeniuk3556]

i knew all of them

[@laudablefan9098]

Part 2

[@dalle99ad]

Im having some troubles with alt shortcuts not working properly, any idea as to why?

[@KenjiExplains]

Are you on a Mac? They’re for windows unfortunately

[@dalle99ad]

@@KenjiExplains No! I'm on a HP. It's from Sweden, but I have English (US) as main language for keyboard etc. Do you think it has something to do with the keyboard layout?

[@theyoungdiplomat23]

is financial edge better than wallstreet pep? thx

[@KenjiExplains]

Hey! I haven't take wallstreet prep courses so I cant say! All I know is the FE ones are solid

[@theyoungdiplomat23]

@@KenjiExplains Sounds good will check it out thx!

[@rileysmith4451]

How did you learn all this?

[@KenjiExplains]

Took excel classes in university and some companies i worked for also trained me!

[@user-jv1cl2fs6m]

Dang there's Hundreds of key combos, how the hell could anyone remember even 50 of them. SMDH

[@marcolucchini4130]

I like your cut Gggggggg

[@powershiva9957]

Bro.....need some slow explanation ur too fast

[@user-ud4fg2gs5h]

FAR FAR TOO FAST TO BE OF ANY USE

[@camlex6310]

These shortcuts are so helpful and clearly explained! Thank you!!

[@KenjiExplains]

Glad it was helpful!