Тёмный

5 Awesome Excel Keyboard and Mouse Tricks 

TrumpExcel
Подписаться 368 тыс.
Просмотров 37 тыс.
50% 1

In this video, I cover some amazing keyboard and mouse tricks for Excel that will save you some time in your day-to-day work.
The following Excel keyboard and mouse tricks are covered:
00:00 Intro
00:15 Quickly Move Rows and Columns in Excel
02:18 Quickly Copy Rows and Columns in Excel
03:29 Copy Worksheets
05:39 Insert Rows/Columns in Existing Dataset
06:42 Deselect Cells
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

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

 

12 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 89   
@michelbaudoinca
@michelbaudoinca Год назад
Thank you Very much Sumit ! Always helpfull !
@junaopako
@junaopako 4 года назад
Thanks man, you're a doctor for Excel
@trumpexcel
@trumpexcel 4 года назад
Thanks for the kind words... Glad you liked the video!
@pari4453
@pari4453 2 года назад
I'm glad i saw your video this is excellent, great work sumit luv the way you explain
@gauravbhasin757
@gauravbhasin757 3 года назад
Awesome man
@karthikrajgopal8627
@karthikrajgopal8627 4 года назад
Thanks very informative video..
@tedmoy
@tedmoy 2 года назад
You're the best Mr. Bansal
@rjbanavar
@rjbanavar 3 года назад
Deselect the Cells and Copy of the Sheets with (Year) / (Q1) is awesome trick, Thanks a lot helps big time
@krishnamurthyramanathan1795
@krishnamurthyramanathan1795 4 года назад
Thanks
@anusree1611
@anusree1611 4 года назад
Very good tips. Grateful
@andrewshepherd6816
@andrewshepherd6816 4 года назад
Well explained 👍 You certainly get to the point without any unnecessary waffle 🙂 Cheers
@sguptamech
@sguptamech 3 года назад
Super tips
@monicacato999
@monicacato999 4 года назад
Great tips !
@bycottfrenchproducts.mukht1189
@bycottfrenchproducts.mukht1189 3 года назад
Great, thanks.
@ashubedi4078
@ashubedi4078 2 года назад
You really have indeed awesome knowledge
@meshafeeqmuhammed983
@meshafeeqmuhammed983 3 года назад
Wow... Really help full Excell Guru
@deepikagaddam5764
@deepikagaddam5764 2 года назад
Seriously you are awesome
@Rahulkumar-he4sk
@Rahulkumar-he4sk 2 года назад
Thank you, Sir very informative video
@meetkcs
@meetkcs 4 года назад
Sumit is Excelled in Excel Excellently. Awesome shortcut key combinations, Very productive in Real-time application.
@murtazasimari8850
@murtazasimari8850 Год назад
Bless you...nice video
@emmaleeholzheimer5118
@emmaleeholzheimer5118 4 года назад
Thanks, I learn so much with your excel training.
@MareeTeolanafo
@MareeTeolanafo 4 года назад
Another informative video. I love all of them!
@sekhar6106
@sekhar6106 4 года назад
Thank you. Will practice this to be familiar with the tricks...
@woutervandenheever8999
@woutervandenheever8999 4 года назад
Very good! Thanks.
@indrapahlefi828
@indrapahlefi828 4 года назад
Thank you Summit...
@vaishalipathak7863
@vaishalipathak7863 4 года назад
All the tricks you share are very much useful and increases efficiency to a big extent. Thanks for sharing!
@tarawalters815
@tarawalters815 4 года назад
THANK YOU!
@priyanthiabayasekara8819
@priyanthiabayasekara8819 4 года назад
Thanks for sharing these tips. much appreciated.
@sinhalafilmsub308
@sinhalafilmsub308 4 года назад
Hi If you want to know about Excel macro and customized functions, contact me "nelson.rodrigo@gmail.com"
@Ff13jap
@Ff13jap 3 года назад
Awsome! 👍👍
@johnborg5419
@johnborg5419 4 года назад
Thanks Sumit. This helps alot!!! : )
@KaileshHambireIJ-G-
@KaileshHambireIJ-G- 4 года назад
Thank you very much for this update. Keep updating us with your valuable knowlege.
@mahansor8295
@mahansor8295 4 года назад
Thanks, great
@deepaknagar5697
@deepaknagar5697 4 года назад
Your videos are always awesome, thanks.
@mhammad3492
@mhammad3492 4 года назад
Thank you 🌹
@storytime5108
@storytime5108 3 года назад
Thanks Sumit
@nidhiachhaa2731
@nidhiachhaa2731 4 года назад
Wonderful tips💡
@JahangirAlam-zz9ex
@JahangirAlam-zz9ex 3 года назад
nice and excellent
@trumpexcel
@trumpexcel 3 года назад
Glad you found the video useful!
@kamlabimla
@kamlabimla 4 года назад
Thanks Sumit!! Keep it up
@trumpexcel
@trumpexcel 4 года назад
Glad you liked the video Swati!
@shahulhameed-dc2fz
@shahulhameed-dc2fz 3 года назад
Excellent
@afruitaday
@afruitaday 3 года назад
These tricks are great. You nailed it Mr. Sumit Bansal
@sinhalafilmsub308
@sinhalafilmsub308 4 года назад
Thank you very much!!
@wayneedmondson1065
@wayneedmondson1065 4 года назад
Hi Sumit.. truly said.. all the tricks you showed are awesome! I knew a few and learned a few new ones :)) Thanks for sharing and Thumbs up!!
@tsvs58
@tsvs58 4 года назад
Very useful and interesting. Thanks
@SnipSnapDragon24
@SnipSnapDragon24 4 года назад
Your videos are always wonderful and very much appreciated. Thank you.
@trumpexcel
@trumpexcel 4 года назад
Thanks Chris... Glad you're finding the videos useful!
@keithau8159
@keithau8159 3 года назад
Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,except my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@
@shubhamgupta4U
@shubhamgupta4U 4 года назад
Awesome tricks
@vishalsheth506
@vishalsheth506 4 года назад
Amazing tricks...Didn't know about this...
@ramseshu110
@ramseshu110 4 года назад
Excellent 👍
@VinodKRamachandra
@VinodKRamachandra 4 года назад
Cool little tricks. Thank you Sumit
@trumpexcel
@trumpexcel 4 года назад
Glad you found the video useful Vinod!
@rajeevgosavi4514
@rajeevgosavi4514 3 года назад
I always appreciate your videos on various topics, as they are easy to understand. You have a unique way of explaining.Can I request you to upload a video on tab control techniques.
@basis_tech4555
@basis_tech4555 3 года назад
Thanks for sharing..really very useful in day to day tasks on excel
@reshmasaldanha5087
@reshmasaldanha5087 4 года назад
Excellent. I have recently subscribed your you tube channel & it's really helpful. A big thank you. You are a wonderful teacher.
@mdexcelpro8495
@mdexcelpro8495 4 года назад
Excellent and very helpfull & useful tips thanks of lots
@samuelmeende2325
@samuelmeende2325 4 года назад
Thanks man
@FaysalEasyExcel
@FaysalEasyExcel 4 года назад
Thanks. it's really awesome.
@masudbin-arazzaque4295
@masudbin-arazzaque4295 3 года назад
Very useful trick
@BARATHICREATIVES
@BARATHICREATIVES 4 года назад
Thanks... very useful
@amralkady6929
@amralkady6929 3 года назад
Thanks 👏👏 alot
@mdsajji6290
@mdsajji6290 4 года назад
It's really cool and mind blowing tricks Bro. Appreciated.
@keithau8159
@keithau8159 3 года назад
Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@
@reechatimilsina5640
@reechatimilsina5640 3 года назад
thank you sir
@dudukusudhakar2903
@dudukusudhakar2903 4 года назад
very useful tricks
@caaman93
@caaman93 3 года назад
Good one
@hazemali382
@hazemali382 3 года назад
great♥
@HusseinKorish
@HusseinKorish 2 года назад
Amazing
@akji2113
@akji2113 3 года назад
I love your english sumit
@mboush123
@mboush123 3 года назад
Great
@maheshpatidar6807
@maheshpatidar6807 3 года назад
Really awesome video, thank you sir, is there any way to copy any sheet to another new workbook kindly help
@planxlsm
@planxlsm 3 года назад
00:00​ Intro 00:15​ Quickly Move Rows and Columns in Excel 02:18​ Quickly Copy Rows and Columns in Excel 03:29​ Copy Worksheets 05:39​ Insert Rows/Columns in Existing Dataset 06:42​ Deselect Cells
@yogeshchandrabhatt227
@yogeshchandrabhatt227 4 года назад
Thanks to trumpexcel for the easy and free access excel content to all ! Would like to know if you starting Dax Course. I have been trying to get % contribution of product YOY with Dax measure ans want to draw chart over that contribution. But stuck !
@caprashantkhandelwal558
@caprashantkhandelwal558 4 года назад
good
@mcbasak
@mcbasak 4 года назад
Thanks Sumit for this useful tips. I have a question. Suppose I have a sheet named 'Jan-2020'. Now I like to create 11 new sheets for all the rest of the months of the year 2020. Is there any shortcut way?
@rabdu2002
@rabdu2002 4 года назад
Dear Sumit, thanks for the information you shared, but could you please tell us what is the benefit of the trick no 5 since i can't copy the selected columns or rows.
@vaishuvenkats9959
@vaishuvenkats9959 3 года назад
Hi can you make ms outlook series same like ms excel series your all excel video awesome... Please kindly making ms outlook series.. Wait for u...
@georgywordrighter5662
@georgywordrighter5662 4 года назад
Excellent as ever - No 1 fan- However - I have to use an online shared excel sheet and these commands don't work: for example I cannot copy only visible cells (for which you provide instruction using alt ;) nor (oddly) can I create a running sequence by dragging down the first few if I have the columns filtered. It simply copies the first one (eg 123,highlighted and dragged gives 1 1 1 in the target cells) It also doesn't allow me to count how many visible rows - is this an issue with the online Excel I am forced to use for collborative reasons or me?
@MS-em4bf
@MS-em4bf 3 года назад
“06:36” shift + ctrl + ‘+’
@gabriellakecskes6305
@gabriellakecskes6305 2 года назад
Where is the spreadsheet that goes with this video please?
@hariomgupta4677
@hariomgupta4677 3 года назад
Sir i make a filter vba but my vba code show some errors. I try to solve error but my vba errors not solve can u please solve my vba error and how can i send my error vba file please help 🙏🙏🙏🙏🙏🙏
@ayubtonshyal
@ayubtonshyal 3 года назад
I'm master in Excel, but I wasn't know the tip 1 & 2...
@fayazmuhammad5983
@fayazmuhammad5983 4 года назад
Sir please upload 2 to 3 videos per week 1 video is not sufficient in a week
@trumpexcel
@trumpexcel 4 года назад
Thanks for the feedback Fayaz.. I am planning to increase the frequency to 2 videos per week. Hopefully soon!
@AmitSharma-zp5cd
@AmitSharma-zp5cd 3 года назад
Hi sumit, I have send u an excel on your mail, need to take some guidence . I dont have your no. And I tried to contact at your postal address but no response recieved
@Its.my.pleasure
@Its.my.pleasure 3 года назад
Bro, u r talking in English, then why r u pushing that dam English subtitles
@trumpexcel
@trumpexcel 3 года назад
Subtitles are meant for people who may have difficulty in hearing as well as for those who are not able to follow English easily. You can turn if off with a click if you want. A little empathy goes a long way
Далее
7 Clever Excel Custom Formatting Tricks (Advanced)
19:14
25 AWESOME Excel Keyboard Shortcuts (You Should Know)!
17:36
Best father #shorts by Secret Vlog
00:18
Просмотров 6 млн
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Просмотров 428 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
10 Excel formatting tricks *ONLY* experts know
16:43
Просмотров 324 тыс.