5 Advance Excel Formula in Hindi

Поделиться
HTML-код
  • Опубликовано: 19 июн 2019
  • 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.org/product or call 9752003788
    Connect with us on Facebook - / excelmadeasy
    Connect with us on Twitter - / excelmadeasy

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

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

    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 3 года назад

    Aap ka samjhane ka tarika ka bahut acha hai

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

    7 star 💫 excellent excellent sir

  • @GuruJii
    @GuruJii  5 лет назад +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

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

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

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

    Excellent Very Helpful👍

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

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

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

    Wah bahut achha laga sir.

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

    Your every video is understable

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

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

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

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

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

    Excellent Video, Thank you Sir

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

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

  • @victoryb8656
    @victoryb8656 5 лет назад

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

  • @s.srinivas3115
    @s.srinivas3115 4 года назад

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

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

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

  • @RajuDas-tm8mk
    @RajuDas-tm8mk 4 года назад

    Thank you sir it's too good.

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

    Bhot acha tarike se samjhaya apne

  • @vivekkalshan3589
    @vivekkalshan3589 5 лет назад

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

  • @gourav542
    @gourav542 5 лет назад

    Osm sir..great 😚👍

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

    Very nice information sir.

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

    U r gajab guruji

  • @TheSantuja
    @TheSantuja 5 лет назад

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

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

    excellent as always

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

    Excellent Sir.

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

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

  • @Sachin-no9ou
    @Sachin-no9ou 4 года назад

    I really like it. Plz teach all advanced formulas

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

    You r great Sir 🙏

  • @rohitarora3261
    @rohitarora3261 5 лет назад

    Thanks Sir 👍

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

    No doubt it's very helpful

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

    "EXCELLENT" Sir

  • @AmirKhan-uy4vr
    @AmirKhan-uy4vr 4 года назад

    5 Excellent

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

    Amazing 😍👌😍👌😍👌

  • @AB-ex8ck
    @AB-ex8ck 4 года назад

    Excellent 👌

  • @anantKumar-so6fh
    @anantKumar-so6fh 4 года назад

    Great..

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

    thank you sirji

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

    Amazing👍👍

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

    superb video keep going

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

    Excellent

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

    excellent video

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

    It is excellent

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

    Excellent video

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

    thank you sir

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

    excellent

  • @RashidKhan-ei8mn
    @RashidKhan-ei8mn 5 лет назад

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

  • @RohitKumar-uy7cx
    @RohitKumar-uy7cx 5 лет назад

    Nice vedio sir

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

    Super sir

  • @umeshchaudhari7481
    @umeshchaudhari7481 5 лет назад

    Thanks

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

    Nice Sir ji

  • @mohamedadjal8502
    @mohamedadjal8502 3 года назад +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.😃👍

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp 5 лет назад

    Nice video

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

    Nice sirge

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

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

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

    super

  • @SandeepKumar-jl6dq
    @SandeepKumar-jl6dq 4 года назад +1

    Sir VBA ki bhi video upload kardi jiye

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

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

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

    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

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

    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.

  • @mominaasim8879
    @mominaasim8879 5 лет назад +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  5 лет назад +3

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

  • @mayankkapoor6155
    @mayankkapoor6155 5 лет назад

    Sir pls tell how does open analysis tab in excel

  • @PoonamSharma-zz5ew
    @PoonamSharma-zz5ew 2 года назад

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

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

    👍

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

    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

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

    Is it for excel 360 or also for older version

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

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

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

    7 stars

  • @Learner566
    @Learner566 5 лет назад

    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

  • @mwasi5826
    @mwasi5826 5 лет назад

    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

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

    5 star

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

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

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

    You have uploaded another practice file

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

    Hai sir

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

    sir your voice sounds like Radio Jockey.

  • @amitkishor811
    @amitkishor811 5 лет назад

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

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

    Ye konsa version hain?

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

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

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

    Sir, you did not shown as formula for subtotal

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

    Have you ever tried on becoming a RJ??

  • @AbhishekMishra-bk2ph
    @AbhishekMishra-bk2ph 4 года назад +1

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

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

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

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

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

  • @arunkhanal7208
    @arunkhanal7208 5 лет назад +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.

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

    Jb clean he nhe dikhaga formula to smj kasa aayga

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

    Please upload correct practice file sir 😢

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

    Dont show Half working

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

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

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

    Kattapa ko to bahubali ne mar diya tha

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

    Video not clear

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

    Phle aap video clean kro okay

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

    Excellent

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

    Thanks sir

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

    Nice video

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

    👍

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

    Excellent

  • @sunilkumar-qd6pp
    @sunilkumar-qd6pp 3 года назад

    Excellent

  • @Ayush-yw5qp
    @Ayush-yw5qp 3 года назад

    Excellent

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

    Excellent