20 Excel Shortcuts to Save You HOURS of Work

Подписаться 509 тыс.

Просмотров 691 тыс.

50% 1

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.

Опубликовано:

17 дек 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 174

@KenjiExplains Год назад

🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/gkx

@solomonbhandari-young4154 Год назад

Awesome

@wirdauncu7511 Год назад

can this method be used on a macbook?

@shreyashpatil4261 11 месяцев назад

not donloding

@abhigaurav 20 дней назад

also tell these shortcuts for mac

@godofthebiblespeaks3188 Год назад

This video is like gold! I love Excel but there were many shortcuts that I wasn’t aware of. Thanks for posting!

@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. 🙂❤👍👍👍

@michaelsamazingenglish8580 11 месяцев назад

This is the most useful video I've seen on Excel here on RU-vid. Thank you! Great job!

@alfredrudolph3981 День назад

Thanks you for the videos. For Tip Number 8, try ctrl + shift + v to paste only the value

@edumas8706 6 месяцев назад

Very compact, no fluff presentation. An easy 9.5/10.

@dr.jallohinnovativechannel 11 месяцев назад

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?

@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 👍👍👍👍❤️❤️❤️

@BURTONizAjerK 2 месяца назад

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.

@laluyank4452 Год назад

Great content as always! Thank you very much.

@Donkeys_Dad_Adam Год назад

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 8 месяцев назад

Thanks so much

@ryanwesterfield6251 Год назад

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 2 месяца назад

wer u at now

@hisokaamorou4211 Год назад

Hats off to you Sir Kenji!

@miskalhakeem Месяц назад

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

@Skitsfosho1 10 месяцев назад

I loved the Formula 1 Sales Person list!! Huge fan! Your videos are very insightful and easy to follow.

@user-jy8xx8ql8c Месяц назад

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 :)

@JaisonMathewJacob 4 месяца назад

Many thanks for this video!! God bless!!

@ernestmokiwa4702 Год назад

I like the way you make everything look so easy

@henrycollins569 4 месяца назад

Love your videos. Thanks for sharing, keep it up!

@GopeshSharma-nq6cd 12 дней назад

Thank You for such informative video- Crisp and Clear

@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.

@raokh.715 Месяц назад

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)?

@stefanobordo9416 Год назад

Very helpful video!

@doristhecoder765 Год назад

I promise you if we are ever in the same location, I will buy you lunch or coffee! You taught me so much!!!! :)

@Skye_N Год назад

You just earned yourself a subscriber on the first video.

@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

@IntricateMoon 11 месяцев назад

THANK YOU KENJI!!! 🤩

@RohitThakur-en7qw 8 месяцев назад

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

@sohambansal4175 9 месяцев назад

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

@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

@oshadhaprasad7978 Год назад

soo clear brilliant😍

@user-qf2jc7kl3u 11 месяцев назад

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 ?

@vikramadityarathore97 Год назад

very handy shortcuts mate! keep it up!

@graymattertalks Год назад

thanks a lot. can you please share a pdf of the shortcuts?

@Hello_Friends Год назад

Thank You So Much 🥰.

@richardgherlo7842 Год назад

The last one is dope! 👌🏻😂

@sudarshanikumari2385 Год назад

Perfect ❤️❤️

@davidmelinda2162 3 месяца назад

This is very useful thank you

@JohnDoe-ed7vw 9 дней назад

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

@evicabartoskova5208 Месяц назад

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?

@ryyyyy2010 Месяц назад

Really helpful man!

@edwinmarume4438 3 месяца назад

thank u for posting

@CJJamieson-gq2tj Год назад

#1 Quick access toolbar. Freeze pane short cut.

@putuindahratnasari7568 19 дней назад

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 😍 😍

@nikhilshetty5944 Год назад

Great video. Thank you

@KenjiExplains Год назад

Thanks for watching!

@KChrisWatching 3 месяца назад

Is F4 (replicate last step) same as control Y ? Btw thank you so muchhh! Great video!

@shyamakar3129 8 месяцев назад

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,

@RedsparInvesting Год назад

Very helpful but ctrl one does not work to change currency? I have excel 2010

