Excel financial function to calculate EMI? || Excel Formulas in Hindi

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ม.ค. 2019
  • In this video you will learn excel financial functions to calculate emi and also use to calculate pv in excel ipmt in excel, ppmt in excel, this formula is work in excel 2007, excel 2013, excel 2010, excel 2016, excel 2019 with this formulas you will completely know that we can extract interest and principle amount from given emi,
    Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
    Excel Financial functions points
    What is pmt in Excel?
    What is impt in Excel?
    What is ppmt in Excel?
    What is pv in Excel?
    What is fv in Excel?
    SORRY FOR DELAY PRACTICE FILE LINK : drive.google.com/open?id=1KGW...
    #ExcelFormula
    #ExcelTutorial
    #ExcelInHindi
    ------------------------------------------------------------------------------------------------------------------------------
    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Courses Website :bit.ly/skill_course
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇️ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/
    ------------------------------------------------------------------------------------------------------------------------------
    Telegram channel: telegram.me/learnmoreindia
    Check our latest blogs: learnmoreindia.in/
    ------------------------------------------------------------------------------------------------------------------------------
    Social media Pages:
    Facebook Page Link: bit.ly/3CvGlBT
    Instagram Page Link: bit.ly/3f9R37u
    ------------------------------------------------------------------------------------------------------------------------------
    My Other Channels:
    Real Tutorial: ✅
    / @realtutorial550
    Complete Technology:✅
    / @completetechnology
    Learn more shorts:✅
    / @learnmoreshorts
    Satish Tech (Marathi):✅
    / @satish_tech
    Tally Tutorial:✅
    / @tallytutorial
    Exce Tutorial:✅
    / @excel_tutorial
    Learn More:✅
    / @learn_more
    Curiosity: ✅
    / @curiosity9432
    ------------------------------------------------------------------------------------------------------------------------------
    My TH-cam Gears :
    Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
    Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
    My DSLR Camera Canon 200D: amzn.to/39ciw3E
    My Laptop (Video Editing): amzn.to/2UXQj8h
    Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
    Antivirus: amzn.to/3l3TIgi
    Screen Recording Software: bit.ly/2J39n2j
    Video Editing Software: bit.ly/3nOPlri
    Green screen with Stand: amzn.to/2KAl1Cu
    Watch other Videos :
    Excel Basic to Advance Series : • Excel tutorial || Exce...
    Excel Amazing Features - • समय बचाना है तो सीखो य...
    Excel Advance 100 Videos - • Excel Introduction In ...
    Excel VBA Series in Hindi- • What is VBA in Excel? ...
    Excel MIS Videos - • ये सीखने के बाद एक्सेल...
    Word Series :
    • MS-Word Introduction |...
    PowerPoint Series : • सेमिनार, प्रेजेंटेशन, ...
    AUTOCAD SERIES : • ऑटोकैड सीरीज अब हिंदी ...
    Technology Videos - • Interview Preparation ...
    Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
    Tags - Excel financial function, excel, excel formulas in hindi, excel 2007, excel 2013, excel 2016, excel 2019, excel ppmt, excel pmt, excel ipmt, excel pv, excel fv, excel pmt function, excel pmt formula, formulas in excel, formula, excel tricks, excel tips, excel formula, excel formulas, excel functions, excel functions in hindi, microsoft excel, excel tutorial in hindi, learn more, satish dhawale,

