5 Advance Excel Formula in Hindi

Sdílet
Vložit
  • čas přidán 23. 08. 2024
  • 5 एक्सेल के एडवांस फार्मूला . Learn the 5 advance excel formula in Hindi. Download Practice Files from wp.me/p7DKaP-1cV
    In this excel tutorial you will learn the most used top 5 excel formula
    1 - Index and Match Formula in Excel Hindi - 1:00
    2 - Subtotal Formula in Excel Hindi - 4:00
    3 - Whatif Formula in Excel Hindi - 6:43
    4 - Indirect Formula in Excel Hindi - 9:00
    5 - Choose Formula in Excel Hindi - 12:46
    These top 5 advance excel formula will help you do analysis and make report in excel.
    Formulas covered in this video are
    Choose Formula
    Indirect Formula
    Whatsif Formula
    Index and Match Formula
    Subtotal Formula
    ** Useful Excel formulas and Functions **
    10 Most Used Formulas MS Excel- • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners- • Learn Basic Excel Skil...
    Learn the Basic of Excel for Beginners - • Learn the Basic of Exc...
    10 Most Used Excel Formula- • 10 Most Used Excel For...
    Learn Vlookup Formula For Beginners in Excel- • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews- • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel- • Create Speedometer Cha...
    Create Pareto Chart In Excel- • Create Pareto Chart In...
    How to Create Dashboard in Excel- • How to Create Dashboar...
    Excel Interview Questions & Answers- • Excel Interview Questi...
    To watch more videos and download the files visit www.myelesson.org
    To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
    Connect with us on Facebook - / excelmadeasy
    Connect with us on Twitter - / excelmadeasy

