Excel Goto Special | Selection tips to use Goto Special options in Hindi | Fill Blank Tricks

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 140

  • @MrSanjogbaral
    @MrSanjogbaral 3 роки тому +5

    Your teaching has taken my Excel skills to next level. Thanks a lot.

    • @Innozant
      @Innozant  3 роки тому +3

      Thanks Dear🙏❤️Happy Learning and thanks for supporting.👍🙏

  • @The-Fronted
    @The-Fronted 3 роки тому +1

    Ache teacher ki student kadr nahi krte. Itna kam Subscribe
    You are the best sir

    • @Innozant
      @Innozant  3 роки тому

      Khan Sahab ..Logon ko entertainment chaiye hota hai kahan logic le apna dimag kharab karna..😄❤🙏Thanks fpr your love and kind support dear

  • @chanchalsharma2456
    @chanchalsharma2456 3 роки тому +2

    One thing I noticed
    Aap jo b topic lete ho usko briefly pdate ho
    👌👌awesome videos
    U tube pr kisi b topic ko briefly n pdate sabhi teachers👍
    Keep it up sir, Thanks sir, good way of teaching 🙏😊😊

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks Chanchal ❤️ Aapke valuable feedback ke liye..Meri humesha koshish rehti hai ki complete content deliver Kru na ki youtube par views paane ke liye Kuch bhi Bana Doon.Thanks Aapke appreciation ke liye .humesha mein best content deliver krne ki koshish krunga.👍🙏❤️

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks Chanchal ❤️ Aapke valuable feedback ke liye..Meri humesha koshish rehti hai ki complete content deliver Kru na ki youtube par views paane ke liye Kuch bhi Bana Doon.Thanks Aapke appreciation ke liye .humesha mein best content deliver krne ki koshish krunga.👍🙏❤️

  • @user-xi1iw5qz5r
    @user-xi1iw5qz5r 8 місяців тому +1

    the way you are adopted for teaching is so amazing. i salute you

  • @Anony15100fd
    @Anony15100fd Рік тому

    Sir your explanation is very nice and smooth and easy to understand subscribed

  • @sandipsingh8377
    @sandipsingh8377 3 роки тому

    I plan to watch all your videos

    • @Innozant
      @Innozant  3 роки тому

      Thanks .. Start your Learning journey from playlist Basic excel onwards step by step

  • @RA-rh5lb
    @RA-rh5lb Рік тому

    Good Morning Sirji, Ek saath go to special maine pahele baar sikhi.. thanks

  • @goodness377
    @goodness377 3 роки тому

    Excel guruji thank you very much, apke video se mera Ek bht bara problem solve ho gaya, jese india to Canada wala

    • @Innozant
      @Innozant  3 роки тому

      Thanks Sinha sahab..happy learning dear

  • @contracts6521
    @contracts6521 Рік тому +1

    Good Show

  • @shrikantbadge3978
    @shrikantbadge3978 Рік тому

    INNOZANT तो ग्रेट हैं जी
    Deepak Sir की भेंट हैं जी
    Excel भरोसे मेरा पेट हैं जी
    Deepak Sir तो ग्रेट हैं जी

  • @sandeepaswal8944
    @sandeepaswal8944 3 роки тому +1

    Sir That's a super trick!.. I learnt something new today. You are a very good instructor; very passionate. Made my life easier.

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks Sandeep for this wonderful feedback..M happy for you.Dedicated learner you are.👍🙏❤️

  • @vikasgawaria5330
    @vikasgawaria5330 Рік тому

    Sir namaste nice video thankyou so much,sir Excel ke baad data science ka complete package upload kar dijiye please

  • @Karma4Good
    @Karma4Good 2 роки тому

    Your teaching technic very easy to understand thank u.

    • @Innozant
      @Innozant  2 роки тому

      Thanks dear ..God bless you

  • @siddhudhanshetti7530
    @siddhudhanshetti7530 2 роки тому

    Thank you so much sir

  • @PankajSharma-em2vn
    @PankajSharma-em2vn Рік тому

    Sir u have Great knowledge of excel

  • @AnitaSingh-mk3gi
    @AnitaSingh-mk3gi 2 роки тому

    Video is very useful

    • @Innozant
      @Innozant  2 роки тому

      Thanks Anita ji❤️

  • @rajeevpathak6172
    @rajeevpathak6172 2 роки тому +1

    Very interesting and useful Sir

  • @user-bu1fc8pq7p
    @user-bu1fc8pq7p 10 місяців тому

    Thank you sir ❤

  • @atulshukal4072
    @atulshukal4072 3 роки тому

    बढ़िया वर्क साहेब आभार

    • @Innozant
      @Innozant  3 роки тому

      Thanks Atul Ji❤️🙏

  • @dhakafady774
    @dhakafady774 Місяць тому

    thanks a lot sir

  • @SanjayKumar-uw9kn
    @SanjayKumar-uw9kn 3 роки тому

    When I asked it in coaching they said that forget it, nothing special.
    😂😂😂
    Kash ap mujhe pehle mil Jate
    Ab lag raha hai me bhi MIS Interview crack kar paunga just because of you sir
    Thanks a lot.

    • @Innozant
      @Innozant  3 роки тому

      Don't worry Sanjay..Jo beet gyi so baat gayi..abhi Jo apke paas hai wo hai Aapka mehnat..krenge to jaroor succeed.Beat of luck.

  • @jattsahab2102
    @jattsahab2102 11 місяців тому +1

    Very useful video

  • @shahzadsiddiqui5117
    @shahzadsiddiqui5117 Рік тому

    this one i needed the most, thanks as always...!Respect

  • @subhashchandrabaghel8158
    @subhashchandrabaghel8158 3 роки тому

    Sir, knew how use of GOTO option but really add skill in this pop up
    Thanks sir ji
    Wish you all best

    • @Innozant
      @Innozant  3 роки тому

      Thanks Subhash.. Recommend you to watch Videos step by step from playlist -Basic Excel to adv.🙏♥️

  • @hemantgusain1260
    @hemantgusain1260 3 роки тому

    Thanks you sir for explain go to special so deeply.

    • @Innozant
      @Innozant  3 роки тому

      Thanks Hemant 🙏❤️👍Happy Learning

  • @satishojha6240
    @satishojha6240 3 роки тому

    Awesome explanation I realised improvement day by day in excel thanku very much sir good night 🙏🙏🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Satish Ji,Hope you like the Goto Special concept.GN🙏❤️👍

    • @shashijha682
      @shashijha682 2 роки тому

      Hi Satish ji

  • @imvny
    @imvny 3 роки тому

    Your teaching style is very good. 💞💞

  • @anjlim8930
    @anjlim8930 2 роки тому

    Thank you Sir

    • @Innozant
      @Innozant  2 роки тому

      Thanks Anjali❤️

  • @ghanshyamayodhyaprasadgupt727
    @ghanshyamayodhyaprasadgupt727 3 роки тому

    Super sir ji

  • @vijaysahal4556
    @vijaysahal4556 3 роки тому

    nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

  • @ramseshu110
    @ramseshu110 3 роки тому

    Excellent teaching sir

    • @Innozant
      @Innozant  3 роки тому

      Thanks Ram🙏❤️

  • @bhoopendraraghav9781
    @bhoopendraraghav9781 3 роки тому

    Really hat's of u sir...

  • @moveon001
    @moveon001 2 роки тому

    teaching skills wow

  • @pareshparikh7944
    @pareshparikh7944 3 роки тому

    Salute sir

    • @Innozant
      @Innozant  3 роки тому

      Thanks Paresh 😀🙏❤️

  • @sonuyadav7518
    @sonuyadav7518 3 роки тому

    Thanks sir

  • @samatsekh6063
    @samatsekh6063 3 роки тому

    Every time getting to learn new things.

    • @Innozant
      @Innozant  3 роки тому

      Thanks Samat🙏❤️

  • @arslantahir1708
    @arslantahir1708 8 місяців тому

    thanks dear :-)

  • @manjharvalley8047
    @manjharvalley8047 3 роки тому

    super video sir jee..your voice is too sweet

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks Manjhar ..Happy learning

  • @user-lt3ct6zq1k
    @user-lt3ct6zq1k Рік тому

    it helps but why you left constant option and directly go to formula options in go to specials. i have confusion with logical and error in constant.

  • @pa2happiness13
    @pa2happiness13 3 роки тому +1

    👌🏼

  • @rahulrakshe1988
    @rahulrakshe1988 Рік тому

    video is nice but pl update separate practice file link in description bcoz not able to find file in all folder drive

    • @Innozant
      @Innozant  Рік тому

      Link broken ho gya hai...We need to fix all video link..will update it soon

  • @atulpathak1045
    @atulpathak1045 Рік тому

    Divide multiply options please cover

  • @muhammadhuzaifa4521
    @muhammadhuzaifa4521 Рік тому

    Hi Sir Goto special me reference kis trhn pass karty hn?
    Sheet pr move hony ky liye

  • @myclass4006
    @myclass4006 3 роки тому

    Nice

  • @muhammadaamir4416
    @muhammadaamir4416 3 роки тому

    Indirect function par video banayay

    • @Innozant
      @Innozant  3 роки тому

      Aamir Sahab ye kehne ki jrurat hi nhi h apko🙂Choose finished ab indirect phir offset.Have patience 🙏❤️

  • @shivamonestop380
    @shivamonestop380 3 роки тому

    Wow

  • @raufwaheed2955
    @raufwaheed2955 2 роки тому +1

    Go to special did not select blanks after last text either we have to type a additional character at last

  • @yourchannel6024
    @yourchannel6024 5 місяців тому

    Dear is there any formula that gives me laptop or cell registration number. By this formula any other device not use my excel file.

  • @satscoolstyle4210
    @satscoolstyle4210 2 роки тому

    We can also go with f5

  • @meriawaazhindi5217
    @meriawaazhindi5217 Рік тому

    ❤️❤️❤️❤️❤️

  • @kkrcreationstatus6583
    @kkrcreationstatus6583 2 роки тому

    👍👍👍👍👍

  • @Unfiltered_ind
    @Unfiltered_ind 2 роки тому

    Sir date , week, month,year se related question nhi aate i mean use krna nhi ki kaha pr kasse use kre....

  • @choudhary2033
    @choudhary2033 3 роки тому

    Visible cell ka bhi bahut use hota hai Filter karne pe.

    • @Innozant
      @Innozant  3 роки тому

      Yes Kundan ji..❤❤

  • @aadesh6122
    @aadesh6122 Рік тому

    🙏🏻🙏🏻🙏🏻👌🏻👌🏻

  • @Technicalfact9169
    @Technicalfact9169 2 роки тому

    Sir tally erp 9 par videos banay❤️

    • @Innozant
      @Innozant  2 роки тому

      Tally main nhi padhata hu dear..
      Data Analytics & Data Science mera field hai..
      Haan kisi dusre trainer ke videos aayenge channel par

  • @virendersroha1754
    @virendersroha1754 3 роки тому

    Koi special word ko serch kr skte h kya kse #N/A

  • @naeemulhassan1426
    @naeemulhassan1426 3 роки тому

    Sir. Please launch a tutoriel on short keys of ms excel and also tell the when should be used the ctl and enter key and when use contl shift enter and when should b use only enter key also tell on which type of windows ur tutoriel of sum maharaj is work. I use window 8 it does not work for sum maharaj tutoriel tips. Regards.

    • @Innozant
      @Innozant  3 роки тому

      Thanks Naeemul for your valuable opinion,
      in case of standard function use Enter,When there is bulk array use ctrl+enter and if you want to execute single array function then ctrl+shift +enter..
      no issue will make more videos of shortcut dear

  • @laisonkc
    @laisonkc 2 роки тому

    Sir,
    How we can do mail merge with personalised attachment. Pls help.

  • @gagansingh3481
    @gagansingh3481 2 роки тому

    Hi sir facing issue on one excel problem could you please share of ID I will share the problem with you ....please provide the solution on it ....

  • @dharminderkumar9370
    @dharminderkumar9370 Рік тому

    Sir mai ek excel se copy kar ke dusre excel ke paste karta hu to blank past Hota hai please solve

  • @bishtlokesh1297
    @bishtlokesh1297 3 роки тому

    Operation of go to

    • @Innozant
      @Innozant  3 роки тому

      Thanks Lokesh.Hope you like it🙏❤️

  • @gantisn1701
    @gantisn1701 Рік тому

    good after noon i tried to use go to but the special command is not visible how to show please help thanks in advance

    • @Innozant
      @Innozant  Рік тому

      Which version of excel you are using now

  • @vaijeenathsable6572
    @vaijeenathsable6572 3 роки тому

    Plz sir jaldi batayega,,,,,,

    • @Innozant
      @Innozant  3 роки тому

      Aap kya chahte hain krna ye btaiye.as answr to apne khud hi bta diya h dear

  • @pawanmehta7651
    @pawanmehta7651 2 роки тому

    My question is that we made a file.in this files we created some name and their value.now I want to insert blank line in the end of every line.how we can it?

  • @ghanshyampatidar6016
    @ghanshyampatidar6016 2 роки тому

    Sir एक सेल को छोड़ कर एक सेल में कॉपी कैसे करते है फिर खाली सेल में दूसरा डेटा की कॉपी कैसे करते हैं

  • @mayankbhatt1790
    @mayankbhatt1790 3 роки тому

    Your teaching is another level but I have a doubt that u r using if formula in this that is also a logical function but why don't show in logical ??? 🤔🤔🤔🙏🙏👌👌💯

    • @Innozant
      @Innozant  3 роки тому +1

      Didnt get you mayanak..Offcourse uf function is under logical function category

    • @mayankbhatt1790
      @mayankbhatt1790 3 роки тому

      @@Innozantthank you for your precious time ♥️💕💗
      jb ham if use kr rahe the formula pe toh go to special usko logical Kyu nii Bata Raha hai vo if function formula ke andar usko text Bata Raha hai jbki usko logical batana chahiye

    • @Innozant
      @Innozant  3 роки тому

      kyu batyega text if formula is logical..?

  • @manojvaghela5727
    @manojvaghela5727 Рік тому

    Tz

  • @ALOKSingh-ee2zd
    @ALOKSingh-ee2zd 8 місяців тому

    Kya aap online class karwate h

    • @Innozant
      @Innozant  8 місяців тому

      Yes..innozant websitw visit kriye

  • @karankapoor200
    @karankapoor200 3 роки тому

    sir Excel ma all function KO Explain home intert all function🙏🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Karan 🙏❤️

  • @vaijeenathsable6572
    @vaijeenathsable6572 3 роки тому

    Go to Option me jake, agar muze filter lagake only visible data ko paseSpecial karna h to kaise kare

    • @Innozant
      @Innozant  3 роки тому

      Answer to apne khud hi bTa diya hai dear..visible cells only bus check kr lekn uske baad copy and paste

    • @vaijeenathsable6572
      @vaijeenathsable6572 3 роки тому

      Nahi ho raha h

    • @vaijeenathsable6572
      @vaijeenathsable6572 3 роки тому

      Please jaldi

    • @vaijeenathsable6572
      @vaijeenathsable6572 3 роки тому

      Maine Vlookup mara h, jo values male h usko filter me jake check laga ke filter kiya aur usko find values ko paste special karna h, lekin nahi ho raha h

  • @bhavyadudeja5969
    @bhavyadudeja5969 2 роки тому

    I am unable to find and download this file please share the path thanks

    • @Innozant
      @Innozant  2 роки тому

      It is available under master assignment main link folder

    • @bhavyadudeja5969
      @bhavyadudeja5969 2 роки тому

      @innozant sir please share the path so that I can download this file

    • @Innozant
      @Innozant  2 роки тому

      @@bhavyadudeja5969 you may find it in basic excel folder -other option

    • @bhavyadudeja5969
      @bhavyadudeja5969 2 роки тому

      @@Innozant Sir can you please name the folder name, this will help me in locating this fast

    • @bhavyadudeja5969
      @bhavyadudeja5969 2 роки тому

      Thanks you so much I am able to locate the file thanks for your prompt response and support

  • @Yuvasena
    @Yuvasena Рік тому

    F5 dabANE SE BHI JAYENGE

  • @bilalahmadzai7844
    @bilalahmadzai7844 Рік тому

    YOU DID NOT TELL ABOUT THE SAME OF DATA VALIDATION

    • @Innozant
      @Innozant  Рік тому

      Didn't get your query Bilal

  • @nishachauhan9103
    @nishachauhan9103 3 роки тому

    Poori vedio धुंधली रही है शुरू से अंत तक

    • @Innozant
      @Innozant  3 роки тому

      Vido dhundhli nhai hai Nisha..Aaj aapka internet bht slow chal ra hai
      isliye dhundhli dikh rahi hai😀

  • @manjharvalley8047
    @manjharvalley8047 2 роки тому

    Thank you so much sir

  • @mohitchauhan7808
    @mohitchauhan7808 3 роки тому

    👍👍👍👍

  • @MohitNCR
    @MohitNCR 3 роки тому

    THANK YOU SO MUCH SIR

    • @Innozant
      @Innozant  3 роки тому

      Thanks Mohit Ji,Hope you like the Goto special selection option.🙏❤️