Become REALLY Fast in Excel With These Shortcuts!

Learn Excel Shortcuts to make you an expert-level excel user. These are useful for anybody working in an excel-based role such as consulting, investment banking, finance, or accounting.
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/62b59d...
In this video we cover the most useful excel shortcuts.
The rookie level shortcuts will be on basic ctrl key shortcuts to navigate around a workbook. These include ctrl up, ctrl shift up, ctrl pageup etc.
In the amateur level, we'll use formatting shortcuts such as ctrl 1 and the paste special feature.
Then, in the expert level, we'll introduce the alt key shortcuts, which are an advanced feature which allows you to reach virtually any key without using the mouse.
Lastly, in the sensei level, we'll go over the quick access toolbar, which allows you to customize your excel shortcuts so you can reach them more easily.
And throughout, we'll use Formula 1 teams as analogies to from slowest to fastest!
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Rookie Level
2:25​ - Amateur Level
4:36​ - Expert Level
6:58​ - Sensei Level
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 137

  • @KenjiExplains
    @KenjiExplains Жыл бұрын

    👉 Take our Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance

  • @rexbk
    @rexbk14 күн бұрын

    Fantastic. Thanks, Kenji!

  • @synch
    @synch Жыл бұрын

    Thank you for the comprehensive tips !😊

  • @user-fb1ye3oo1h
    @user-fb1ye3oo1h Жыл бұрын

    I've been watching your channel for a while and I still remember the fisrt time i saw you do all these shortcuts, how amazed I was. Thanks for sharing such amazing content Kenji!

  • @abdulrahmankhan5139
    @abdulrahmankhan51392 жыл бұрын

    Such helpful tutorial thanks for your efforts.

  • @camlex6310
    @camlex63102 жыл бұрын

    love the f1 analogy and shortcuts are great aswell!!

  • @chensebassen
    @chensebassen2 жыл бұрын

    Part 2, please!!! This content was 10/10

  • @skshah309
    @skshah309 Жыл бұрын

    Thank You Kenji. You are awesome. To the point and helpful ideas

  • @granitmanifit
    @granitmanifit2 жыл бұрын

    Hi Kenji, your videos are so helpful I always delayed my excel formulas knowledge but finally decided to face it and learn them, your videos helped alot and I only had to watch them once to learn them including many other things such as data validation etc. can you please make a video on pivot tabes as I canot find any videos you have including pivot tables?

  • @NightWear21
    @NightWear21 Жыл бұрын

    Thank you Kenji! Great work. Looked great. Great explanation.

  • @kirankamble2288
    @kirankamble2288 Жыл бұрын

    Thank you for the Relevant Content Kenji🙏

  • @chanterry905
    @chanterry9055 ай бұрын

    Very handy tips. Thank you so much for your sharing!

  • @JamesJohnson-yy1xt
    @JamesJohnson-yy1xt Жыл бұрын

    Awesome use of F1 analogy, love it and the content is great too.

  • @jayatallam6406
    @jayatallam6406 Жыл бұрын

    Hi Kenji you are awesome Thank you for sharing the tips & shortcuts Plz make more easy short videos

  • @willzinner8813
    @willzinner88132 жыл бұрын

    pt 2 plese thank you as always

  • @KenjiExplains

    @KenjiExplains

    2 жыл бұрын

    Noted! Thanks for watching as always!

  • @andymarci6766
    @andymarci6766 Жыл бұрын

    Great info Kenji, thanks!

  • @NickBurke
    @NickBurke Жыл бұрын

    The F1 references were spot on and overall this was incredibly helpful! Awesome video man!

  • @novamputra4120

    @novamputra4120

    Жыл бұрын

    Haha agree

  • @hisokaamorou4211
    @hisokaamorou4211 Жыл бұрын

    thanks for your hardwork!

  • @eulercarta997
    @eulercarta997 Жыл бұрын

    this is very helpful.. thanks 👍

  • @hamidrezaakbari7611
    @hamidrezaakbari76112 ай бұрын

    Thank you so much, kenji. you are hero 😍😍

  • @yamaahmady1381
    @yamaahmady1381 Жыл бұрын

    Thank you. Great content!

  • @nbk-allinone4126
    @nbk-allinone4126 Жыл бұрын

    Very Usefull Tips Kenji Thank You Very Much ❤❤❤😊😊

  • @sumisabu7898
    @sumisabu78982 ай бұрын

    Cool tricks Kenji👌👌👌👌

  • @agustinadrianuy7498
    @agustinadrianuy7498 Жыл бұрын

    Amazing! Thanks for this

  • @Marie-nt1in
    @Marie-nt1in2 жыл бұрын

    Really enjoyed this video! I’ve discovered your channel recently and I’m amazed to learn & try so many new (for me) features of excel. Your content is very useful and explanations are smooth. Thank you!

  • @azeezulgani2209
    @azeezulgani22093 ай бұрын

    This is really amazing!!!!!🤩🤩🤩🤩😍😍😍😍🔥🔥🔥🔥

  • @user-rj8bw7vf3q
    @user-rj8bw7vf3q4 ай бұрын

    Great. Thank you.

  • @gangaarumugam6677
    @gangaarumugam6677 Жыл бұрын

    Worth watching... Excellent shortcuts😊... Thank you for sharing it in simple way..

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks a lot 😊

  • @Nardine200
    @Nardine200 Жыл бұрын

    Thanks for sharing!

  • @hmaminulislam9145
    @hmaminulislam914511 ай бұрын

    Thanks a lot kenji❤❤❤❤

  • @desirewanda5191
    @desirewanda5191 Жыл бұрын

    Thanks for the tips really want to be an expert in this excel software. 5 stars on this vedio

  • @jenoyestewart1516
    @jenoyestewart1516 Жыл бұрын

    This is soooo cool!

  • @hillarynguyen5707
    @hillarynguyen5707 Жыл бұрын

    Last two tricks were are cool

  • @t-bone7988
    @t-bone798811 ай бұрын

    Awesome!

  • @titaGrace
    @titaGrace2 ай бұрын

    ...I didn't know the camera tool in excel. I won't use it often but that's a cool feature. Thank you!

  • @DhruvJain10
    @DhruvJain102 жыл бұрын

    Hi Kenji, how do you record videos with such clarity? It would be helpful if i get to know about the software you use for recording / editing?

  • @arcelimesiona4930
    @arcelimesiona4930 Жыл бұрын

    Thanks!

  • @hallmarkchemicals886
    @hallmarkchemicals886 Жыл бұрын

    informative and excellent

  • @sakibmohammad5014
    @sakibmohammad501410 ай бұрын

    This is really great

  • @alaallouche3974
    @alaallouche3974 Жыл бұрын

    that sensei rating with the Alonso add was just perfect.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Hahaha love to hear it! El Plan XD

  • @pratimachoudhary2979
    @pratimachoudhary2979 Жыл бұрын

    Hey Kenji, your videos are quite helpful. Can you make videos on cash flow both under direct and indirect method using a real company balance sheet and P/L. Looking forward for it.

  • @stephenhickey3560
    @stephenhickey3560 Жыл бұрын

    Brilliant.

  • @ahmedmokhtar190
    @ahmedmokhtar1902 жыл бұрын

    Really grear work thanks please would you make video about statement for currunt account for client thanks

  • @fireman194
    @fireman194 Жыл бұрын

    That was awesome

  • @luxuryfastunboxing4065
    @luxuryfastunboxing4065 Жыл бұрын

    Bro very good

  • @sirasmuhammad7573
    @sirasmuhammad7573 Жыл бұрын

    Thanks bro

  • @kayrealist9793
    @kayrealist9793 Жыл бұрын

    Excel is AMAZING

  • @khayourabdellah8727
    @khayourabdellah8727 Жыл бұрын

    Very good

  • @shamshadqazi3520
    @shamshadqazi3520 Жыл бұрын

    Super cool dude

  • @mohamedahmedhalane4761
    @mohamedahmedhalane4761 Жыл бұрын

    Thanks kenji for your videos then kindly please share the M&E data Analysis about Health Data for Organizations like humanitarian Many Thanks

  • @terencekchan730
    @terencekchan730 Жыл бұрын

    thx a lot

  • @dipalishah1263
    @dipalishah12632 жыл бұрын

    Hi Kenji Thank you for giving all the knowledge. I am working accounting , and I am juggling to making a garnishment sheet for payroll can you please make the video on it.

  • @learningdistilled

    @learningdistilled

    Жыл бұрын

    Can you explain to me what a garnishment sheet is? I might be able to help you out

  • @emmanueltrejo3531
    @emmanueltrejo3531 Жыл бұрын

    Cool Channel, cheers!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for watching!

  • @juliovildosola1075
    @juliovildosola1075 Жыл бұрын

    These are very helpful, but can you do a video for Mac users?

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 Жыл бұрын

    master Kenji at it again

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Cheers boss!

  • @jditsfights256
    @jditsfights256 Жыл бұрын

    I love F1, references definitely help lol.

  • @emmanueltrejo3531
    @emmanueltrejo3531 Жыл бұрын

    Working at pwc BV right now, was a top performer/ sensei on this skills😅👍🏻

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Let's goo

  • @marcosaenz390
    @marcosaenz3903 ай бұрын

    gracias crack

  • @ahmadomar520
    @ahmadomar520 Жыл бұрын

    thanks

  • @anandl2003
    @anandl2003 Жыл бұрын

    Great !Thank you

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad you liked it!

  • @anandl2003

    @anandl2003

    Жыл бұрын

    Yes, some useful excel tips 👍 Appreciate it.

  • @TheTediplay
    @TheTediplay2 жыл бұрын

    Dude, Haas are crushing this F1 season, so "Rookies" would be inappropriate :D

  • @varunmittal5196
    @varunmittal51962 жыл бұрын

    Could you please make some video for MacBook keyboard.. Many thanks

  • @karthikkeyan3902
    @karthikkeyan3902 Жыл бұрын

    You can use ALT+O+C+A for auto fit, thanks

  • @user-pd4nm7rs2t
    @user-pd4nm7rs2t Жыл бұрын

    I loved that you are giving examples from F1 AHAHAAHAHHAHAHAH COOL DUDE SO COOL

  • @RaltahookCrafting
    @RaltahookCrafting2 жыл бұрын

    Hey Kenji, any chance you have a coupon for your courses at Career Principles? Love your content, but at this moment I'm just a broke LaTam uni undergraduate.

  • @KenjiExplains

    @KenjiExplains

    2 жыл бұрын

    Hey please reach out at info@careerprinciples.com happy to help

  • @dispirted8
    @dispirted8 Жыл бұрын

    Does anyone not like the date format you get from Alt + Shift + #, e.g. 01-Jan-22? I prefer the short date format, e.g. 01/01/2022; I wish we got that from the above shortcut, but I think the best we have is Alt, H, N, S, Enter. Please tell me if you know a quicker shortcut for this format.

  • @NeoKnight9
    @NeoKnight9 Жыл бұрын

    Is there a way to build a custom AutoFormat table design?

  • @TG-uh7yl
    @TG-uh7yl9 ай бұрын

    I cannot use Alt+1 as a screenshot, in the last trick, how do you do it?

  • @lolliMAN101
    @lolliMAN101 Жыл бұрын

    My keyboard doesn’t have dollar and percentage symbols by default, they are under Shift+4 and Shift+5. Does ctrl-shift-4 work to add dollar signs and ctrl-shift-5 for percentage formatting?

  • @meryemb603
    @meryemb603 Жыл бұрын

    Do you know please the equivalent of alt ( access key ) in excel while using MacBook

  • @VijayPawar-sz6gq
    @VijayPawar-sz6gq Жыл бұрын

    👌

  • @kerrydarrigan8204
    @kerrydarrigan8204 Жыл бұрын

    Awesome video, I have a little trouble keeping up, can you slow down a little?

  • @notesfromleisa-land

    @notesfromleisa-land

    Жыл бұрын

    Use the settings gear to slow down playback speed and of course rewind

  • @metalslugg3r
    @metalslugg3r Жыл бұрын

    Really enjoyed this video. Thank you! I noticed that I hit a wall as soon as you introduced the Alt + commands when using a Mac. Was wondering if there are workarounds when using the Mac version of excel?

  • @emmanueltrejo3531

    @emmanueltrejo3531

    Жыл бұрын

    Good question,

  • @learningdistilled

    @learningdistilled

    Жыл бұрын

    Hey Dillan. In a lot of cases, the Mac equivalent of Alt in excel is the option key. I hope that helps you out!

  • @chernojallow518
    @chernojallow518 Жыл бұрын

    Please Help me , if I press ALT+1 I get Emoji😁 I'm Using Lenovo Laptop Thank you , your Videos are Amazing and Helpful .

  • @DhruvJain10
    @DhruvJain102 жыл бұрын

    Where is the table suggestion in excel? I wasn't able to find it. Can anyone please tell me

  • @eldrediienecio1687
    @eldrediienecio1687 Жыл бұрын

    Hi Kenji, I'm using Office 16 but some functions do not appear. What excel version are you using?

  • @ialonsodero
    @ialonsodero Жыл бұрын

    Does this work for MacOs?

  • @rodrigogonzalez2673
    @rodrigogonzalez2673 Жыл бұрын

    I'm having trouble taking the screenshot in excel to create the dynamic image, when I press Ctrl + 1 it autosaves instead of making the screenshot. Can someone help me?

  • @a.h.m.sakhawathossain1680
    @a.h.m.sakhawathossain1680Ай бұрын

    Why tish shortcut " Ctrl+Alt+V" for past value not working?

  • @XLLearner_Courses
    @XLLearner_Courses8 ай бұрын

    👍

  • @robinwhite144
    @robinwhite144 Жыл бұрын

    I am bit confused on the Alt+6 to autofit as that doesn't seem to work for me. Is there something you need to do, to get that to work?

  • @bisolaakinsanya4233

    @bisolaakinsanya4233

    Жыл бұрын

    He created the autofit in his tool bar. Its the 6th box in his toolbar. sort of a shortcut.

  • @krishammond8851
    @krishammond88512 ай бұрын

    Amazing series but link to workbook seldom works

  • @KenjiExplains

    @KenjiExplains

    2 ай бұрын

    hey once you fill the form it should download to your computer/browser downloads folder

  • @jamesarchieodena4107
    @jamesarchieodena4107 Жыл бұрын

    I am starting to like you. You are so cute and handsome. Your tips are so helpful.

  • @elyaskara4670
    @elyaskara4670 Жыл бұрын

    How to remove commas from the numbers

  • @fangzhang2368
    @fangzhang2368 Жыл бұрын

    so handsome and intelligent

  • @sabrysaaed
    @sabrysaaed Жыл бұрын

    shift + f2 for the panel is not working ! office 19

  • @nihayatsabah3063
    @nihayatsabah3063 Жыл бұрын

    When i Use Alt +5 and Alt +4 not working why?

  • @kingjulian1428
    @kingjulian14282 жыл бұрын

    Mick Schumacher disagrees with the rookie placement

  • @headred76
    @headred76 Жыл бұрын

    Are you kidding me? Mr Bean driving his car from an armchair strapped to the roof is rookie?!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Hahaha

  • @yeladim10
    @yeladim10 Жыл бұрын

    ctrl shift + doesnt add column or rows. You need to take out the [shift].

  • @jason19858

    @jason19858

    Жыл бұрын

    You need to select row/colomn first by pressing ctrl +space for column and shift+space for rows, then press ctrl+shift+ +

  • @AnthonySmith-gx9bs
    @AnthonySmith-gx9bs Жыл бұрын

    The real shortcut is buying a subscription to Macabacus and customizing all of these

  • @bahaeddinedammak2691
    @bahaeddinedammak2691 Жыл бұрын

    it's CTRL + to add column not CTRL SHIFT +

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    It depends on whether you have a numberpad on your keyboard

  • @michaelquach7046
    @michaelquach70462 жыл бұрын

    Nooo not Haas 😭😭😭

  • @KenjiExplains

    @KenjiExplains

    2 жыл бұрын

    hahaha

  • @ankushverma9392
    @ankushverma9392 Жыл бұрын

    Mrs Charlotte is legit and her method works like magic I keep on earning every single week with her new strategy

  • @irneseip2592

    @irneseip2592

    Жыл бұрын

    Mrs Charlotte is obviously the best, I invested $3,000 and she made profit of $28,000 for me just in 15 days

  • @irneseip2592

    @irneseip2592

    Жыл бұрын

    Her success story is everywhere

  • @laurajosie9926

    @laurajosie9926

    Жыл бұрын

    Who's this professional everyone is talking about I always see her post on top comment on every KZread video I watched

  • @laurajosie9926

    @laurajosie9926

    Жыл бұрын

    I think I'm interested how can I get in touch with Mrs Charlotte

  • @bozemanhenrik4431

    @bozemanhenrik4431

    Жыл бұрын

    I'm from Germany I used to take loan from the bank for surviver but after trading with expert Mrs Charlotte she changed my financial status for real

  • @MariaGarcia-gv8hj
    @MariaGarcia-gv8hj Жыл бұрын

    *When it comes to investing, I'm so ignorant about it, I hereby ask; What's your say or thought for anyone with over $20k looking for the best ways to make good returns off it? I will appreciate any help here on how to do this*

  • @MariaGarcia-gv8hj

    @MariaGarcia-gv8hj

    Жыл бұрын

    @Lucy Bernardi Interesting, I've always been fascinated with investing and I need to start now. Could you possibly give more information on your Investment Professional and how I can reach out to her?

  • @6690501

    @6690501

    Жыл бұрын

    Throw it in a s&p 500 etf inflation adjusted return 10% annually you’ll have 40k in year 7 80k year 14 160 year 21 320 year 28 640 year 35 and 1280 year 42. This is in todays dollars for since inflation is accounted for

  • @LennoksUA

    @LennoksUA

    Жыл бұрын

    Go to university.

  • @ljdrew3233

    @ljdrew3233

    Жыл бұрын

    @Lucy Bernardi fraudster!!!!

  • @KevLaj
    @KevLaj Жыл бұрын

  • @megadisc1982
    @megadisc1982 Жыл бұрын

    nice review gg well played . . @->-- #POWERGPU #Typicalgamer

  • @eddieme2009
    @eddieme2009 Жыл бұрын

    thanks