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

Поділитися
Вставка
  • Опубліковано 22 сер 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 ❤️❤️

  • @r.khussain929
    @r.khussain929 9 днів тому

    Thanks sir❤

  • @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❤️

  • @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

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

    Informative .... Thank you so much sir ji

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

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

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

    Sir hamare liye mahenat karne ke liye sukriya thank you sir

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

      Thanks Kishor..Have a wonderful career ahead

  • @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❤️❤️

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

    Your all vidoes are useful for me thank you so much

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

    Sir ji kya hi samjhaya aapne 😮😮😮

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

    Bahut behtareen sir 🙏🙏🙏. good night sir

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

      Good Morning Satish ji❤️

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

    Nice sir thanks

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

      Thanks Bhavna..happy learning

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

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

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

    amazing..very well explained sirrr

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

    Very great sir

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

    Thnq sir

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

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

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

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

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

      Thanks Vishwas ji❤️

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

    Mast

  • @theassassinseb818
    @theassassinseb818 10 місяців тому +1

    jai haryana

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

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

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

    Thank you sir

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

    Nyc sir

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

    thanks sir❤

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

    Keep it up

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

    Hi sir nice video 😀

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

    👍

  • @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

  • @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 🙏💖💖

  • @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

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

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

  • @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

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

    A.o.A
    Why we devide rate by 12

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

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

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

      Didnt get your query

  • @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 😊

  • @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!

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

    👌👌

  • @deepalikamble3721
    @deepalikamble3721 7 місяців тому

    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?

  • @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

  • @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

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

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

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

      Thanks Arun Ji..Happy learning dear

  • @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?