🚀 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
@abhigaurav5 ай бұрын
also tell these shortcuts for mac
@MyoAung-u4x24 күн бұрын
can,t download sir.
@dominatorgaming2980 Жыл бұрын
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 👍👍👍👍❤️❤️❤️
@BURTONizAjerK7 ай бұрын
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.
@denizbeytekin9853Ай бұрын
how did you become a strong excel user?
@godofthebiblespeaks3188 Жыл бұрын
This video is like gold! I love Excel but there were many shortcuts that I wasn’t aware of. Thanks for posting!
@edumas870611 ай бұрын
Very compact, no fluff presentation. An easy 9.5/10.
@Spratik1_2_69 ай бұрын
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
@doristhecoder765 Жыл бұрын
I promise you if we are ever in the same location, I will buy you lunch or coffee! You taught me so much!!!! :)
@alfredrudolph39815 ай бұрын
Thanks you for the videos. For Tip Number 8, try ctrl + shift + v to paste only the value
@michaelsamazingenglish8580 Жыл бұрын
This is the most useful video I've seen on Excel here on KZbin. Thank you! Great job!
@Adam_K_W Жыл бұрын
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 Жыл бұрын
Thanks so much
@Joshisanalcoholic2024 Жыл бұрын
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
@princecamm7 ай бұрын
wer u at now
@Skitsfosho1 Жыл бұрын
I loved the Formula 1 Sales Person list!! Huge fan! Your videos are very insightful and easy to follow.
@MuhammadDanish-r9x6 ай бұрын
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 :)
@nektarsolne4niy804 Жыл бұрын
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.
@adyan40103 ай бұрын
thanks for the tip
@morganwilson641 Жыл бұрын
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.
@william_acca Жыл бұрын
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. 🙂❤👍👍👍
@sixmilsixКүн бұрын
Very helpful a few I did not know
@GopeshSharma-nq6cd5 ай бұрын
Thank You for such informative video- Crisp and Clear
@midoboy71229 күн бұрын
Thanks, it was really useful
@A-broken-clay-jarКүн бұрын
Alt Down Arrow is cool. I never heard of it.
@edwinmarume44388 ай бұрын
thank u for posting
@Lord266143 ай бұрын
Bro I love you for this video. Be blessed and healthy ♥️
@deemaalwahaibi30502 ай бұрын
thanks, your channel is what I need
@ThatAyoBankole2 ай бұрын
Thank you, Kenji!
@henrycollins5699 ай бұрын
Love your videos. Thanks for sharing, keep it up!
@miskalhakeem6 ай бұрын
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
@salmaalaa6158 Жыл бұрын
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
@accountingcambodia4 ай бұрын
Thanks for sharing this tip
@famahsnazer3494 Жыл бұрын
Great, thanks
@CJJamieson-gq2tj Жыл бұрын
#1 Quick access toolbar. Freeze pane short cut.
@davidmelinda21629 ай бұрын
This is very useful thank you
@sohambansal4175 Жыл бұрын
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
@CharliesMaidenCovers Жыл бұрын
epic man. thanks for that. thumbs up for non clickbait
@JaisonMathewJacob9 ай бұрын
Many thanks for this video!! God bless!!
@laluyank4452 Жыл бұрын
Great content as always! Thank you very much.
@ryyyyy20106 ай бұрын
Really helpful man!
@solomonbhandari-young4154 Жыл бұрын
Kenji always killing it
@KenjiExplains Жыл бұрын
vamossss
@KChrisWatching8 ай бұрын
Is F4 (replicate last step) same as control Y ? Btw thank you so muchhh! Great video!
@wooddog007 Жыл бұрын
Thanks
@KenjiExplains Жыл бұрын
Thank you for supporting!
@IntricateMoon Жыл бұрын
THANK YOU KENJI!!! 🤩
@raokh.7156 ай бұрын
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)?
@OfficeOnly7 ай бұрын
Thanks so much
@RohitThakur-en7qw Жыл бұрын
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
@ernestmokiwa4702 Жыл бұрын
I like the way you make everything look so easy
@SuperKazekageSama9 ай бұрын
Thanks!!
@hisokaamorou4211 Жыл бұрын
Hats off to you Sir Kenji!
@eulercarta997 Жыл бұрын
thanks for these tips... 👍
@KenjiExplains Жыл бұрын
Thanks for your support!
@granttischner22859 ай бұрын
dude alt equals just changed my life
@vikramadityarathore97 Жыл бұрын
very handy shortcuts mate! keep it up!
@jamescarew8525Ай бұрын
dope!, thank you brother :"}
@granttischner22859 ай бұрын
alt h v v for paste values as well
@mdiradshaikh77198 ай бұрын
3:17 Kenji literally made F1 drivers.....beverage salesmen.😂 Not kidding but this video is actually very helpful.😉👍
@KenjiExplains8 ай бұрын
Hahaha glad someone noticed 😂😂
@yousseffarachi94222 ай бұрын
Thank you dear
@richardgherlo7842 Жыл бұрын
The last one is dope! 👌🏻😂
@Eskatalogiya4 ай бұрын
Thank you
@haidyray191213 күн бұрын
Your great
@skiboltskieskye1238 Жыл бұрын
#17. Ace !!
@XLLearner_Courses Жыл бұрын
Great time savers
@hxjdjdn62368 ай бұрын
Some of these just becomes second nature, but hands on heart who remembers some random letter combinations when you could just click 😂
@Skye_N Жыл бұрын
You just earned yourself a subscriber on the first video.
@peterbrpwm8544 Жыл бұрын
Can you make some Microsoft access videos
@bijaytanty8434 Жыл бұрын
Thanks Sir
@dr.jallohinnovativechannel Жыл бұрын
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?
@Hello_Friends Жыл бұрын
Thank You So Much 🥰.
@camlex6310 Жыл бұрын
Wow great tips!!
@KenjiExplains Жыл бұрын
Thanks for watching!!
@ovskihouse527111 ай бұрын
Thanks bro
@Muhammad_Asif_Pk7 ай бұрын
Sir for inserting row and column Correct shortcut is CTRL + PLUS instead of CTRL + SHIFT+ PLUS
@OmniKsK Жыл бұрын
Alt+ T+ U+ T is something new
@Ragehunter5 ай бұрын
3:39 life saving
@nikhilshetty5944 Жыл бұрын
Great video. Thank you
@KenjiExplains Жыл бұрын
Thanks for watching!
@adarshpatni9421Ай бұрын
1st trick useful
@putuindahratnasari75685 ай бұрын
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 😍 😍
@_symmetry_ Жыл бұрын
Quick update for #8: there's a new shortcut for "paste as values" which is CTRL+SHIFT+V
@graymattertalks Жыл бұрын
thanks a lot. can you please share a pdf of the shortcuts?
@michaelquach7046 Жыл бұрын
Flash fill let’s goooo
@KenjiExplains Жыл бұрын
vamooses
@theterminaldave Жыл бұрын
Where have you been all my life control+E? i can't imagine how much time that would have saved me.
@ian10432 Жыл бұрын
Thank u so much
@LeanIsagunde Жыл бұрын
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
@FelipeSantiagoCouohPech Жыл бұрын
Muchas gracias. Buscando sus correspondientes en español.
@carrieng42722 ай бұрын
can you do a video on short cuts with mac keyboard vs pc?
@stefanobordo9416 Жыл бұрын
Very helpful video!
@saunaboi5866 Жыл бұрын
alt W F R freeze pane
@SleepyBarbecue-dh2no4 ай бұрын
Too ezzzz for me teach us some thing hard 😊
@atiqrehman1223 Жыл бұрын
excellent
@oshadhaprasad7978 Жыл бұрын
soo clear brilliant😍
@evicabartoskova52086 ай бұрын
Hello there In shortcut 10 to separate first name and last name in different columns Ctrl+E doesn’t work must be something else to do before the shortcut but I don’t know what? Please could you help me with that?
@yogeshshindecompany7 ай бұрын
Useful video
@harshbiswari1611 Жыл бұрын
Awesome
@ExceluniForAll Жыл бұрын
That's great😊
@catvids87862 ай бұрын
Thanj u
@ggas33dfdf Жыл бұрын
Just press F2 to get into cell and change content. No need for the mouse ;)
@user-qf2jc7kl3u Жыл бұрын
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 ?
@RedsparInvesting Жыл бұрын
Very helpful but ctrl one does not work to change currency? I have excel 2010
@judahnmatsaba7126 Жыл бұрын
Wow bro that first hack astonished me, I really toiled aimlessly scrolling up when faced with this issue. Thank you.
@KenjiExplains Жыл бұрын
thanks for the nice comment :)
@mdshibli10094 ай бұрын
are you Excel specialist. ❤❤❤
@nihayatsabah3063 Жыл бұрын
Well done Thank ☺️☺️☺️👏❣️❣️
@KenjiExplains Жыл бұрын
Thank you!
@yousseffarachi94222 ай бұрын
Keep going
@samsplayground8646 Жыл бұрын
you're awesome
@erlinmartos7941 Жыл бұрын
informative
@JohnDoe-ed7vw5 ай бұрын
I love Alt+Down Arrow tip, but the last two shortcuts don't work, I even searched and can't find anything, one of them seem related to some 3rd party app, the other is also a mystery, this video seem to be for an old excel version? if anyone figured them plz let me know