Excel CHOOSE Function Explained | How to use the Powerful Choose Formula in Excel in Hindi

Поделиться
HTML-код
  • Опубликовано: 19 авг 2024
  • Excel CHOOSE Function Explained | How to use the Powerful Choose Formula in Excel in Hindi
    1. Excel choose formula explained step by step
    2. Excel choose formula example
    3.use of Randbetween function with excel choose function
    4. Vlookup Formula with Array and randbetween example
    Download the Practice Workbook Direct Link
    drive.google.c...
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    (Excel Lookup Function-Choose-Choose.xlsx)
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantoffi. .
    Facebook ► / innozant
    Twitter ► / innozant
    Linkedin ► / inno. .
    Telegram►@Innozantofficial
    #chooseformula #chooseexplained#Innozant #excelchooseformula

Комментарии • 122

  • @impawansaini08
    @impawansaini08 2 года назад +4

    Sir aap sach mein iss field ke pakke khiladi ho maja aayega aapke saath khelne mein aur sikhne mein sir ekk din aapko gurudakshina jaroor milengi aur wo din jaldi aayega kyunki teacher aap jaisa ho toh koi bhi students top kar lenga ❤️🙏sir

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

      Thanks Saini sahab..God bless You.. Thanks for being part of Innozant

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

    Sir ji one thing best in you is,
    You are uploading daily video jaise lagta hai ki meri daily koi class chal rhi hai, wo bhi free of cost
    Thanks you sir ji and may god bless you a lot....🙏🙏❤️

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

      Ye daily video aapko humesha ke liye dekhne ko milega..bus aap seekhte rahiye step by step abhi bht kuch seekhna hai.🙏🙂♥️👍

  • @DEviL-sp4uy
    @DEviL-sp4uy 3 года назад

    Isi video Ka intezar tha bilkul Sahi time par Sahi cheez ...

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

      Watch complete video and start learning step by step

  • @AnupKumar-oe2jb
    @AnupKumar-oe2jb 3 года назад

    Apka tarika sikhane ka bahut achha h. Maza aa jata h

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

      Thanks Anup ji..happy learning..🙏♥️

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

    Sirji, aap best sikhate hoo.

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

    Sir you are great teacher I learn a lot I pray for you May God bless you and give u lots of success

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

      Thanks Hira.God bless You dear

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

    Sir You Are awesome..! Great content. Really hats off sir . Thank you so much sir

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

      Thanks Sandeep Ji♥️🙏

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

    Sir App Bahat achcha Teaching Karte hon thanks

  • @AshishKUMAR-yd2vs
    @AshishKUMAR-yd2vs 2 года назад

    Sir, you are my hero.
    You have made my professional life very easy.
    I am grateful to you for this.

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

      Thanks Ashish ji for your love and support ❤️

    • @AshishKUMAR-yd2vs
      @AshishKUMAR-yd2vs 2 года назад

      Sir,can you give me your mobile number.

  • @KKG.007
    @KKG.007 2 года назад

    Dear sir,
    Your RUclips tutorials are very helpful.
    Kindly share the all videos related to choose function.

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

      Kindly watch lookup playlist

  • @Tarunkumar-yt7lc
    @Tarunkumar-yt7lc 3 года назад

    way of teaching one of my favorite

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

      Thanks Tarun🙏❤️

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

    I liked so much. Thanks for every thing.

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

    Clear consept of choose function thank you sir

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

      Thanks Pramod Ji.🙏♥️hv a nice day

  • @nigilv.d4237
    @nigilv.d4237 Год назад

    Nicely explained thsnks a lot sir

  • @1gopalakrishnarao
    @1gopalakrishnarao 3 года назад

    Interesting, Illuminating, Igniting, Impressive, Excellent teaching /explanation techniques- All the very best in your great job indeed

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

      Thanks Gopal Sir for such a wonderful comment,M speechless♥️🙏Happy Learning.

    • @1gopalakrishnarao
      @1gopalakrishnarao 3 года назад

      @@Innozant Your technique is unique, smiling face that attracts an interest by the viewers. Please keep it up

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

      @@1gopalakrishnarao Thanks Sir for such a lovely appreciation

  • @ShubhamYadav-uc2mp
    @ShubhamYadav-uc2mp Год назад

    Thank you sir for the wonderful Video !

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

      Thanks dear Shubham
      .Keep learning

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

    interesting video carry on sir

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

    Simple explanation, great content

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

      Thanks ❤️🙏

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

    Thank You!! Bro

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

    Very useful sirji

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

      Thanks Sarthak Ji.Have a nice day.🙏♥️

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

    Sir please mathematical function explain kijiye app bhauth ache see explain karthe hai sir

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

      Math functions..basic excel Playlist me hoga

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

    Nice explanation ❤️

  • @PawanKumar-nv8tb
    @PawanKumar-nv8tb Год назад

    Sir grow hone lg gye sir👍

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

      Thanks Pawan Ji..Keep Learning ❤️

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

    Awesome video!

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

    Choose 👍👍👍

  • @kavitakanwar2161
    @kavitakanwar2161 Год назад +1

    Nice vdo Sir wo quarter wale apne quarter 1 quarter 1 quarter1 quarter 1 phir quarter 3 and quarter 4 lika wo Samaj me nhi aae baki to smaj a gae

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

    great sir 👍🏻👌🏻

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

    Thanks you sir, this formula is quite interesting.

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

      Abhi aane wale videos me iske power dekhen.🙏♥️😀

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

      @@Innozant yes sir

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

    Super conceptual logocal🌹🌺❤️♥️

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

      Thanks dear..have a great day ahead

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

    Good

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

    Dear sir,
    You are genius in excel
    How did you learn these all🙏🙏🙏🙏🙏❤️❤️❤️

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

      Thanks dear❤️❤️

  • @RamSingh-ol5xz
    @RamSingh-ol5xz 3 года назад

    Nice

  • @Harish.Prasad.Semwal
    @Harish.Prasad.Semwal 6 месяцев назад

    1:00 1:55 6:16 6:49 7:26 8:15

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

    Nice video sirG

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

    Very interesting sir g

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

      Thanks Bhoopendra.Keep supporting🙏♥️

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

    Really interesting

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

      Thanks Arabinda❤️🙏

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

    Very useful

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

      ❤️❤️❤️

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

    Sir, App Har ek Excel Function ko Super Advance tak batatate hai

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

    Great sir

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

    sir, aapne coloum single click main kaise select kiye formula main

  • @user-xj4op4gy7k
    @user-xj4op4gy7k 16 дней назад

    Assalam u alikm
    sir kindly ye bta dyn k agr match ki sheet bn rh h tw us m rank bh dy rhy hain ab agr medal dena ho tw choose ka formula lga kr gold silver copper bronz dy rh hn mgr wo oncorrect kr dy rha h plz help krdyn

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

    Apke video se jo aap batate h wo hi jyada puche jate interview m . Guys we must watch sir ki videos .Plz like
    I watched everyday your videos .

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

      Yes Raghav..Isse bahar se ques nhi aayega...almosy maine har interview ques cover kar dunga.thanks for your love and support

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

      @@Innozant Sir aaj ji maine interview crack kiya h

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

      are wah..congrats..kaisa tha interview ..

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

      @@Innozant thanks sir maine apki videos k baad to av sav isi lgta h

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

      tha ks dear

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

    Sir Vlookup formula shows error i recheck multiple times do the same as you do please suggest me . What can i do ?

  • @775shahrukh
    @775shahrukh 17 дней назад

    dunya jaaha ki chezen samjadyn bhai apne..bus ek chose he smjana n i aya..kher hy

    • @Innozant
      @Innozant  17 дней назад

      Video dubara dekhiye concept choose ka jo bataya hai..Jahan multiple table.chaiye VLOOKUP ko table array ke jagah choose use krke usme.table store kar lenge.its very simple

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

    How to skip a colored value in Exce suml formula?

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

    Thanku sir ❤

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

    Choose function is volatile or not

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

    sir I'm stuck at putting choose formula because I couldn't get the result and I have to give presentation regarding Dashboard , I would appreciate your help please

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

    Bro explain offset function

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

      Dear.Choose function tutorial start uploading now..after that Indirect then offset in sequence.
      Kindly note i am not just uploading few demo video to attract student and then sale the video lecture to them.
      I am uploading complete video tutorial step by step.Have patience🙏♥️,You may able to see all videos there in Innozant channel..Thanks for watching.Keep supporting.

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

    We need to select value 1,value2, value 3 manually?? Any shortcut is there to select number of cells in one shot sir??

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

    Sir aap online classes dete ho kya??

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

      Yes Manish ji..aap Innozant website visit karke detail le sakte hain ya Team Innozant ko contact kar sakte hain .

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

    Vedio time at 09: 9 par ham only enter se problem solve kr sakte hai

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

      Ydi array hoga to ctrl shift enter wlse enter onlg Nisha..Thanks ..Haply learning dear❤🙏

  • @AnupKumar-oe2jb
    @AnupKumar-oe2jb 3 года назад

    Sir SQL start nahi karege kya

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

    Could you please add English subtitles.

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

    👍👍

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

      Thanks Anand..Gn

  • @puransingh-sx2tk
    @puransingh-sx2tk 3 года назад

    Sir Majedar topic,
    Sir aap ka shubh naam? 🙏😊

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

      Thanks Puran,Hey Prabhu abhi tak naam bhi nhi pata,Welcome address Innozant channel ka nhi dekhe h 😀🙏

    • @puransingh-sx2tk
      @puransingh-sx2tk 3 года назад

      Mafi guru gi har bar vedio dhyaan se dekhta hu taki aap kaam pata chale par vo vedio milta nahi hai. Aap ka sath he kafi hai

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

      ruclips.net/video/yKF56OlvaBA/видео.html
      Ye tha innozant channel ka fist video welcome address.

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

    Sir please bataye ke ctrl shift enter kyu use kiya aapn randbetween ki vajah se , apne vlookup + choose me manual table banane me ctrl+shift+enter ka use nahi kiya

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

      Nisha Jj jab array function execute krna hoga to ctrl shfr and enter se execute krenge ..jab bulka array ka case hota hai to ctrl enter only.Randbetween me random value sirf populate krna hota to ctrl enter press krte but choose ke saath use kiya hai na isliye as array treat higa aur ctrl shift enter.🙏😊

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

    I have one problem in excel..can you please help.

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

      Yes please share your sheet @innozantofficisp telegram id

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

    aap fix karna sikhadijye data

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

      Formula reference btopic dekhiye basic excel Play list se

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

    9:09
    sir yha pe apne {1,"deepak";2,"swati"......}
    kuch is trh likha h.
    isme 1, 2 column 1me and deepak,swati column 2 me mane jayenge kya?
    isi vjh se apne vlookup ke column index me 2 likha h kya taki column 2 ki values(i.e, deepak and swati anf so on) result me show ho?

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

      Ishu aap dhyan se dekhiye pehle vlookup(column Index no ki jagah Maine randbetween(1,4) Chala that means index no. Me Kabhi 1 ,Kabhi 2..Aise value aata rhega random Uske baad list position me saare name paas Kar Diya comma ke Saath..
      Usse kya Hoga ki jab index 1 aayeg to Jo name list me sbse Pehle no. Par hai wo show usi Tarah se saare in sequence show honge.

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

      Playlist se sequence me video dekhna hai..saare example Hain Aapke pass Practice karni hai saath hi jab concept finish ho Jaye Uske baad Interview Cracker jaroor attempt Karna jisse pata chale where you stand now..ok

  • @JyotiShah-sz5eq
    @JyotiShah-sz5eq 2 года назад

    Muj smj nahi aa raha aap $ function kaise use kiye.app $ wala function thoda aur highlight karke batao...isk baad mai atak gyi hu..

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

      Jyoti F4 us ekarte hain freeze karne ke liye aap basic excel se Seekhiye playlist se

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

    Sir mai poocchch rahi hu ki vedio time 9:09पर aapne direct memory insrt kiya तो फिर aapne ctrl+shift+enter use kyu kiya

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

      Enter use kiya h dear..Not ctrl shift enter

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

    Sir je ram ram

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

    Sir choose formule मे बार बार value1, 2,3 ना देना पड़े कोई तरीका है आपके पास

    • @excelonlineadvisor
      @excelonlineadvisor 5 месяцев назад

      Index_fun (value1, 2,3) is first parameter in CHOOSE FUNCTIOn syntax. So you cannot skip it

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

    sir video me table clear nhi hai