Excel Financial Functions | How to use PMT, IPMT, PPMT, FV in Hindi

Поделиться
HTML-код
  • Опубликовано: 19 авг 2024
  • Excel Financial Functions | How to use PMT, IPMT, PPMT, FV in Hindi
    Excel What If Analysis Playlist Link- • Excel What if Analysis
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    Music: www.bensound.com
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.c...
    ✅ Mastering Power BI Video Course
    www.innozant.c...
    ✅ Mastering VBA Video Course
    www.innozant.c...
    ✅ Mastering SQL Video Course
    www.innozant.c...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozanti...
    #financialfunction#pmtfunctions#innozant #excelfinancialformula#exceltutorial

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

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

    Namstai Sir ji❤Sir aapki video dekhkar aur unki practice karkai mera gyan aur baad jaata hai. Aur yai gyan sirf aapki wajah sai hai. Dil sai aapka bahut bahut Dhanywaad ❤

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

      Namaste Sandeeo Aswal sahab kaise hain aap..God bless you.❤️

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

      @@Innozant Bahut acha hu sir ji. Aap kaisai hai. Sir Big Thanks. Beacause You develops my skills.

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

    Sir ji main yahi formula google pe search krne ki try kr raha tha 2 mahine pehle... Lekin jatadari baba ne meri problem 2 mahine ke bad solve ki, vo bhi you tube pe. bot shukriya Sir ji. Khush ravo hamesha... Waheguru tanu chardi kalan ch rakhe...

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

      Thanks Sandeep..Happy learning..God bless tou dear ❤️

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

    Sir me aapka bhut bda fan ho gya ❤️❤️

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

      Thanks ❤️❤️

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

    Informative .... Thank you so much sir ji

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

      Thanks Sameena..Have a great day ahedad.God bless you❤️

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

    Super ♥️👌, Sir Baki Rate, Nper, Function k barai Mai bataye nai next video Mai bataye gaa

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

      Haan bna denge dear

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

    Very informative sir .Thank you so much 🙏🥰

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

      Thanks Harshita.Hope you find it useful.Happy learning dear❤️

  • @r.khussain929
    @r.khussain929 7 дней назад

    Thanks sir❤

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

    Sir ji kya hi samjhaya aapne 😮😮😮

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

    Sir hamare liye mahenat karne ke liye sukriya thank you sir

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

      Thanks Kishor..Have a wonderful career ahead

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

    Your all vidoes are useful for me thank you so much

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

    Bahut behtareen sir 🙏🙏🙏. good night sir

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

      Good Morning Satish ji❤️

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

    Very use ful function for financials statement for month or year very useful thank you sir

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

      Thanks Pramod ji❤️❤️

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

    Thank you so much sir,...........................

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

    amazing..very well explained sirrr

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

    Very great sir

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

    Nice sir thanks

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

      Thanks Bhavna..happy learning

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

    As always, nice & very useful content👌.
    Thanks for sharing 🙏

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

      Thanks Vishwas ji❤️

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

    Thanks Sir. Pls. make videos on other financial functions I.e. npv, irr, mirr etc. Thanks

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

    Thnq sir

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

    Thank you sir

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

    Best explanation and example ...the institute charging hefty amount can't teach as well as you do

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

    Mast

  • @theassassinseb818
    @theassassinseb818 10 месяцев назад +1

    jai haryana

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

    thanks sir❤

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

    Nyc sir

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

      Thanks Durgesh Ji

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

    Keep it up

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

    👍

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

    Financial ke in sab par bahut sara video ban chuka hai hai aashaa karta hu financial ke dusre advanced function ka video aap banayenge.
    Aur ek chij sir Ek video std ( standard deviation) ke upar v pls banaiyega.
    I like your teaching a lot.
    Thanks sir

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

      Jarur bana Denge Pramod ji ..❤️

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

      @@Innozant Thank you sir.
      Aur reply karne k liye v thanks.
      Mai bahut kuch shikha apke video se
      Ab mai computer ki class v leta hu.
      Apka Excel parne ka tarika mast hai.
      Thanks again

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

    Sir hume only Rate &Nper ki video kya ap ek do din ke andar de sakte hai plz help me now sir 🙏💖💖

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

    PMT function me Number of period agar yearly hai to use multiply by 12 kyon karte hai divide by 12 kyon nahi??

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

    Hi sir nice video 😀

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

    Sir kindly make a playlist on if function from normal to advance, same for data validation , pivot table and dashboard, sumifs

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

      Dear Bharti , Playlist for all topic are there ,kindly find seprate playlist of Basic Excel,pivot table ,data validation etc in channel❤️❤️

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

      @@Innozant thnk u sir

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

    A.o.A
    Why we devide rate by 12

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

    Hai sir...im big fan of you.. How to calculate down payment for bikes or cars.. By using pmt, ppmt and ipmt

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

      I mean after paying down payment and how ppmt and ipmt will be paid every month

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

    👌👌

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

    Sir how to any cell enter value and show the value is +value

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

      Didnt get your query

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

    Bro ek request hai please make a video only for all financial functions

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

      Ok .bnate hain

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

      @@Innozant Love and respect to listen your viewers

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

    Sir finance department ko maintain karne k liye mostly kin kon kon se formula use hote h...plz reply me

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

      Wo depend karta hai Karishma requirements ke upar.

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

      Ok sir thank you 😊

  • @deepalikamble3721
    @deepalikamble3721 6 месяцев назад

    Sir ham recurring deposit karrahe hai or mujhe 5 year ke bat 500000 cahiye interest rate 12% p.a hai to hame har month kitna rupe bharne honge o hamne agr nikala to o amount hm interest ke sath bhar rahe haina?

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

    I'm the first person who see your video first 🥇

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

      Thanks Arun Ji..Happy learning dear

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

    Hi sir, pmt sirf monthly payments ko calculate karta hai ya woh yearly ka b calculate karta hai?

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

      For monthly emis

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

      @@Innozant OK sir thank you!

  • @AP-gr4ij
    @AP-gr4ij Год назад

    Sir agar mujhe 100 loan lena hai aur 8% 1year kr liye to interest 108 hoga pr 6 month me se nikal rha hu to 53 kuchh paise lekin hona chahiye jab add karta ho 6 month ko to 106 hi ho rha hai aisa kiyo

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

    Sir VBA kab start kar rahe ho

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

      Planning the start soon

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

    Sir jb hum vlookup se value pick krte hai to wo first value hi uthata hai but jo humari lookup value do bar arhi hai to hum dono value kaise legue first column me first value second column me second value please reply

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

      Dear Sonu,Using countif duplicate vlookup use krenge with the help of helper column, alredy video hai iska check kren

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

      @@Innozant thanku sir

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

    Sir ye file download nahi ho raha hai

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

      Kyu .link hai to maine daala hai link dear

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

    Your name?