The ONLY 10 Excel keyboard shortcuts you need to master

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

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

0% 0

Want to learn some useful Excel shortcuts, but not sure which ones? Here is my choice of top 10 shortcuts to learn. Master these and your productivity will soar.
They are:
1) ctrl t - Create tables
2) ctrl d - Fill down
3) ctrl shift L - Apply / remove filters
4) ctrl arrow keys - Navigation around worksheet
5) ctrl 1 - Format anything
6) ctrl alt v - Paste Special
7) f2 - Edit a cell
8) f4 - Change ref. style / repeat last action
9) f9 - Recalculate / evaluate portions of the formula
10) ALT key - access everything on the ribbon
For a full list of important shortcuts, see this page - chandoo.org/wp/35-tips-data-a...
More:19 of my favourite Excel Shortcuts - • 19 Excel Shortcuts you...
#ExcelShortcuts #Top10Shortcuts

Наука

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

11 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@scottolson4541 4 года назад

This is brilliant...I thought I knew alot of shortcuts...but this had some I didn't AND they are all perfect for what I do!

@srinivasn415 3 года назад

1) ctrl t - Create tables 2) ctrl d - Fill down 3) ctrl shift L - Apply / remove filters 4) ctrl arrow keys - Navigation around worksheet 5) ctrl 1 - Format anything 6) ctrl alt v - Paste Special 7) f2 - Edit a cell 8) f4 - Change ref. style / repeat last action 9) f9 - Recalculate / evaluate portions of the formula 10) ALT key - access everything on the ribbon

@caraziegel7652 2 года назад

huh, i've only used 2, 3, 4, and 10

@kalabhushanam3663 2 года назад

Ctrl+shift+8

@68team 2 года назад

I used all except 9.

@bhavapritaapara9274 2 года назад

Thanks

@angmathew4377 Год назад

you saved our 10 mins. 😂

@y73 3 года назад

Ctrl + Shift + 8 is mind blowing! Thank you so much for these!

@nyancole 2 года назад

Chandoo, you are good at Excel in such a way that you explain so well that the least person with little knowledge understands it perfectly.

@davidhush7772 4 года назад

Brilliant. I always learn something new from these videos.

@sureshy344 4 года назад

Thank you Chandoo for all the excel shotcuts

@raziajeena9861 4 года назад

i love the right mouse key on the keyboard, to access context sensitive menus and love all your explanations. Thanks!

@jermsbestfriend9296 Год назад

Thank you Chandoo

@analiesianogueiracruz6912 Год назад

Thats crazy fine, thanks.

@IASEAGLE5 3 года назад

I've been using CSL for years and it has saved me so much time. Now I see the CS8 and it's going to be a game changer.. thanks!

@jaliali84 4 года назад

Amazing, really helpful

@rakeshchoubay3983 4 года назад

Thank you sir. Its really helpful.

@singhalsachin2003 4 года назад

Great Stuff Chandoo...Thanks for this video.

@yograjmalik165 4 года назад

Appreciate the video!!!

@angmathew4377 Год назад

pure gold. Thank you Sir!

@abdulbasital-sufyani6828 28 дней назад

Always adding value Thanks

@svensonjacob 2 года назад

Awesome video, thank you Chandoo!

@satishkhubchandani520 Год назад

Hi Chando, I wish I had found your channel years back. Although most of these shortcuts are basic but I was not aware of few 2 years ago when you uploaded this video. I am now watching all your videos and learning alot.. Thank You so much! ❤

@vikramgupta3827 3 года назад

The Alt tip is mind blowing, thanks!!!!

@chandoo_ 3 года назад

You bet!

@PaulNordvik 2 года назад

Fantastic List!

@PaulWelsh Год назад

Loving your work Chandoo

@BhageshwarDham-sz7wt Год назад

Wow! Nice one❤

@justjacqueline2004 Год назад

Brilliant.

@pavansuranani6670 4 года назад

Thankyou for this valuable information.You make excel so much easy .Thankyou for the great service 🙏

@ExcelFlash 4 года назад

Thank you! All are very useful. Just need to remember them :)

@galaxyx723 Год назад

very useful,,,, thank you so much

@udhayakhanthl6464 2 года назад

Hey Chandoo, I don't know why I miss this channel. Hey man I am learning from you more..

@mochasweet4966 Год назад

Very useful. Thank you!

@JayshreeZamvar 4 года назад

Hey happy to know that I knew almost all the shortcuts except F4 (use to repeat last action). Love the way you explain !!!

@chandoo_ 4 года назад

Great to hear! :)

@Ar-pl1hl 3 года назад

hey.... same here ... i didnt know f9... happy to know here... thanks to chandoo

@itsdaj Год назад

As always your content is very useful. Thanks Chandoo!!!

@ramachandusharma5867 Год назад

Very useful video. Thanks for sharing

@venkatiyer7459 4 года назад

