20 Excel Shortcuts to Save You HOURS of Work
Learn 20 Excel shortcuts to boost your productivity at work.
🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/gkx
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/639320...
In this video, you'll learn 20 awesome excel shortcuts to save you hours of time. These shortcuts range from basic ctrl key shortcuts to more complex alt key shortcuts and beyond.
Among the most useful are the flash fill, autosum, freeze panes, and trace precedents. Stick around until the end for the coolest tricks!
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Пікірлер: 180
🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/gkx
@solomonbhandari-young4154
Жыл бұрын
Awesome
@wirdauncu7511
Жыл бұрын
can this method be used on a macbook?
@shreyashpatil4261
Жыл бұрын
not donloding
@abhigaurav
Ай бұрын
also tell these shortcuts for mac
This video is like gold! I love Excel but there were many shortcuts that I wasn’t aware of. Thanks for posting!
One recommendation - Don't join any coaching centres for learning excel, Just watch his all videos you will be knack of in excel. What he teaches are very practical, Want more videos 👍👍👍👍❤️❤️❤️
Hi! Mr.Kenji. Thanks so much indeed for sharing. All your lessons are very much beneficial and useful to me. Wish you a happy new year, and many many prosperous and successful years ahead. 🙂❤👍👍👍
This is the most useful video I've seen on Excel here on KZread. Thank you! Great job!
I consider myself a pretty strong excel user. This video was invaluable for me, this video will help me save some time at work. Thanks for putting this together man.
Very compact, no fluff presentation. An easy 9.5/10.
Great content as always! Thank you very much.
Hats off to you Sir Kenji!
Love your videos. Thanks for sharing, keep it up!
Many thanks for this video!! God bless!!
Your vids are absurdly helpful. Am currently a junior in college studying finance. Trying to get an edge over my peers, this helps a ton
@princecamm
3 ай бұрын
wer u at now
Thank You for such informative video- Crisp and Clear
I like the way you make everything look so easy
Very helpful video!
I loved the Formula 1 Sales Person list!! Huge fan! Your videos are very insightful and easy to follow.
@user-jy8xx8ql8c
2 ай бұрын
total agree Sir.. This one tutor is so so best to explaining the each step, and his accent is very well, thank to you dear Owner of the video :)
THANK YOU KENJI!!! 🤩
thank u for posting
soo clear brilliant😍
For #8, you should use the alternate drag and drop function. Simply select the data, mouse over the border of the selected data to get the 4 way arrow, right click, drag and let go where you want to drop, then select "paste here as values"
@sallyho146
Жыл бұрын
How to jndo the gabke?
@jeanetteagain6631
9 ай бұрын
Thanks so much
You just earned yourself a subscriber on the first video.
Great, thanks
Why is nobody mentioning F2 key? This works in Windows in general, but it's so helpful to use in Excel to modify cells. Just use F2 and your cursor will immediately go to the last character of the cell you're in.
Thank You So Much 🥰.
very handy shortcuts mate! keep it up!
Alt + E + S + V will give you paste as values a tiny bit quicker
@colluminati2988
Жыл бұрын
Niceee
@ManishSharmaX
Жыл бұрын
Yes
@suehallstrom3666
Жыл бұрын
Carl alt v even quicker
@clabough501
Жыл бұрын
@@suehallstrom3666 that’s what I was coming to say! Game changer
@kevinbush4300
Жыл бұрын
Alt, E, S, V is a legacy shortcut, i think... pre-2013, maybe even earlier. Alt, H, V, V would be the equivalent now.
Perfect ❤️❤️
Thanks a lot!
I promise you if we are ever in the same location, I will buy you lunch or coffee! You taught me so much!!!! :)
Really helpful man!
This is very useful thank you
Great time savers
The last one is dope! 👌🏻😂
Thanks for the shortcuts. Very informative. Question:: If I want to highlight an entire roll and then check subsequent roll but still remain highlighted using the down arrow, what is the shortcut or syntax for such?
Tip for future videos INCASE you dont already do that is the leave the shortcut on the screen for the remainder of the explanation of it. Cause it disappears too quickly
Thanks for sharing this tip
Great video. Thank you
@KenjiExplains
Жыл бұрын
Thanks for watching!
thanks for these tips... 👍
@KenjiExplains
Жыл бұрын
Thanks for your support!
Wow great tips!!
@KenjiExplains
Жыл бұрын
Thanks for watching!!
Thanks!!
Thanks so much
Thank u so much
epic man. thanks for that. thumbs up for non clickbait
Thank you
Kenji always killing it
@KenjiExplains
Жыл бұрын
vamossss
That's great😊
Thanks Sir
#17. Ace !!
Useful video
Thanks bro
Thanks you for the videos. For Tip Number 8, try ctrl + shift + v to paste only the value
Well done Thank ☺️☺️☺️👏❣️❣️
@KenjiExplains
Жыл бұрын
Thank you!
Awesome
excellent
Flash fill let’s goooo
@KenjiExplains
Жыл бұрын
vamooses
you're awesome
helpful
#1 Quick access toolbar. Freeze pane short cut.
informative
Too ezzzz for me teach us some thing hard 😊
useful
Thanks
@KenjiExplains
Жыл бұрын
Thank you for supporting!
thank you Mr. kenji for your effort and all your amazing video its useful for us. but can ask you about back music its interrupt us we not native English listener . could you mute it ,chalk if you can please
dude alt equals just changed my life
for adding a row, i use alt+I+R. for adding a column, I use alt+I+C. for pasting values, i use alt+h+v+v
00:06 These Excel shortcuts can save you hours of time. 01:44 Excel shortcuts for navigating and editing data quickly 03:24 Excel shortcuts for efficient navigation and formatting 04:56 Save time with Excel templates for visualizing data 06:40 Excel shortcuts to copy and paste values and perform formatting 08:15 Use shortcuts to quickly format cells and replicate steps. 09:53 Filter data using Excel shortcuts 11:34 Using large function for ranking in Excel
Yes sweet lemonade
3:17 Kenji literally made F1 drivers.....beverage salesmen.😂 Not kidding but this video is actually very helpful.😉👍
@KenjiExplains
4 ай бұрын
Hahaha glad someone noticed 😂😂
ohhhhhhhhhhhhhhhhhhh myyyyyyyyyyyyyyyyyyy goddddddddddddddddddddddddd !!!! what a epic video
thanks a lot. can you please share a pdf of the shortcuts?
alt h v v for paste values as well
Alt+ T+ U+ T is something new
3:39 life saving
Can you make some Microsoft access videos
Muchas gracias. Buscando sus correspondientes en español.
Seeing that simple drag & drop'ing of lines/columns almost made me cry.
are you Excel specialist. ❤❤❤
Thank you for the very informative video. I only met 1 problem when trying all 20 shortcuts. When I used Ctrl + space it selects the whole spreadsheet instead of selecting the column. What could be the problem with my excel?
@mohammedsamiuddin6401
Жыл бұрын
If the cells are merge it select whole data
Is F4 (replicate last step) same as control Y ? Btw thank you so muchhh! Great video!
Hi Kenji can we also freeze the first column along with the first row in a spreadsheet, and any way to freeze other rows or columns (other than the first)?
Hey Kenji in my Laptop i am unable to Switch between Sheets by Pressing Ctrl + page up/down. Is there any another shortcut??? Please Check
Cnrtl+ V, Cntrl then V will also give you paste as value
Where have you been all my life control+E? i can't imagine how much time that would have saved me.
alt W F R freeze pane
Some of these just becomes second nature, but hands on heart who remembers some random letter combinations when you could just click 😂
Sir for inserting row and column Correct shortcut is CTRL + PLUS instead of CTRL + SHIFT+ PLUS
Hi hoping you can help me, I have 10 candidates who all work monday to friday and also clean 7 different types of rooms at varying pay rates, how I can I show the breakdown of how many rooms each person has cleaned each week and what the total pay should be ?
Wow bro that first hack astonished me, I really toiled aimlessly scrolling up when faced with this issue. Thank you.
@KenjiExplains
8 ай бұрын
thanks for the nice comment :)
You can spot an Excel expert right away just by looking at the spreadsheet. If you don't see the gridlines they are experts, if you can see it they are no experts.
Hallo! Thank you for this tutorial, you make me smarter and easier working in excel. However, i have some issues: 1. why i cant do the jump to other sheet ctrl + page down or even by using FN 2. i also find we are difference in checking formulas of "intern", when i do enter ctrl + ' i got the formula but no arrow appears also the formula shown only when i still in the cell, when i move, the shown formula does not came out again 3. the other one, i am also trying the F4 formula to copy the format, but pity it does not work in my excel. why and what is the solution for that? i am using windows 11 and my microsoft no account , i dont know why because my IT dept sett it. even my windows button can not work also. Thank you for helping me, hope your day brighter and full of love 😍 😍
crtl 1 formula box ctrl g
Pt 2 please sir
@KenjiExplains
Жыл бұрын
Let's go!
Just press F2 to get into cell and change content. No need for the mouse ;)
No one: Kenji: I have trust issues on interns.
Alt + ; to Select Visible Cells
Very helpful but ctrl one does not work to change currency? I have excel 2010
6:11 They are definitely not a salesperson 😂😂😂😂
Do you know of a template excel 2010 with active stock price?
Can you recommend a book that has all of these shortcuts?
To find out if there is any common hour (in Column A) at a specific site where cell availability has been below 98.0% for the last 3 days (from 07/09/2023 to 09/09/2023) within the given ranges,