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
👉 Take our Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
Fantastic. Thanks, Kenji!
Thank you for the comprehensive tips !😊
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!
Such helpful tutorial thanks for your efforts.
love the f1 analogy and shortcuts are great aswell!!
Part 2, please!!! This content was 10/10
Thank You Kenji. You are awesome. To the point and helpful ideas
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?
Thank you Kenji! Great work. Looked great. Great explanation.
Thank you for the Relevant Content Kenji🙏
Very handy tips. Thank you so much for your sharing!
Awesome use of F1 analogy, love it and the content is great too.
Hi Kenji you are awesome Thank you for sharing the tips & shortcuts Plz make more easy short videos
pt 2 plese thank you as always
@KenjiExplains
2 жыл бұрын
Noted! Thanks for watching as always!
Great info Kenji, thanks!
The F1 references were spot on and overall this was incredibly helpful! Awesome video man!
@novamputra4120
Жыл бұрын
Haha agree
thanks for your hardwork!
this is very helpful.. thanks 👍
Thank you so much, kenji. you are hero 😍😍
Thank you. Great content!
Very Usefull Tips Kenji Thank You Very Much ❤❤❤😊😊
Cool tricks Kenji👌👌👌👌
Amazing! Thanks for this
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!
This is really amazing!!!!!🤩🤩🤩🤩😍😍😍😍🔥🔥🔥🔥
Great. Thank you.
Worth watching... Excellent shortcuts😊... Thank you for sharing it in simple way..
@KenjiExplains
Жыл бұрын
Thanks a lot 😊
Thanks for sharing!
Thanks a lot kenji❤❤❤❤
Thanks for the tips really want to be an expert in this excel software. 5 stars on this vedio
This is soooo cool!
Last two tricks were are cool
Awesome!
...I didn't know the camera tool in excel. I won't use it often but that's a cool feature. Thank you!
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?
Thanks!
informative and excellent
This is really great
that sensei rating with the Alonso add was just perfect.
@KenjiExplains
Жыл бұрын
Hahaha love to hear it! El Plan XD
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.
Brilliant.
Really grear work thanks please would you make video about statement for currunt account for client thanks
That was awesome
Bro very good
Thanks bro
Excel is AMAZING
Very good
Super cool dude
Thanks kenji for your videos then kindly please share the M&E data Analysis about Health Data for Organizations like humanitarian Many Thanks
thx a lot
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
Жыл бұрын
Can you explain to me what a garnishment sheet is? I might be able to help you out
Cool Channel, cheers!
@KenjiExplains
Жыл бұрын
Thanks for watching!
These are very helpful, but can you do a video for Mac users?
master Kenji at it again
@KenjiExplains
Жыл бұрын
Cheers boss!
I love F1, references definitely help lol.
Working at pwc BV right now, was a top performer/ sensei on this skills😅👍🏻
@KenjiExplains
Жыл бұрын
Let's goo
gracias crack
thanks
Great !Thank you
@KenjiExplains
Жыл бұрын
Glad you liked it!
@anandl2003
Жыл бұрын
Yes, some useful excel tips 👍 Appreciate it.
Dude, Haas are crushing this F1 season, so "Rookies" would be inappropriate :D
Could you please make some video for MacBook keyboard.. Many thanks
You can use ALT+O+C+A for auto fit, thanks
I loved that you are giving examples from F1 AHAHAAHAHHAHAHAH COOL DUDE SO COOL
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
2 жыл бұрын
Hey please reach out at info@careerprinciples.com happy to help
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.
Is there a way to build a custom AutoFormat table design?
I cannot use Alt+1 as a screenshot, in the last trick, how do you do it?
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?
Do you know please the equivalent of alt ( access key ) in excel while using MacBook
👌
Awesome video, I have a little trouble keeping up, can you slow down a little?
@notesfromleisa-land
Жыл бұрын
Use the settings gear to slow down playback speed and of course rewind
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
Жыл бұрын
Good question,
@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!
Please Help me , if I press ALT+1 I get Emoji😁 I'm Using Lenovo Laptop Thank you , your Videos are Amazing and Helpful .
Where is the table suggestion in excel? I wasn't able to find it. Can anyone please tell me
Hi Kenji, I'm using Office 16 but some functions do not appear. What excel version are you using?
Does this work for MacOs?
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?
Why tish shortcut " Ctrl+Alt+V" for past value not working?
👍
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
Жыл бұрын
He created the autofit in his tool bar. Its the 6th box in his toolbar. sort of a shortcut.
Amazing series but link to workbook seldom works
@KenjiExplains
2 ай бұрын
hey once you fill the form it should download to your computer/browser downloads folder
I am starting to like you. You are so cute and handsome. Your tips are so helpful.
How to remove commas from the numbers
so handsome and intelligent
shift + f2 for the panel is not working ! office 19
When i Use Alt +5 and Alt +4 not working why?
Mick Schumacher disagrees with the rookie placement
Are you kidding me? Mr Bean driving his car from an armchair strapped to the roof is rookie?!
@KenjiExplains
Жыл бұрын
Hahaha
ctrl shift + doesnt add column or rows. You need to take out the [shift].
@jason19858
Жыл бұрын
You need to select row/colomn first by pressing ctrl +space for column and shift+space for rows, then press ctrl+shift+ +
The real shortcut is buying a subscription to Macabacus and customizing all of these
it's CTRL + to add column not CTRL SHIFT +
@KenjiExplains
Жыл бұрын
It depends on whether you have a numberpad on your keyboard
Nooo not Haas 😭😭😭
@KenjiExplains
2 жыл бұрын
hahaha
Mrs Charlotte is legit and her method works like magic I keep on earning every single week with her new strategy
@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
Жыл бұрын
Her success story is everywhere
@laurajosie9926
Жыл бұрын
Who's this professional everyone is talking about I always see her post on top comment on every KZread video I watched
@laurajosie9926
Жыл бұрын
I think I'm interested how can I get in touch with Mrs Charlotte
@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
*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
Жыл бұрын
@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
Жыл бұрын
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
Жыл бұрын
Go to university.
@ljdrew3233
Жыл бұрын
@Lucy Bernardi fraudster!!!!
nice review gg well played . . @->-- #POWERGPU #Typicalgamer
thanks