Thanks again for the nice explanation

@Mu00lia 2 года назад

Thanks 👍

@ExcelWithChris 3 года назад

Great one! Thanks Chandoo.

@chandoo_ 3 года назад

Thanks Chris. :) I am glad you liked this.

@EricaDyson 4 года назад

Perfect! Thanks so much. Really helpful

@chandoo_ 4 года назад

Glad it was helpful!

@lloydmcleod629 2 года назад

This is game-changing

@laurak5196 2 года назад

Congratulations on 200K and thanks so much for all of your time and efforts, Chandoo! We really appreciate you 🙏🏻😀

@chandoo_ 2 года назад

Thanks Laura.. 😀

@aatifrashid5413 2 года назад

Brilliant Explanation

@vk9h 2 года назад

Thanks nice tuto

@querrythis 2 года назад

I like F9. Very useful indeed. BTW, like the jokes. Great sense of humor.

@kimberleyjanecanon1653 Год назад

Your videos are really helpful ❤❤❤❤

@khushdilinsaan3605 2 года назад

thank you sir

@cleofaspintolimalima1627 Год назад

Wonderful teacher

@JasonMilner 2 года назад

I LIKE that F9 formula reveal - many thanks!

@arunsureshbabu2708 4 года назад

Very much helpful.

@mauricelee2219 3 года назад

Very nice, thank you for sharing this video to us.

@parth_pm16 2 года назад

Thanks for making this video! Even I’m learning excel and I got to learn 3 new shortcuts👍

@Global_Analysis 2 года назад

Good move Chandoo

@papachoudhary5482 4 года назад

Thanks! Sir

@suvzar6194 2 года назад

I know I am late but glad to find your channel. Will watch all videos niw

@julitacastro17 2 года назад

very useful😍

@prashantnayak9535 4 года назад

Thanks a lot Sir

@VijayendranRaghavendran 4 года назад

Thanks Chandoo for this informative video. I am giving a tutorial to my lab colleagues and I shall definitely recommend them to watch this video.

@chandoo_ 4 года назад

Thank you. :)

@foodcity9875 Год назад

Great effort and inputs added in your discription it is very useful and you did value added time to everyone 👏❤️ many thanks

@saurabh4294 3 года назад

Thank you Sir 🙏

@chandoo_ 3 года назад

Most welcome

@redheelerdog 4 года назад

Chandoo you are awesome! I have been on your email update list for years and have showed many others how awesome your tips and tricks are, keep up the good work my friend.

@chandoo_ 4 года назад

Awesome! Thank you so much for being a member all these years and supporting my work :)

@joeloffredo204 4 года назад

Awesome - thanks!!

@chandoo_ 4 года назад

You're welcome!

@udayverlekar7172 4 года назад

Thank alott..was really helpfull..

@dkgdkg546 Год назад

YOUR VIDEOS ALWAYS GREAT THANK YOU VERY MUCH.

@belkacemseffari7404 2 года назад

chandooooo you loook amazing with that bear

@chandoo_ 2 года назад

yeah, the 🐻 was heard to control 😂

@nikhilninan210 3 года назад

Really useful! Appreciate your work greatly

@chandoo_ 3 года назад

Glad it was helpful!

@shaguirre 4 года назад

You are the best. Peace

@duarte.arthur 3 года назад

Thanks for the tips Chandoo!! Regards from Brazil!!

@chandoo_ 3 года назад

My pleasure!

@bhupendrabissa2883 4 года назад

Thank You Chandu your Tutorials are truly blessings for me.....thank you so much ❤️

@chandoo_ 4 года назад

Glad to hear that

@rahulshewale9206 4 года назад

Thank you sir , Your video always helpful to me I learn so many things from you, I am always thankful to you.

@evelynwald9132 3 года назад

Wish I had known some of these sooner. Great tips and I love short cuts.

@chandoo_ 3 года назад

Thank you

@krishnabairi1581 3 года назад

I am glad that I use all of the 10 short cut key in my day to day work and good hands on,except F9 something new for me. Thanks for sharing knowledge Chandu.

@chandoo_ 3 года назад

That is awesome...

@muthuraja6589 2 года назад

Mass 10🔥

@chandoo_ 2 года назад

🖐🖐...

@22boali 3 года назад

Simple and professional explanation, thank you very much

@chandoo_ 3 года назад

Glad you liked it

@bijaytanty8434 2 года назад

Thanks

@mohammadjameel3783 4 года назад

Very useful

@sunjulie1009 4 года назад

this is awesome!!!! thank you

@chandoo_ 4 года назад

Glad you like it!

@rautorama 4 года назад

Thanks chandoo..I very often also use ALT +N+V to activate/insert pivot table

@chandoo_ 4 года назад

Great 👍 I normally resort to mouse once Pivots come in to play as there are too many things in Pivots needing mouse use.