ความคิดเห็น • 605

  • @Learn_More_Pro
    @Learn_More_Pro  2 ปีที่แล้ว +8

    Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

    • @pushkartiwari5942
      @pushkartiwari5942 10 หลายเดือนก่อน

      Jay Shree Ram 💞💞💞💞💞💞💞💞💞💞💞💞💞💞

  • @SP-xz9bn
    @SP-xz9bn ปีที่แล้ว +6

    Best vdo ever. No unnecessary time prolonging talk. To the point precise and crisp.

  • @technicalvikassir4494
    @technicalvikassir4494 6 หลายเดือนก่อน +2

    सर आपने इतने अच्छे से समझाया कि जिसने कभी कंप्यूटर 💻 देखा भी ना हो बो भी Pmt,Ipmt,Ppmt बहुत अच्छे से निकाल लेगा ।।
    में आपके इस टेलेंट के लिए बहुत बहुत धन्यवाद देता हूं
    और ईश्वर से कामना करता हू कि आप कंप्यूटर के क्षेत्र में ऐसे ही आगे बढ़ते रहे
    बहुत बहुत धन्यवाद सर

  • @nxt_harsh_freefire1429
    @nxt_harsh_freefire1429 4 ปีที่แล้ว +1

    I seen your conditional formatting many times and finally I lernt how we apply so you are excellent be happy

  • @soumyojitduttaroy2086
    @soumyojitduttaroy2086 3 ปีที่แล้ว +6

    THANKS SIR .FOR EXPLAINING THIS TOPIC SO BEAUTIFULLY.

  • @hv3300
    @hv3300 5 ปีที่แล้ว +2

    Great job..Add more videos like this with real world examples.

  • @7513747
    @7513747 5 ปีที่แล้ว +4

    thank you for explaining in details. really enjoyed watching this video.

  • @AshishKumar-sr8yq
    @AshishKumar-sr8yq 5 ปีที่แล้ว +6

    One of the best Video. You're Great. Thank you so much.

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว +1

      Thanks brother for watching this video....

    • @soniajames273
      @soniajames273 3 ปีที่แล้ว

      @@Learn_More_Pro great 👍video. very informative easy to understand...Thank you Sir. One request....kindly make a full video on all financial formulas Or series.

  • @amitsinha3955
    @amitsinha3955 4 ปีที่แล้ว +2

    Thank You so much Satish Sir, for this fantastic class.

  • @rachnamalviya776
    @rachnamalviya776 3 ปีที่แล้ว

    there is one of excel's most useful formula that you have explained can be useful for those kind of people who have desire to work any bank..... i want to thank you for your explaining of this beneficial topic .......thanks a millions sir

  • @rahulyp837
    @rahulyp837 4 ปีที่แล้ว

    You are a damn hard worker bro....tough things simplifies so easily.....keep it up.

  • @Avyuktmemory
    @Avyuktmemory ปีที่แล้ว

    Bus ek baat kahungi sir apke karan mai aaj ek achi computer teacher hu tq so much

  • @Coputerstudio
    @Coputerstudio ปีที่แล้ว +1

    I see this video two time and I fully understand this concept. Thank you so much sir ji.
    You tussi great ho.

  • @legacyforfitness3096
    @legacyforfitness3096 4 ปีที่แล้ว +1

    Sir you are outstanding,I am learning well by seeing your videos. Thank you so much........ and please upload more videos about excel bcoz what all function there in excel mostly I don't know.thanks once again

  • @dikshasahni7320
    @dikshasahni7320 3 ปีที่แล้ว

    Best Financial Modelling video. Thank you for making this video.

  • @prabhakarpawar573
    @prabhakarpawar573 5 ปีที่แล้ว +4

    व्हिडीओ खूप सुंदर आणि खूप महत्त्वाचा आहे सर,

  • @sunilkumarjha475
    @sunilkumarjha475 4 ปีที่แล้ว +1

    thanks a lot sir, I was confused about per and nper. But now it is clear

  • @ShariqKhanOfficial
    @ShariqKhanOfficial 2 ปีที่แล้ว

    BOHOT MAZA AAYA. KUCH NAYA SIKHNE KO MILA. EXCEL KI JOURNEY AAPSE HI SIKHI HIA....

  • @umeshmishra2010
    @umeshmishra2010 5 ปีที่แล้ว

    I like sir your way of teaching style. Nice. Hope you do keep it up for the deserving people. And dont worry for timing out period it s no matter. really. sir

  • @md.moslehuddinuddin4077
    @md.moslehuddinuddin4077 5 ปีที่แล้ว +1

    Yes, Sir; It's wonderful.

  • @mohansinghchundawat8043
    @mohansinghchundawat8043 5 ปีที่แล้ว

    Good sir
    It's new for me and ours and we can argument to financier.
    Happy to know

  • @shreeshyamenterprises6399
    @shreeshyamenterprises6399 5 ปีที่แล้ว

    Thank you very much me kahi mahino se aise video search kar raha tha finally mil gya and thanks for excel sheet

  • @gpnewsmyd9604
    @gpnewsmyd9604 5 ปีที่แล้ว +1

    Maashallah ....Nice video sir....
    THANK YOU...

  • @piyushgoyal6977
    @piyushgoyal6977 5 ปีที่แล้ว +1

    you work great sir. your video is so easy to learn.

  • @sam6524
    @sam6524 5 ปีที่แล้ว

    Iss video k liye ek se ziyada like banta hai. Very nice video . Thanks

  • @deepikamishra7601
    @deepikamishra7601 4 ปีที่แล้ว +1

    Your explanation very Clear thank so much sir

  • @aSingh-rr5ro
    @aSingh-rr5ro 3 หลายเดือนก่อน

    Wow Sir I understand it very easily. You are best Sir Thany you😊.

  • @swiftwealth
    @swiftwealth 4 ปีที่แล้ว +2

    Amazing... thanks for all..

  • @utkalgourabmishra603
    @utkalgourabmishra603 4 ปีที่แล้ว

    Bohot achha video hai sir, pata nehin mere kam mein ayega ya nehin lekin i am watching because I have more interest to know about excel🙏🙏🙏🙏😝😝😝😝

  • @vijaykumarhandigol1906
    @vijaykumarhandigol1906 5 ปีที่แล้ว

    THANKS SIR , APNE BAHUT SIMPLE TARIKE SE AND ACHHA SAMJA DIYA., VERY USEFUL FOR BIGGINERS THANKS FOR ONCE AGAIN ..

  • @shivc6697
    @shivc6697 5 ปีที่แล้ว

    Very nice lecture sir, thanks for knowledgeable videos. waiting for next. thanks

  • @somyajain3806
    @somyajain3806 2 ปีที่แล้ว

    Your video was too informative. All concept are crystal clear

  • @rohitsharma2390
    @rohitsharma2390 ปีที่แล้ว

    Sir you are the best teacher for financial formulas explain

  • @surendarsingh8963
    @surendarsingh8963 ปีที่แล้ว

    Thankyou Bade Bhai ❤️❤️ Love from Tamilnadu ❤️❤️ today leaned some new financial calculation formulas thanks alot from heart ❤️❤️😊

  • @puneetvij8433
    @puneetvij8433 5 ปีที่แล้ว

    Satish Sir,
    बहुत बड़िया, detail में सिखाया सब | ; )

  • @kamalsingh-ud7bt
    @kamalsingh-ud7bt 3 ปีที่แล้ว

    you are outstanding in excel lecture.........lot of good wishes from youtube learners

  • @vgsbuddy2036
    @vgsbuddy2036 5 ปีที่แล้ว +1

    This video useful for me first time understand how to calculate loan term EMI thanks guru ji 🙏 I try my PC

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว

      Thanks a lot for watching this video and giving ur feedback .......

  • @arunkumar-zt7ks
    @arunkumar-zt7ks 5 ปีที่แล้ว

    You are the best person for Excel

  • @VijayPal-ov6ni
    @VijayPal-ov6ni 2 ปีที่แล้ว

    Sir apki vdo ko like jrur diya h. Aap bhut achha samjhate hain sir. Thank u so much🙏🙏🙏

  • @dkanandasoi1362
    @dkanandasoi1362 4 ปีที่แล้ว +1

    Impt and ppmt formula are very useful for me. Thankyou guruji.

  • @ritikagour7127
    @ritikagour7127 ปีที่แล้ว

    Sir aapne bahut hi ache se sare concept clear kiye h video bht hi achi se bnai h or explain too👌👌👌👌👌👌

  • @enjoyinglife4932
    @enjoyinglife4932 4 ปีที่แล้ว

    Thank you sir
    Tapash Roy, West Bengal Police
    I do regularly follow your video and it is really beneficial for me.

  • @rprshama
    @rprshama 5 ปีที่แล้ว +1

    Hi Satish
    One can understand entire banking system in this video.
    Salute👌👍👌👍👌👍

  • @peerirshad9733
    @peerirshad9733 ปีที่แล้ว +1

    Thank u sir g ( love from Kashmir)♥️

  • @kaifiazmi2822
    @kaifiazmi2822 ปีที่แล้ว

    Nice sir ....good teaching than other teacher ..salute u sir

  • @studya.y1353
    @studya.y1353 2 ปีที่แล้ว

    Thanku you sir I am easily understanding every topic. your teaching Way is excellent .

  • @vinaybhagwat1526
    @vinaybhagwat1526 4 ปีที่แล้ว

    Thanks a lot Satishji, Excellent explanation

  • @rayyanmukhtar5743
    @rayyanmukhtar5743 4 ปีที่แล้ว

    Respected Sir
    Good afternoon
    Very very helpful video& Practice notes
    Thank you sir

  • @ninamarohit5016
    @ninamarohit5016 ปีที่แล้ว

    Sir apne is video ne ipmt,ppmt aur pmt ye shikhne mila thank you 😊 sir

  • @OmPrakashUPSI
    @OmPrakashUPSI ปีที่แล้ว +1

    सर आप बहुत अच्छे से फॉर्मूला को एक्सप्लेन कर के स्टूडेंट्स को समझाते हैं आप के लिए तो हमारी ओर से एक लाइक तो बनता है सर 👍👍👍

    • @vinodupadhyay5605
      @vinodupadhyay5605 10 หลายเดือนก่อน

      यार mereko samajh me nhi aaya ye Excel galat calculation kar rha hai ya sahi isme 1000000 ka 10% 1 lakh hota hai or multiply 5 year par karne se 5 lakh hoga jabki ye to 2 lakh bata rha hai

  • @viksingh9741
    @viksingh9741 2 ปีที่แล้ว

    Very helpful..tnx sir

  • @nikhilagarwal3551
    @nikhilagarwal3551 5 ปีที่แล้ว +2

    Good video! Please add more advanced financial functions videos

  • @thanendradasmanikpuri6758
    @thanendradasmanikpuri6758 4 ปีที่แล้ว

    You're teaching technique Superb sir

  • @vaibhavpawar3509
    @vaibhavpawar3509 4 ปีที่แล้ว

    Thanks you sir बहुत अछा पढाते हो.👌👌👌👌👌👌👌👏👏👏👏👏👏👏🙏🙏🙏🙏🙏🙏🙏🙏ओर मेरी छोटीसी request है एसेही नये नये formula के नये नये विडिओ बनाते रहो.🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌👈👈👈👈🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

  • @ArunKumar-fe4fq
    @ArunKumar-fe4fq 5 ปีที่แล้ว

    Useful video's. Thank you sir

  • @prakashchaudhari9714
    @prakashchaudhari9714 5 ปีที่แล้ว +1

    dear sir
    this video is a very very good from me.

  • @avtarsinghsidhu8223
    @avtarsinghsidhu8223 4 ปีที่แล้ว

    Very knowledgeable video, lot of thanks for this. But kindly make some video for calculation of EMI on daily reducing balance with prepayment options or other charges like taxes etc

  • @sskdavid6434
    @sskdavid6434 4 ปีที่แล้ว

    You've explained very easily

  • @Educationtechonology
    @Educationtechonology 5 ปีที่แล้ว +1

    Very fantastic video i like these type of video in excel and in this video all things are new for me

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว

      Thanks a lot bro for watching this video.....I hope u will share with your frnds. .....

  • @dhruvyadav8863
    @dhruvyadav8863 ปีที่แล้ว +2

    I am Big fan Sir

  • @Saradesignes
    @Saradesignes หลายเดือนก่อน

    mene kafi kuj sikha thanku so much
    🤗

  • @prashantgaikwad9961
    @prashantgaikwad9961 4 ปีที่แล้ว +1

    Very nice formula Sir..✌️

  • @msexcelgooglesheet374
    @msexcelgooglesheet374 3 ปีที่แล้ว

    Awesome video for account students ❤

  • @Pradumn-Funny.Videos
    @Pradumn-Funny.Videos 4 ปีที่แล้ว

    Completely understood Finacial fuction thank you sir 😇

  • @sureshkumarverma6756
    @sureshkumarverma6756 ปีที่แล้ว

    Thank you so much sir 💞 aap bahut acchhe se samjhate hai

  • @AshishKumar-ym5eh
    @AshishKumar-ym5eh 2 ปีที่แล้ว

    Really It's very very great Presentation Sir.. I liked...I salute... Because.. I'm Solder na Sir... 🇮🇳🇮🇳🇮🇳

  • @chandrkantjagtap1534
    @chandrkantjagtap1534 2 ปีที่แล้ว

    Sir Simply understanding, thank you so much

  • @shoryaarora1464
    @shoryaarora1464 5 ปีที่แล้ว +1

    Superb 👍🏻 please also make a video on calculate rate of interest

  • @sonukumarjha6749
    @sonukumarjha6749 4 ปีที่แล้ว +1

    Aap jaise sir ko mera good morning sir

  • @haroonmasih4378
    @haroonmasih4378 ปีที่แล้ว

    Excellent Sir, PV & FV was new for me.

  • @vasudevpalav581
    @vasudevpalav581 4 ปีที่แล้ว +1

    Thank you very much sir for every detail explanations

  • @sabitakumarisahu6163
    @sabitakumarisahu6163 4 ปีที่แล้ว

    Excellent quality training

  • @deepaksoni4366
    @deepaksoni4366 4 ปีที่แล้ว

    You helped me lot 😘🙏 🙌 Thank you sir

  • @aervabhikshu4132
    @aervabhikshu4132 4 ปีที่แล้ว

    Nicely explained.. Thank you sir...

  • @souvikseth4237
    @souvikseth4237 4 ปีที่แล้ว +1

    Nice Video Sir Thank You.......

  • @hiteshkumar4703
    @hiteshkumar4703 5 ปีที่แล้ว +1

    Kya baat he....... Maja aa gaya...... Keep it up...

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว

      Thanks brother for watching this video....I hope u will share with ur frnds.....

  • @manojitkora8428
    @manojitkora8428 3 ปีที่แล้ว

    We are thankful. To you sir.we are so helpful to see your vedio

  • @arbazamin2317
    @arbazamin2317 3 ปีที่แล้ว +1

    Sir really you helped me alot
    You aa such a great👍 person
    Way of teaching is so beautiful
    Thanks alot
    PlZ excel ka detailed video upload kardeijyai
    Respect from kashmir

  • @md.moslehuddinuddin4077
    @md.moslehuddinuddin4077 5 ปีที่แล้ว

    Thank you, Sir. This is very helpful to me. Md. Mosleh Uddin, Dhaka

  • @kiranbandekar2434
    @kiranbandekar2434 4 ปีที่แล้ว +1

    1 नंबर सर जी।।।

  • @user-ww6rq8nk8s
    @user-ww6rq8nk8s 4 ปีที่แล้ว

    Great, well explanation 👍

  • @dipakjha5546
    @dipakjha5546 5 ปีที่แล้ว

    Thank you so much for helping us........

  • @dixitkumarchaurasia7584
    @dixitkumarchaurasia7584 5 ปีที่แล้ว +1

    Nice trik sir all rady trik understand sir but very nice lecture and reading sir

  • @tulasimaharana379
    @tulasimaharana379 7 หลายเดือนก่อน

    Bahut achhi tarah se samjhaya sir
    Dhanyabad

  • @bimalbiswas6121
    @bimalbiswas6121 5 ปีที่แล้ว +1

    Amazing
    Useful video sir..

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว +1

      Thanks brother for watching this video... .

  • @sudiptamukherjee3123
    @sudiptamukherjee3123 3 ปีที่แล้ว

    THANK YOU SO MUCH SIR FOR SHARING SUCH A KNOWLEDGELE VEDIO ,

  • @santoshsonawane6363
    @santoshsonawane6363 4 ปีที่แล้ว +2

    Excel financial formula muje to malum hi nahi tha...,!
    Thanks sir..!

  • @varshapatel3821
    @varshapatel3821 8 หลายเดือนก่อน

    Bestest explanation ❤

  • @arjunsingh1811
    @arjunsingh1811 5 ปีที่แล้ว +1

    Good Satish ji useful information Thanks

  • @sachinvarma7878
    @sachinvarma7878 2 ปีที่แล้ว

    Best teacher ❤️

  • @kailashjoshi5871
    @kailashjoshi5871 2 ปีที่แล้ว

    Thanks sir 🙏🙏 I easily understood.

  • @k.k.mahawar8216
    @k.k.mahawar8216 5 ปีที่แล้ว +1

    बड़े काम के फंक्शन हैं।👌👌👌

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว

      Thanks a lot for watching this video....

  • @SureshKumar-ot1kc
    @SureshKumar-ot1kc 5 ปีที่แล้ว

    All are new for me. Thanks.

  • @marshalnaseer7473
    @marshalnaseer7473 2 ปีที่แล้ว

    It is really useful topic, thanks a lot

  • @pjrprasenjit3229
    @pjrprasenjit3229 3 ปีที่แล้ว

    Thank you very much sir
    Good explanation
    I am really enjoyed tis video

  • @himanshukumaryadav4697
    @himanshukumaryadav4697 2 ปีที่แล้ว +1

    Wow That's great Sir

  • @ramgore8081
    @ramgore8081 3 ปีที่แล้ว

    Sir, very simple language explained..

  • @prakashchaudhari9714
    @prakashchaudhari9714 5 ปีที่แล้ว +1

    sayad aapke jaise hamare excel trainer hote to kitna achchha hota.
    thanks sir......

    • @Learn_More_Pro
      @Learn_More_Pro  5 ปีที่แล้ว

      Thanks brother for watching this video....I hope u will share with ur frnds

  • @architpatel8856
    @architpatel8856 4 ปีที่แล้ว +1

    Nice Video, Your Work is Great

  • @chanchalsharma6409
    @chanchalsharma6409 4 ปีที่แล้ว

    🌹🌹 Thanks for teaching us 🙏🙏💐💐