@XLLearner_Courses 7 месяцев назад

Great time savers

@eulercarta997 Год назад

thanks for these tips... 👍

@KenjiExplains Год назад

Thanks for your support!

@CharliesMaidenCovers 8 месяцев назад

epic man. thanks for that. thumbs up for non clickbait

@granttischner2285 4 месяца назад

alt h v v for paste values as well

@stelliomariomartelli Год назад

Thanks a lot!

@evicabartoskova5208 Месяц назад

Hello there Could you please help me with shortcut where you want to live comment on row or cell This your shortcut have something else before and I don’t know how to do it? Thanks

@RedsparInvesting Год назад

Do you know of a template excel 2010 with active stock price?

@OfficeOnly 2 месяца назад

Thanks so much

@SuperKazekageSama 4 месяца назад

Thanks!!

@camlex6310 Год назад

Wow great tips!!

@KenjiExplains Год назад

Thanks for watching!!

@famahsnazer3494 Год назад

Great, thanks

@Muhammad_Asif_Pk 2 месяца назад

Sir for inserting row and column Correct shortcut is CTRL + PLUS instead of CTRL + SHIFT+ PLUS

@FelipeSantiagoCouohPech 10 месяцев назад

Muchas gracias. Buscando sus correspondientes en español.

@solomonbhandari-young4154 Год назад

Kenji always killing it

@KenjiExplains Год назад

vamossss

@animallovers1859 11 месяцев назад

Cnrtl+ V, Cntrl then V will also give you paste as value

@mdiradshaikh7719 3 месяца назад

3:17 Kenji literally made F1 drivers.....beverage salesmen.😂 Not kidding but this video is actually very helpful.😉👍

@KenjiExplains 3 месяца назад

Hahaha glad someone noticed 😂😂

@jennifergribbins4560 Год назад

Can you recommend a book that has all of these shortcuts?

@peterbrpwm8544 Год назад

Can you make some Microsoft access videos

@nihayatsabah3063 Год назад

Well done Thank ☺️☺️☺️👏❣️❣️

@KenjiExplains Год назад

Thank you!

@adriandiaz3189 Год назад

Thank u so much

@yogeshshindecompany 2 месяца назад

Useful video

@ExceluniForAll 8 месяцев назад

That's great😊

@emilioskav Год назад

Seeing that simple drag & drop'ing of lines/columns almost made me cry.

@ovskihouse5278 6 месяцев назад

Thanks bro

@bijaytanty8434 7 месяцев назад

Thanks Sir

@hxjdjdn6236 3 месяца назад

Some of these just becomes second nature, but hands on heart who remembers some random letter combinations when you could just click 😂

@maricelagutierrez816 3 месяца назад

F4 to copy the same format didn't work for me. It switches my tabs instead.

@granttischner2285 4 месяца назад

dude alt equals just changed my life

@harshbiswari1611 8 месяцев назад

Awesome

@skiboltskieskye1238 11 месяцев назад

#17. Ace !!

@atiqrehman1223 11 месяцев назад

excellent

@leelavathileela7325 13 дней назад

Unable to see short cut keys because of discription

@Spratik1_2_6 4 месяца назад

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

@Ragehunter 6 дней назад

3:39 life saving

@erlinmartos7941 9 месяцев назад

informative

@josevalderrama7243 Год назад

Do you know how to create a food cost calculator?

@pratikdalvi4250 Год назад

helpful

@theterminaldave Год назад

Where have you been all my life control+E? i can't imagine how much time that would have saved me.

@michaelquach7046 Год назад

Flash fill let’s goooo

@KenjiExplains Год назад

vamooses

@Bd_viewsnews 7 месяцев назад

useful

@wooddog007 Год назад

Thanks

@KenjiExplains Год назад

Thank you for supporting!

@saunaboi5866 Год назад

alt W F R freeze pane

@hollaaturb 2 месяца назад

What are these keys on the mac book somebody help please

@leoaxbxs Год назад

Alt + ; to Select Visible Cells

@saunaboi5866 Год назад

crtl 1 formula box ctrl g

@mikatu Год назад

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.