@saivardhan500 4 года назад

I have been learning so many things in excel as I was involved in my internship in the very initial days of my Chartered Accountancy course and until now when I'm actually a Chartered Accountant. I'm so grateful and delightful to know all the brilliant smart things in excel from you and the best part is the Wow said by my colleagues when I use these new things in excel (not only shortcuts) which they got to know from me which I had learnt from you........Thanks for your support......Hope you will be teaching us more all the time..!!!

@chandoo_ 4 года назад

Thanks for this beautiful testimonial Sai... :) More awesomeness to you.

@Sai-jh5ti 2 года назад

@@chandoo_ one more CA Student beneficiary here. Thank you chandoo sir

@Nikhilsharma-ry7sh 2 года назад

One more

@_KING_SHADOW 4 года назад

Chandoo i am fan of you. Great. I know most of them but when you explain it is glad to listen.

@chandoo_ 4 года назад

Thank you so much 😀

@terihandrick2333 3 года назад

Thank you Chandoo outstanding as always

@chandoo_ 3 года назад

My pleasure!

@MuraliKrishnaChejerla20101984 4 года назад

Good one

@wayneedmondson1065 4 года назад

Hi Chandoo.. very useful video. I use each of your examples on a daily basis. I would also consider CTRL-Z for undo and CTRL-Y for redo as essential. There are so many good ones. You could easily make the list longer.. which happens naturally.. the more you work with EXCEL. Thanks for the insights. Thumbs up!!

@chandoo_ 4 года назад

Great suggestions. Thanks for the love :)

@Anil_Sapavath Год назад

Gaddam bagundhi annoo...😎💖

@Merewah97 2 года назад

Hi Chandoo. Can u the next 10 best shortcuts? That’d b awesome

@jagatkrishna1543 2 года назад

Great 👍

@chandoo_ 2 года назад

Thank you 👍

@asifgulfarosh6732 3 года назад

Lot of learning going on from your playlist thanks sir

@chandoo_ 3 года назад

You are most welcome

@ASHOKKUMAR-jm6yn 3 года назад

Lots of love to u chandu

@chandoo_ 3 года назад

Thank you Ashok.

@maurolimaok 3 года назад

Nice video. Thanks!

@chandoo_ 3 года назад

Glad you liked it!

@claudegiguere8731 Год назад

I wish I knew you before, I really appreciate your work Chandoo, many thanks 😊 I will let you know if I find a shortcut for the dishes... 😅

@Sreejithmusic Год назад

Thanks bro for all the valuable information and you remind me of one of my buddies🙂

@adrianaghita1520 2 года назад

Many thanks ,there are very usefuly in my financial work

@CoderWave Год назад

Wow I use all of em

@rahulchopra2030 4 года назад

Master of the excel .. Excel Guru... sir it’s the best explanation of the shortcuts given by anyone. Thank you sir... Your work is phenomenal

@chandoo_ 4 года назад

Thanks Rahul. This is new format of video I am experimenting and I am glad you liked it. :)

@rautorama 4 года назад

This top 10 of all could become the next hot video series...top 10 excel short cuts..top 10 excel mistakes...top ten excel interview questions....Top 10 excel functions...and so much more

@chandoo_ 4 года назад

@@rautorama Are you using FORECAST.ETS()? That is what I have in mind...

@mohitagarwal437 3 года назад

Brilliant sir

@chandoo_ 3 года назад

Thanks Mohit...

@FRANKWHITE1996 4 года назад

Thank you.

@chandoo_ 4 года назад

You're welcome!

@user-wm1bs5pf5e 7 месяцев назад

Chandoo looking like a Saint 😅

@binishthomas2675 Год назад

<a href="#" class="seekto" data-time="259">4:19</a> which is better, 'Ctrl Shift 8' or just 'Ctrl A'. I use 'Ctrl A' as its easy and I can always go for 'Ctrl AA' if want to select the whole sheet. genuinely asking Why is 'Ctrl Shift 8' is preferred? 🤔 what am I missing?

@metinguler 4 года назад

Thank you...

@chandoo_ 4 года назад

Welcome

@philippehenrion5199 4 года назад

Hi Chandoo, I always thought the D in Ctrl-D was for Down (from Fill-Down), as R in Ctrl-R is for Right (from Fill-Right)

@brendensong8000 3 года назад

Thank you for saving many hours of clicking same keys working on my excel spreadsheets!

@chandoo_ 3 года назад

I hate click tax...

@SanthoshKumar-xy3zm 3 года назад

Very helpful....I was not knowing many.Thank you....🙏🙏🙏🙏🙏

@chandoo_ 3 года назад

My pleasure 😊

@thangaveluraj5366 4 года назад

Very very useful, thank you so much. One more suggestion for your kind consideration: "alt + =" very often used for summing up. Shortcut for the function: autosum

@chandoo_ 4 года назад

Great tip!