Komentáře • 101

  • @GuruJii
    @GuruJii  Před 5 lety +5

    1 - Index and Match Formula in Excel Hindi - 1:00
    2 - Subtotal Formula in Excel Hindi - 4:00
    3 - Whatif Formula in Excel Hindi - 6:43
    4 - Indirect Formula in Excel Hindi - 9:00
    5 - Choose Formula in Excel Hindi - 12:46

  • @ranveerranu8209
    @ranveerranu8209 Před rokem

    Sir
    Apke sare video bohot Jada ache hote hain.
    Jese apne vlookup 7 type wali video me vlookup+ columns se Ctrl enter se ek hi bar me sare answers la dia tha.
    Wese hi index match ke liye logic samjha dijiye please 🙏.
    . vlookup wali video ne bohot Jada help kia or office me hero ban gya.
    Thank you sir.
    Bas aashirwad mitla rahega to or Jada tarakki kar paunga.

  • @vinodprajapat1537
    @vinodprajapat1537 Před 3 lety

    Aap ka samjhane ka tarika ka bahut acha hai

  • @adarshkumar8121
    @adarshkumar8121 Před 3 lety +1

    7 star 💫 excellent excellent sir

  • @mahaboobhossain5076
    @mahaboobhossain5076 Před 4 lety

    Your every video is understable

  • @kamilpipadwala4307
    @kamilpipadwala4307 Před 2 lety

    Excellent Very Helpful👍

  • @poetrypoint1711
    @poetrypoint1711 Před rokem

    Sir your talking style too good. When I listen your voice first time. It's seem like RJ on radio.

  • @muntazmoddinshaikh8392
    @muntazmoddinshaikh8392 Před 5 lety +6

    ***** ( 5 Star) Excellent Rating sir. Thank you.

  • @tinkuposting
    @tinkuposting Před 3 lety

    U r gajab guruji

  • @umangsharma2589
    @umangsharma2589 Před 4 lety

    Very easy to download the excel file, Thanks..Good Work.

  • @aksdchhvhj7362
    @aksdchhvhj7362 Před 3 lety

    you are my favorite teacher. thank you sir, keep doing great

  • @savirajchauhan230
    @savirajchauhan230 Před 4 lety

    Bhot acha tarike se samjhaya apne

  • @mahaboobhossain5076
    @mahaboobhossain5076 Před 4 lety

    Excellent video

  • @vivekgovila4148
    @vivekgovila4148 Před 4 lety

    Really informative. Excellent way to explain. All the best.

  • @manubhaiprajapati3483
    @manubhaiprajapati3483 Před 3 lety

    It is excellent

  • @nikujha2895
    @nikujha2895 Před 3 lety

    Wah bahut achha laga sir.

  • @dhaneshwarirawat173
    @dhaneshwarirawat173 Před 2 lety

    superb video keep going

  • @s.srinivas3115
    @s.srinivas3115 Před 4 lety

    Excellent superb sir U R lesson helping us lot I will give U 10 out of 10

  • @victoryb8656
    @victoryb8656 Před 5 lety

    Thanks for sharing, please post more advance formula videos. Appropriate your hard work.

  • @kritiprajapati7610
    @kritiprajapati7610 Před 3 lety

    Excellent

  • @vishaltyagi2137
    @vishaltyagi2137 Před 3 lety

    I must say excellent.. Thank you sir, keep doing great👍

  • @mohamedadjal8502
    @mohamedadjal8502 Před 3 lety +1

    hi, Professor, you have made a lot of efforts for these videos, thank you, I have a question if we have for example in the cell "a1" the number 10.00 m, how to have this number with the same format in the cell "b1 "using the text function or some other function, thank you very much.😃👍

  • @debasishchanda8223
    @debasishchanda8223 Před 4 lety

    Excellent Video, Thank you Sir

  • @suneelkumargoyal
    @suneelkumargoyal Před 4 lety

    Super sir

  • @sanjayghai7934
    @sanjayghai7934 Před rokem

    Nice Sir ji

  • @TheSantuja
    @TheSantuja Před 5 lety

    Excellent video sir & thank you☺️☺️☺️☺️☺️☺️☺️☺️

  • @Sachin-no9ou
    @Sachin-no9ou Před 4 lety

    I really like it. Plz teach all advanced formulas

  • @smsaif0074
    @smsaif0074 Před 3 lety

    You r great Sir 🙏

  • @durgarao1991
    @durgarao1991 Před rokem

    Nice sirge

  • @SandeepKumar-jl6dq
    @SandeepKumar-jl6dq Před 4 lety +1

    Sir VBA ki bhi video upload kardi jiye

  • @LearnTheTrading
    @LearnTheTrading Před 3 lety

    "EXCELLENT" Sir

  • @sjfgj
    @sjfgj Před 4 lety

    Very nice information sir.

  • @prashant1513
    @prashant1513 Před 4 lety

    Excellent Sir.

  • @Sandeepsingh5016
    @Sandeepsingh5016 Před 4 lety

    The formula you typed in cell is not clear at place. It's request you to please mentions formula in contents of the video, so that user can easily find out the formula, if they get confused while doing it their own.
    Finally, Superb video with explanation.

  • @shaistasayyad6859
    @shaistasayyad6859 Před 3 lety +1

    Amazing👍👍

  • @krishnaupadhyay409
    @krishnaupadhyay409 Před 3 lety

    Nice video

  • @vyankateshodilwar
    @vyankateshodilwar Před 3 lety

    No doubt it's very helpful

  • @RashidKhan-ei8mn
    @RashidKhan-ei8mn Před 5 lety

    Zabardast sir ji. Sir main chata ho vlookup, index, or match. Formula ek sat kaise lagaya jai videos banai plz

  • @RajuDas-tm8mk
    @RajuDas-tm8mk Před 4 lety

    Thank you sir it's too good.

  • @dirghangiamit9997
    @dirghangiamit9997 Před 3 lety

    excellent as always

  • @syedaaqib6210
    @syedaaqib6210 Před 4 lety

    The sheet you upload it is much helpful ,Thank you so much

  • @mominaasim8879
    @mominaasim8879 Před 5 lety +1

    Sir, please ye bhi bata diya karein k ap excel k konsay version per kaam kar rahay hein . Thank you . You taught me a lot of things . 😊

    • @GuruJii
      @GuruJii  Před 5 lety +3

      I am using Excel 2019 right now but these formulas will work on any version of excel.

  • @AmirKhan-uy4vr
    @AmirKhan-uy4vr Před 4 lety

    5 Excellent

  • @PoonamSharma-zz5ew
    @PoonamSharma-zz5ew Před 2 lety

    Hi pls let me know about the how MIS preparation in Google sheets.

  • @vivekkalshan3589
    @vivekkalshan3589 Před 5 lety

    sir your video is very intersting we everyday learn something new from org

  • @prakashrajbanshi1476
    @prakashrajbanshi1476 Před 4 lety

    super

  • @shivamtomer8273
    @shivamtomer8273 Před 3 lety

    Amazing 😍👌😍👌😍👌

  • @AB-ex8ck
    @AB-ex8ck Před 4 lety

    Excellent 👌

  • @rajanchauhan6819
    @rajanchauhan6819 Před 4 lety

    thank you sirji

  • @parveenv99
    @parveenv99 Před 4 lety

    thank you sir

  • @mahaboobhossain5076
    @mahaboobhossain5076 Před 4 lety

    excellent video

  • @gourav542
    @gourav542 Před 5 lety

    Osm sir..great 😚👍

  • @Bolta_Insaan
    @Bolta_Insaan Před 5 lety +1

    Hello Sir How are you
    Please make a video on offset function
    Thank you

  • @anantKumar-so6fh
    @anantKumar-so6fh Před 4 lety

    Great..

  • @rohitarora3261
    @rohitarora3261 Před 5 lety

    Thanks Sir 👍

  • @jeetendrak8073
    @jeetendrak8073 Před 3 lety

    Sri apka video 👍 but I have one question that if there is multiple conditioning than in that case what formula we can use replace to goal seek ❓plz help

  • @mahaboobhossain5076
    @mahaboobhossain5076 Před 4 lety

    Can u make dynamic version of indirect function that will be helpful for us in reporting?

  • @prajwalshetty2047
    @prajwalshetty2047 Před 3 lety

    👍

  • @varindersinghce5245
    @varindersinghce5245 Před 3 lety

    5 star

  • @monikasadawarte3447
    @monikasadawarte3447 Před 4 lety

    excellent

  • @umeshchaudhari7481
    @umeshchaudhari7481 Před 5 lety

    Thanks

  • @NutriBite_Insights
    @NutriBite_Insights Před 4 lety

    Excellent video sir,
    Sir ek help kijiye please "agar cell color fill blue h to next cell m automatic blue likha ayega" please sir agar aisa possible h to ek video banaiye

  • @RohitKumar-uy7cx
    @RohitKumar-uy7cx Před 5 lety

    Nice vedio sir

  • @deadlyslayer3251
    @deadlyslayer3251 Před 2 lety

    Is it for excel 360 or also for older version

  • @arunkhanal7208
    @arunkhanal7208 Před 5 lety +4

    At time line 10:21 (m:s)
    Select the range B3:D10 then
    Ctrl + SHIFT + F3 (Select Top Row and Left Column)
    OK
    Range Names will be created within fraction of second for both the Top Row and Left Column.

  • @experiments_and_techno_in_KA

    You have uploaded another practice file

  • @Learner566
    @Learner566 Před 5 lety

    Sir user from se kaise. Dusre sheet me or dusre workbook dono me ek saath data transfer hoga. Dusre workbook ka srif file name type korona hoga user from me.plz me sir

  • @mayankkapoor6155
    @mayankkapoor6155 Před 5 lety

    Sir pls tell how does open analysis tab in excel

  • @mwasi5826
    @mwasi5826 Před 5 lety

    sir ap moja koi asa formula bta jis sa ham bhot sara coloum or row ko ik sath delete kr ska simple ya jo filter ha is ko chor ka agr ho to moja b bta da plz

  • @mahaboobhossain5076
    @mahaboobhossain5076 Před 4 lety

    Brother how to send sms by excel can u make the video plzzzzzzzz?

  • @muralimohanteegala3506

    Hai sir

  • @vijaymarcos8305
    @vijaymarcos8305 Před 3 lety

    what if when we copy the paste the same its shows N/A in rest of columns.

  • @mazherali2965
    @mazherali2965 Před 4 lety

    7 stars

  • @safaiinternational1342

    Name Uper Nichay ho to wo sort nahi hotay Subtotal wali sheet main
    please advise??

    • @niteshsoni4867
      @niteshsoni4867 Před 2 lety

      sort karke baad mein subtotal laga sakte ho....

  • @MsElish
    @MsElish Před 3 lety

    Sir, you did not shown as formula for subtotal

  • @Taarkaata
    @Taarkaata Před 3 lety

    Ye konsa version hain?

  • @amitkishor811
    @amitkishor811 Před 5 lety

    Numeric to text in hindi main convert kare. As 114 एक सौ चौदह इस तरह हो।

  • @aksdchhvhj7362
    @aksdchhvhj7362 Před 3 lety

    sir your voice sounds like Radio Jockey.

  • @biswajitchakraborty8780

    But choose formula does not work on character it only accept numerical digit i.e 1,2 so on

  • @AbhishekMishra-bk2ph
    @AbhishekMishra-bk2ph Před 4 lety +1

    Sirji isme index and match formula nahi ho para video dekne ke bawjod ok

  • @RaahiVibes
    @RaahiVibes Před 3 lety

    Have you ever tried on becoming a RJ??

  • @rrr1603
    @rrr1603 Před 4 lety

    Jb clean he nhe dikhaga formula to smj kasa aayga

  • @experiments_and_techno_in_KA

    Please upload correct practice file sir 😢

  • @nadeemshah6214
    @nadeemshah6214 Před 2 lety

    Dont show Half working

  • @rrr1603
    @rrr1603 Před 4 lety

    Are sir aapka video she nhe dikh RHA h phle aap esko clean kro okay

  • @yakubkhan5649
    @yakubkhan5649 Před 3 lety

    Kattapa ko to bahubali ne mar diya tha

  • @parich7205
    @parich7205 Před 4 lety

    Video not clear

  • @rrr1603
    @rrr1603 Před 4 lety

    Phle aap video clean kro okay

  • @sunilsundaram6163
    @sunilsundaram6163 Před 3 lety

    Excellent

  • @abdulkadir3239
    @abdulkadir3239 Před 4 lety

    Thanks sir

  • @maharajpatel5449
    @maharajpatel5449 Před 3 lety

    👍

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp Před 5 lety

    Nice video

  • @sunilkumar-qd6pp
    @sunilkumar-qd6pp Před 3 lety

    Excellent

  • @Ayush-yw5qp
    @Ayush-yw5qp Před 3 lety

    Excellent

  • @rohinighadshi6287
    @rohinighadshi6287 Před 4 lety

    Excellent

  • @rakeshrajbhar8966
    @rakeshrajbhar8966 Před 5 lety

    Excellent