101 Excel Shortcuts that will help to increase your Excel speed

Поделиться
HTML-код
  • Опубликовано: 22 ноя 2024

Комментарии • 1,7 тыс.

  • @Learn_More_Pro
    @Learn_More_Pro  3 года назад +63

    Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

  • @tanyakundansingh7758
    @tanyakundansingh7758 3 года назад +11

    Mujhe nend aa rahi h fir bhi apki vdo dekh rhi hu bcz ap cmdy krte huye smjhate ho or bahut acche se samjhate ho thnk u so much bro...

  • @AkmalKhan-by7xl
    @AkmalKhan-by7xl 3 года назад

    اسلام و علیکم
    ستیش بھیا
    بہت خوب ، بہت زمانے سے Excel sheet میں کافی مشکلات ھو رھی تھیں.
    آپکی اس وڈیو میں میری بڑی مدد ملی ھے.
    آپکا بہت بہت شکریہ.
    اللہ پاک آپکو جزائے خیر عطا فرمائے
    شکریہ -
    محمد اکمل

  • @dadasotaware662
    @dadasotaware662 4 года назад +37

    OUTLOOK® SHORTCUT KEYS
    Alt + S Send the email
    Ctrl + C Copy selected text
    Ctrl + X Cut selected text
    Ctrl + P Open print dialog box
    Ctrl + K Complete name/email typed in address bar
    Ctrl + B Bold highlighted selection
    Ctrl + I Italicize highlighted selection
    Ctrl + U Underline highlighted selection
    Ctrl + R Reply to an email
    Ctrl + F Forward an email
    Ctrl + N Create a new email
    Ctrl + Shift + A Create a new appointment to your calendar
    Ctrl + Shift + O Open the outbox
    Ctrl + Shift + I Open the inbox
    Ctrl + Shift + K Add a new task
    Ctrl + Shift + C Create a new contact
    Ctrl + Shift+ J Create a new journal entry

  • @MuhammadIsmail-sx8yv
    @MuhammadIsmail-sx8yv 3 года назад +37

    For filter apply and remove also use CTRL+SHIFT+L

  • @heaven9904
    @heaven9904 3 года назад +9

    Sir, this video is very useful for excel learner. i starred to watch your video very recently. it will take time but i promise you to watch all video and become Excel expert. i am really thankful to you for making very essential video .thankyou very much and God bless you..

  • @ganeshbhagat6628
    @ganeshbhagat6628 4 года назад +1

    Sir Aapke Videos Bahot Aache Hai Sir Big Fan

  • @romagupta8166
    @romagupta8166 2 года назад +6

    1:- ctrl+E flash fill
    2:- ctrl+pageup/ pagedown :- to jump on sheet
    Shift+arrow keys :- you can select
    4: - shift+space :- to select entire row

  • @anilkumarlodhi4350
    @anilkumarlodhi4350 2 года назад

    मैंने आप का वीडियो देखा और इसे देखते हुए मेरा एक शानदार अनुभव रहा सर मैंने बहुत कुछ नया सीखे आपका बहुत-बहुत आभार

  • @ashking64
    @ashking64 2 года назад +11

    3.Shift - right / down for selection for cells
    5. Ctrl + space for colum space
    7. Ctrl end last selection

  • @akashsaini9064
    @akashsaini9064 2 года назад

    Sir.....muje apki videos bahut pasand ayi maine in videos se 8din me poora excal with short key ke poora kiya h so bahut bahut danyabad sir apka

  • @playfulimperfection
    @playfulimperfection 5 лет назад +17

    This Video deserves millions of views 🤗🤗

  • @ajaykumar3919
    @ajaykumar3919 3 года назад

    Sir you are the best teacher in the RUclips apke jaisa koi nahi padhata

  • @arsalanmirza5103
    @arsalanmirza5103 4 года назад +38

    I am from Pakistan.
    Great work sir , your students are very lucky if they have passion of learning excel.
    Please also upload uses of macros in different fields.

  • @brijesh8703
    @brijesh8703 4 года назад

    U r doing good job sir.aapke jaisa koi tutor nhi Dekha aajtak Jo itni bariki se padata ho.thnku so much and Aapka Chanel world ke har jagah No1 ho

  • @ahmerkhan2322
    @ahmerkhan2322 3 года назад +8

    Learned many shortcut keys from it, thank you very much for sharing such a knowledgeable video.

  • @niteshtayade2734
    @niteshtayade2734 2 года назад +2

    Thanks you sir main ne aapse bohat kuchh sikha hai our ummid hain ki aage bhi skhta rahunga thank you so much

  • @Marry3D
    @Marry3D Год назад +7

    Ap ka har video achha hai

  • @sagargaikwad7814
    @sagargaikwad7814 4 года назад +1

    Dekha to sab kuch hain sir but bahut confused ho gaya hu .....but vapas ek ek vedio dekhenge to yad ana chalu ho jayega so thanks you sir

  • @dadasotaware662
    @dadasotaware662 4 года назад +5

    BASIC SHORTCUT KEYS
    Alt + F File menu options in current program
    Alt + E Edit options in current program
    F1 Universal help (for all programs)
    Ctrl + A Select all text
    Ctrl + X Cut selected item
    Shift + Del Cut selected item
    Ctrl + C Copy selected item
    Ctrl + Ins Copy selected item
    Ctrl + V Paste
    Shift + Ins Paste
    Home Go to beginning of current line
    Ctrl + Home Go to beginning of document
    End Go to end of current line
    Ctrl + End Go to end of document
    Shift + Home Highlight from current position to beginning of line
    Shift + End Highlight from current position to end of line
    Ctrl + f Move one word to the left at a time
    Ctrl + g Move one word to the right at a time

  • @himanshujonwal6580
    @himanshujonwal6580 Год назад

    शानदार जानदार जबरदस्त 👍👍 thank u so much sir for all excel tricks

  • @saurabhsethi1942
    @saurabhsethi1942 4 года назад +8

    its really useful video. I learnt lots of new formulas. I would like to tell you one more formula about "Filter". We can use formula Ctrl+Shift+L with this formula we can add or remove Filter from excel sheet.

  • @rajverma9b412
    @rajverma9b412 4 года назад +1

    Thankyou sir your explanation is very good i watch all your video and now am felling good that i know to use computer all thing thank you sir may your channel be one of the biggest channel on youtube one day💯💯

  • @jitendrakewat5771
    @jitendrakewat5771 3 года назад +5

    I must appreciate your efforts to make ourself updated with technology.

  • @researchbaba6921
    @researchbaba6921 2 года назад

    कम समय में काम की चीज अच्छी तरह से समझा रहे हैं गुरुदेव आपका धन्यवाद में आपका सब्सक्राइबर हूं

  • @jitendersingh9793
    @jitendersingh9793 5 лет назад +4

    Dear Sir,
    Complete shortcut keys in 1 video, very nice Sir 👍
    All in one Excel shortcut video.
    Colum unhide krne ka shortcut hai, Select two cell only for unhide colum- Alt+H+O+U+L very easy.
    Please add this shortcut key in next shortcut video.
    Kindly revert.

    • @Learn_More_Pro
      @Learn_More_Pro  5 лет назад +1

      yes yes jitender ji you are right thanks for sharing will definitely add it.

    • @jitendersingh9793
      @jitendersingh9793 5 лет назад +1

      @@Learn_More_Pro
      I'm your lover,
      Aapki video se mujhe bahut help hui hai.
      Apne office me Excel me faster ki trah kaam krta hun, Ye sab Aap se hi sikha hai.
      🙏🙏 Thank you Guru ji.

  • @VijayKumar-yd7ck
    @VijayKumar-yd7ck Год назад +1

    I AM LEARNIG VERIOUS SHORTCUT KEYS ,YOU ARE A GOOD TEACHER

  • @ajimali5259
    @ajimali5259 5 лет назад +6

    Nice video sir

  • @nihalkhan8782
    @nihalkhan8782 2 года назад

    Sir amazing 👍 aapki teaching best he mere brain me kaafi sara utar gaya and itne sare shortcut first time dekh ra hu sir

  • @aadeshkumar2889
    @aadeshkumar2889 3 года назад +8

    To Apply filter we can also use
    Carl+Shift +L

  • @nishavaitha7321
    @nishavaitha7321 2 года назад

    F4 ki nahi Pata thi pr ab chal gaya pata😊most use ful all shortcut keys amazing video🥰

  • @rahulshinde1591
    @rahulshinde1591 5 лет назад +18

    In excel older version, If we use Alt+Space Bar & C to close file then all open excel files get close so instead of that we should use ctl + W will close one by one. Sorry for bad english...🙏🙂

    • @talatmt187
      @talatmt187 2 года назад

      Your English is not bad.it is alright

  • @meditations6679
    @meditations6679 3 года назад +2

    There are lots of shortcut keys which were unknown for me. Thank you so much for giving most informatic knowledge. Hatsoff

  • @dipakdas2314
    @dipakdas2314 4 года назад +7

    GREAT SIR FOR TEACHING PROCESS VERY INTERESTING

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

    Yr muje is sir se pyar hogaya he 😅I love u ap itna acha samjhaty he ❤

  • @satyadevpandey5458
    @satyadevpandey5458 5 лет назад +4

    1 No. Sir...

  • @aaftabsheikh7701
    @aaftabsheikh7701 2 года назад

    I watched full video without any skip and i got too much knowledge from this video
    Thank you so much sir and make more videos for the same.

  • @Azhar_Khan383
    @Azhar_Khan383 4 года назад +9

    excellent work & highly appreciated , Thanks Sir
    u can also use control+shift+L to apply & remove filter

  • @saradaswain3136
    @saradaswain3136 3 года назад

    Lajawaab hai aap ki collections. I amazed. Thank u so much. Aur. Bhi bahut kuch sikhna hai aapse.

  • @sauravvlog2123
    @sauravvlog2123 6 месяцев назад +22

    kon kon 2024 m dekh rha h

    • @nirajsk8226
      @nirajsk8226 Месяц назад +2

      Tujhe kya karna hai bhai koi bhi dekhe 🤦🏻‍♂️🤦🏻‍♂️🤦🏻‍♂️

  • @ManojVerma-rg4ky
    @ManojVerma-rg4ky 2 года назад

    i am from india
    sir, your excel work is a great ......
    sir your student is very lucky .....
    Thank you sir

  • @krishnakantmundra5388
    @krishnakantmundra5388 3 года назад +5

    Appreciate your hard work and dedication. Superb content. 1 million sub soon😀

  • @shashikantanavkar3228
    @shashikantanavkar3228 2 года назад

    एकदम मस्त आणि माहितीपूर्ण चित्रफीत धन्यवाद भाऊ

  • @ashwingowdillu2624
    @ashwingowdillu2624 4 года назад +13

    Hi sir,
    Thanks & appreciate that u have provided all the shortcuts in single video. unfortunately I know every single shortcut u mentioned in this video...I'm looking short cut for
    1.working inside pivot table like selection of fileds
    2. Selection of objects (for example we have 30 object in a sheet. I need to select 15 or or 20 objects not necessarily in order)

  • @nitishsingh1998
    @nitishsingh1998 2 года назад

    I am a beginer in excel try to learn from your videos now thanks sir

  • @rajeshsharma12925
    @rajeshsharma12925 2 года назад +3

    In shortcut no 14(repeat last action), when I press F4, a pop up menu appears with the following options-PC screen only, duplicate, extend, second screen only etc.

  • @pankajkumartanwar1157
    @pankajkumartanwar1157 3 года назад

    Bhout badiya description sir

  • @ADITYASINGH-vd9xh
    @ADITYASINGH-vd9xh 5 лет назад +11

    For filter
    Ctrl+shift+L

  • @naseemahmed6759
    @naseemahmed6759 3 года назад

    Shandaar Jandaar
    Jabardast
    jindabad
    Wah Satish Sir
    Kamal Kar Diye
    It's Very Useful For All Of Us

  • @amruts6464
    @amruts6464 4 года назад +16

    For Filter addition and deletion you can use. Cyrl+shift+L

  • @singh6737
    @singh6737 3 года назад

    I didn't know how to find in complete workbook. Your method to explain the things is so good.

  • @SarangManzoor
    @SarangManzoor 2 года назад +5

    Ctrl + Shift + L for using filter key but make sure they are no merge columns/rows.

  • @vanijha4117
    @vanijha4117 3 года назад +1

    I had also learnt more about computer only by the help of you, because of ur explanation very nicely. Thank you.

  • @karanbasnal9433
    @karanbasnal9433 4 года назад +14

    Thank you so much to give me a wonderful short cut in excel
    I see your full video
    Best of luck for your channel

  • @rupeshgaikwad2472
    @rupeshgaikwad2472 4 года назад +3

    to apply filter we can also use alt+ctrl+L

  • @makeshn9813
    @makeshn9813 2 года назад

    Wowwww Master ji. Very interesting. Especially your way of expression in the smiling method, no one would forget the shortcut keys.

  • @SherSingh-vp7xl
    @SherSingh-vp7xl 4 года назад +4

    Dear Sir, Row or column ko automatic adjust karna ka shortcut key bataye. Ya fir bina mouse ka row or column ka size kaisa adjust kare.
    Plz comment

    • @theviralindians3754
      @theviralindians3754 3 года назад +1

      First select the data
      alt+o+c+a
      This will adjust automatically..

  • @zahirkhansafy5210
    @zahirkhansafy5210 4 года назад

    zenda baad Satish sir,
    aap hamare leye rahmat ka fareshta ho......
    M. Zahir Khan Safy , Kabul Afghanistan

  • @dineshmathsclasses2514
    @dineshmathsclasses2514 3 года назад +3

    Excellent explanation ,I can learn a lot from your channel, thank you so much for your time and effort.

  • @sweetpuzzle2652
    @sweetpuzzle2652 2 года назад +1

    Sir for me all shortcurt keys are new but i am hare for your shortcurt no.49&50 its really very help full for me thank you so much for your hard work and most important time as well as thank you 😊

  • @priyankajaiswal9827
    @priyankajaiswal9827 3 года назад +12

    FOR APPLY FILTER WE CAN USE CTRL+SHIFT+L

  • @kartikmishra5560
    @kartikmishra5560 2 года назад

    Thankyou so much. Some of the features i didn't know even after working in excel for a long time.

  • @mohammadahmad8097
    @mohammadahmad8097 3 года назад +5

    Please sometime teach how to do vertical selection in a split Excel column.

  • @Vikash_Devrath
    @Vikash_Devrath 3 года назад +1

    All is best video 👍❤️😎
    Thank you for excel shortcut key 🙏

  • @shridhart5340
    @shridhart5340 4 года назад +3

    For Filter we can use Ctrl+Shift+L

  • @guttesambhajivishnu4900
    @guttesambhajivishnu4900 3 года назад

    Wonderful sir initially i was complete blank of computet knowledge but on seeing your lecture through youtube i became smart in office computer work
    I am realy very greatful to you

  • @Rahulsingh-li3vx
    @Rahulsingh-li3vx 5 лет назад +15

    Alt+O+C+A also adjust column size

    • @anilyadav5279
      @anilyadav5279 4 года назад

      Dobara same format me lane ke liye pls bataye

    • @saquibkhan2154
      @saquibkhan2154 2 года назад

      Its all the game of Alt

  • @HabibKhan-ob2yi
    @HabibKhan-ob2yi 2 года назад +1

    i m form Pakistan....You are so brilliant sir, may you succeed..

  • @cma.chander3719
    @cma.chander3719 5 лет назад +4

    Good job done 👍 GJD.

  • @subashchander9137
    @subashchander9137 4 года назад

    Thanks for 101 shortcuts dear brother

  • @chhotudesigners3889
    @chhotudesigners3889 4 года назад +4

    Starting Sir learning Excel 🙏🙏🙏

  • @aanandsingh6701
    @aanandsingh6701 4 года назад

    Thanks sir itna achcha video banane ke leye

  • @Rahulsingh-li3vx
    @Rahulsingh-li3vx 5 лет назад +6

    Short cut key for protect sheet
    1st Alt+R+P+S
    2ND ALT+H+O+P

  • @rialikhan
    @rialikhan Год назад

    Thank you aapke video se mein company mein job kar rahi hoon Mujhe Kafi Kuchh madad mil rahi hai thanks sir

  • @Rahulsingh-li3vx
    @Rahulsingh-li3vx 5 лет назад +6

    Short cut key for filter apply
    Ctrl + shift +L

  • @aninditamishra8117
    @aninditamishra8117 2 года назад

    Aap k teaching ka tarika bahut hi lazawab hai sir

  • @rs.6763
    @rs.6763 3 года назад +1

    CTRL+ SHIFT+ L for filter
    Thank you sir for this amazing video. 🙏❤❤

  • @durgeshdohare7083
    @durgeshdohare7083 5 лет назад +9

    shandar sir.....😊

  • @AkshayKumar-mt6lh
    @AkshayKumar-mt6lh Год назад

    Thank you sir😄 shortcut key aapne bahat achchha se samjha rahe hai koi koi shortcut pata tha aur aapne bata diya thank you so mach sir

  • @bijenderkumar7446
    @bijenderkumar7446 4 года назад +5

    Hiii sir, I have to make a VBA for in/out stock inventory
    In which (in stock) date item qty Mfd Exp. Out stock date item qty given to and remains qty
    Plzz help me

  • @santoshKumar-bp2cd
    @santoshKumar-bp2cd 3 года назад

    Good morning sir achcha shortcut hay

  • @vipulvirle2577
    @vipulvirle2577 4 года назад +28

    Alt+D+F+F simple filter shortcut key

  • @MuhammadKamran-cq4ro
    @MuhammadKamran-cq4ro 3 года назад

    I am beginner, learning from your videos well

  • @rishabhsinghrajput1706
    @rishabhsinghrajput1706 3 года назад +5

    Work book doesn't gets closed by CTRL +F4. IT GETS BY PRESSING Alt +f4

  • @bharatchz5112
    @bharatchz5112 2 года назад +2

    Thanks you sir I has learnt many tricks from these video

  • @A1badalvlog
    @A1badalvlog 5 лет назад +5

    Jisko bhi video achha laga like karo

  • @chetansatyawali9726
    @chetansatyawali9726 Год назад

    Sir आप की जानकारी बहुत सुंदर है 🙏👍
    एक एमआईएस रिपोर्ट कैसे बनाते हैं क्या क्या होता है please sir bata दीजिए 🙏🙏

  • @sureshsah9680
    @sureshsah9680 5 лет назад +6

    Press "Alt+=" to auto sum..

  • @usmanraja126
    @usmanraja126 3 года назад

    I lost my Heart to subscribe to your channel after watching this video, SIR. #respect from my HEART. what a great learning point #learnmore

  • @mr.arabindakumar7162
    @mr.arabindakumar7162 4 года назад +7

    Nice jokes

  • @preetisaxena6993
    @preetisaxena6993 2 года назад

    Sir bolte bahut accha ho aur samjhte bhi bahut accha ho 🙏🙏❤️❤️

  • @indigo_rash1122
    @indigo_rash1122 4 года назад +9

    I have noticed no matter how much I learn, I am extremely slow at analysing data of any kind :(

  • @ababilpeekflying
    @ababilpeekflying 3 месяца назад

    Hello sir you are a great person & teacher ❤. Thank you so much sir.
    God bless you 🤲❤

  • @dharmpalsingh5267
    @dharmpalsingh5267 4 года назад +30

    Where are u coching/ institute. I Learn advance excel for you.

  • @rajindersinghtaneja5731
    @rajindersinghtaneja5731 3 года назад

    3-4 shortcut keys are known to me. Rest are new. Thanks for making this Video

  • @vipulvirle2577
    @vipulvirle2577 4 года назад +4

    Alt+O+C+A Column auto fit

  • @p4pappurajchaure976
    @p4pappurajchaure976 3 года назад

    Aap teaching mai jo jock krte hai vo bahut badia i like it

  • @nasiraziz9195
    @nasiraziz9195 Год назад +3

    karachi pakistan

  • @rajkumarrathod5044
    @rajkumarrathod5044 4 года назад

    Nice sir continue to your video I seen so many times to learn more about excel.

  • @KiranmoySarkar-l4c
    @KiranmoySarkar-l4c 2 года назад

    Sir mujhe apki intin gyan se bohot help ho raha hay