You must know Excel formula to calculate loan EMI | PMT,PPMT,IPMT Formulas in Excel

You must know Excel formula to calculate loan EMI | PMT,PPMT,IPMT Formulas in Excel
In this video, you will learn about how to calculate Emi using Excel financial functions(PMT,PPMT,IPMT). So watch video till the end & share with your friends & family.
- To get Practice file Download our app : bit.ly/3BWfQVa
- Most useful Excel formulas playlist : • Excel useful formula S...
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
#MsExcel
#Financialfunctionsinexcel
#exceltricks
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course 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/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My KZread 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

Пікірлер: 103

  • @Excel_Tutorial
    @Excel_Tutorial17 күн бұрын

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

  • @IR5UM

    @IR5UM

    11 күн бұрын

    Sir ji excel mai 20 sal ki byaj or chkrvrti byaj ke liye kaise krte hai😢 Plz btane ki kripa kre

  • @dadramobilehub7119
    @dadramobilehub71192 ай бұрын

    Ehna asha to hume course krte time kisi ne nhi samjaya jitna app samjate ho really app bohut ache teacher ho

  • @RAEES_Kaushar
    @RAEES_Kaushar9 ай бұрын

    Life me sabse aacha koi hame pahli bar koi sahi padhaya hai❤❤❤

  • @AmKing_of_curses

    @AmKing_of_curses

    7 ай бұрын

    Sahi hai

  • @rishabhdube714

    @rishabhdube714

    Ай бұрын

    Ha bhai

  • @Ar_Rehan985
    @Ar_Rehan98511 ай бұрын

    Jis cheez ka confusion main tha uska aap salutation kar diye, you are a great, sir ❤

  • @poojakajla5032
    @poojakajla50322 ай бұрын

    Bahot acha padte h sir ji Mene complete Excel aapki vedieo dekh dekh k sikha h sir thank you much sir ji aap bahot badhiya explain kre h

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    You're welcome 😊

  • @roshanipadghan1710
    @roshanipadghan1710Ай бұрын

    Sir I am proudup you sir apke jaese techer school me mile hote to aaj boht kuch seekh jati sir keep it up

  • @RameshFunnyreact
    @RameshFunnyreact Жыл бұрын

    बहुत बहुत धन्यवाद महाशय ❤

  • @dance4you701
    @dance4you701 Жыл бұрын

    Mast jabardast aj se pehle mai samjh hii nhi ai thi ❤❤❤❤

  • @gopinathwarade5185
    @gopinathwarade518511 ай бұрын

    Very important knowledge and best teaching

  • @ejazhaq1160
    @ejazhaq1160 Жыл бұрын

    Satish bhai Bohat bhaddiya, jeety rahiye aap

  • @rmjoshi51
    @rmjoshi51 Жыл бұрын

    Very nicely explained

  • @GagandeepSinghCF
    @GagandeepSinghCF Жыл бұрын

    Good Job. useful information

  • @BankerWriterMosharaf
    @BankerWriterMosharaf Жыл бұрын

    You are really a blessing for online learners.......God bless you.

  • @Talk_verse
    @Talk_verse Жыл бұрын

    Useful 😊😊 1st comment in 30 sec

  • @user-gj5ot8ww8q
    @user-gj5ot8ww8qАй бұрын

    धन्यवाद धन्यवाद धन्यवाद 💐

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Please keep watching the new videos that I am uploading.

  • @arjunmohod6886
    @arjunmohod6886 Жыл бұрын

    Great vdo Satish sir maja aali khuppp chhan as usual❤

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    Keep watching the new videos I am uploading.

  • @SayyidaMehnaz
    @SayyidaMehnaz10 ай бұрын

    Thank you sir

  • @MOTOVLOGJB
    @MOTOVLOGJB Жыл бұрын

    good info welldone

  • @yhharishadyar7843
    @yhharishadyar7843 Жыл бұрын

    Good video sir

  • @kashtiarora4603
    @kashtiarora46039 ай бұрын

    Thanks

  • @VivekKumar-il7ux
    @VivekKumar-il7ux8 ай бұрын

    Nice sir ji ❤🎉❤🎉🎉🎉

  • @abodisom_official
    @abodisom_official7 ай бұрын

    Nice video 👌

  • @dimple10sharma
    @dimple10sharma Жыл бұрын

    very nice sir, easily samj a gya...

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    Keep watching the new videos I am uploading.

  • @goodman-it2qy
    @goodman-it2qy Жыл бұрын

    Nice

  • @articfox5636
    @articfox5636 Жыл бұрын

    Sir continue the formul series please For data science

  • @Abdul_Qadoos_Wazir
    @Abdul_Qadoos_Wazir4 ай бұрын

    Like your way of teaching ❤❤❤

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thank you! 😃, Keep watching the new videos I am uploading.

  • @ramakantyadav8914
    @ramakantyadav8914 Жыл бұрын

    Wow

  • @mayur6167
    @mayur6167 Жыл бұрын

    100%❤like

  • @DunyahainSabChaltaHain
    @DunyahainSabChaltaHain Жыл бұрын

    If i have 2 different sheets with so many data and want to compare both sheets customer amount to find difference in amount. Now i use pivot table on both sheets which provide sum of amount of each customer then paste on new sheet and minus both pivot table data tu find difference. Is any easy way to sum both sheets data and then find difference. kindly guide

  • @anilchoudhary2610
    @anilchoudhary261021 күн бұрын

    sir aapse request hai as a HRM ko excel me kya kya aana cahiye es par ek video bna dijiye please sir ji

  • @shivarajhugar8915
    @shivarajhugar89155 ай бұрын

    Very nice and excellent teaching method ❤

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    Keep watching

  • @rackuptechnical
    @rackuptechnical4 ай бұрын

    VERY NICE SIR

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching the new videos I am uploading.

  • @estatezo
    @estatezo6 ай бұрын

    Thank you

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    You're welcome, Keep watching the new videos I am uploading.

  • @bhaveshb5883
    @bhaveshb5883 Жыл бұрын

    Floting interest rate calculate karne ka esa Excel tutorial banao...

  • @irfanshaikh5577
    @irfanshaikh5577 Жыл бұрын

    Please make a video on AWS

  • @sriprakashrai8395
    @sriprakashrai83958 ай бұрын

    Vety good

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching the new videos I am uploading.(kzread.info/dash/bejne/ZZWV0LOhh8i7hNI.html)

  • @smitasomulwar693
    @smitasomulwar6936 ай бұрын

    Nice vidio

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @akstarnonmusic8008
    @akstarnonmusic8008 Жыл бұрын

    Sir love u yar

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    Keep watching

  • @rishabmittal6372
    @rishabmittal6372 Жыл бұрын

    Sir Jo Bank ki emi hai or es formula se jo emi bni hai usme khafi difference hai kya bank wale kisi or way se emi calculate krte hai ??

  • @anjalipatil1667
    @anjalipatil1667 Жыл бұрын

    Sir apka mis report video mil sakat hai kya

  • @notificationjob5997
    @notificationjob5997 Жыл бұрын

    Sr freelance ki video lekar aayo ji work kse krte hai

  • @bps7557
    @bps755710 ай бұрын

    Sir, how about adding moratorium period.

  • @puneet9710
    @puneet97108 ай бұрын

    1. Anita purchased a new sound system that was selling at Rs. 2,94,000. She agreed to make a down payment of Rs. 70,000 and to pay the remaining amount in 24 months with an interest of 17%p.a. compounded monthly. Find EMI. Also prepare loan amortization table.

  • @prashantthakur9947
    @prashantthakur994727 күн бұрын

    RD intrest calculation explain

  • @singhdeepaknibi
    @singhdeepaknibi2 ай бұрын

    Weekly emi ka formula mil skta hai kya sir

  • @artistnir7738
    @artistnir7738 Жыл бұрын

    5.38 सेकंड पर सर की जुबान 3 पर फिसल गई 😅

  • @manojmishra5052
    @manojmishra505215 күн бұрын

    Sir outstanding balnce kaise ayega

  • @rajababurajababu5572
    @rajababurajababu557210 ай бұрын

    Sir aapke Application के video chalte नहीं हैं. क्योंकि मैंने Excelgpt course purchase kiya tha कोई भी video नहीं चला हैं मैं आपका Computer hardware course लेना चाहता हूँ but वीडियो कैसे चलेगा वो बता दो sir

  • @atish_razz0101
    @atish_razz0101 Жыл бұрын

    Good sir bank 🏦 lone ki jkari di

  • @devgiri4980
    @devgiri49803 ай бұрын

    🎉

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @varshapatel3821
    @varshapatel38217 күн бұрын

    hello sir how to apply same formula if payment is weekly and period is 18 months. i tried it

  • @earnmoney7651
    @earnmoney76517 ай бұрын

    Love from 🇳🇵🇳🇵🇳🇵🇳🇵

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching the new videos I am uploading.(kzread.info/dash/bejne/ZZWV0LOhh8i7hNI.html)

  • @Maanvisible100
    @Maanvisible1003 ай бұрын

    Next part. Kro bhai

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching the new videos I am uploading.

  • @vishnuvamshi4645
    @vishnuvamshi46453 ай бұрын

    Can u create a excel sheet for this case:- I have a loan of ₹6Lac and earning salary ₹15k with every year of increment ₹3k and from that deduction for month ₹6k and the rest is used for clearing loan payment then how many years it took to clear the loan???? (Note:- 1). time period is not fixed 2). Need to add increment every year then how to create excel sheet in this case?) Please reply😢

  • @HarshvardhanSoni-l9x
    @HarshvardhanSoni-l9xАй бұрын

    how to manage data in excel if person does advance payments in loan amount?

  • @farjanamashrafe
    @farjanamashrafe Жыл бұрын

    🇧🇩❤️

  • @Mishi_k2023
    @Mishi_k20235 ай бұрын

    Sir rate to divided 12 kyun karen ge??? Waja???

  • @AJAYSONKAMBLE-wr9ti
    @AJAYSONKAMBLE-wr9ti2 ай бұрын

    Sir divasavar kadun dhakhva interest aani mahinyavar

  • @sonuyt4896
    @sonuyt4896 Жыл бұрын

    5:38

  • @arunkumar4u
    @arunkumar4u11 ай бұрын

    Sach bolun mere bhaiya clerk exam diya tha aur unko ghata aata tha excel pe use karna.

  • @GK.chaleng.for.
    @GK.chaleng.for. Жыл бұрын

    Sir practice sheet per formula nahi hai

  • @rudrapratap-jb7ji
    @rudrapratap-jb7ji9 ай бұрын

    Default EMI kaise calculate karte Hain

  • @yolnsghf
    @yolnsghf Жыл бұрын

    11:58 pe formula copy paste kaise Kiya one cell to another.Please tell 🙏🙏

  • @RiteshKumar-bh4ki
    @RiteshKumar-bh4ki Жыл бұрын

    Sir make one about xlookup sir I know how to use xlookup but I am not getting the answer value how to fix the xlookup 😢

  • @gautamkumar12b57
    @gautamkumar12b57 Жыл бұрын

    Sir aap jaise koi pmt ka for lagate ho or jab multiply karte aapka answer ₹ ke sybol ke sath aata hai but mere pc me mujhe manually karna padta hai sir please is problem ka solution bata do 🙏🏻

  • @gautamkumar12b57

    @gautamkumar12b57

    Жыл бұрын

    Or mere pc me hamesha $ ka symbol hi aata hai

  • @sharmadigitech7984
    @sharmadigitech7984 Жыл бұрын

    If every month emi amount is changed like 1. 11500. 2. 11480

  • @sudhirsamueltoppo7576
    @sudhirsamueltoppo7576 Жыл бұрын

    3:25 ...paanch arguments, Haath may ungalee paanch, Pandav Paanch, Daddy EK.. bolna paanch nahi..😂😂😂😂 ..Satish sir aapka comedy bahut mazedaar hai...😊

  • @Excel_Tutorial

    @Excel_Tutorial

    Жыл бұрын

    Thank you 😀

  • @tulasimaharana2948
    @tulasimaharana2948 Жыл бұрын

    Error aarahahe kya karu

  • @AmKing_of_curses
    @AmKing_of_curses7 ай бұрын

    Bwst teacher India

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching the new videos I am uploading.(kzread.info/dash/bejne/ZZWV0LOhh8i7hNI.html)

  • @Hello_Youth
    @Hello_Youth Жыл бұрын

    Sir cell fix nahi ho raha hai😅

  • @Vachanpatel
    @Vachanpatel7 ай бұрын

    I got a loan of 15.00lakhs rupees and i have to start paying emi after 3 years of getting loan in next 6 years hot to calculate emi

  • @nawedr586

    @nawedr586

    29 күн бұрын

    What is your rate of interest?

  • @roshnishetty6979
    @roshnishetty69798 ай бұрын

    Don't do full zoom😢 I didn't getting anything 😢

  • @PrinceKumar-uq2fh

    @PrinceKumar-uq2fh

    3 ай бұрын

    I didn't get anytime hota hai 😊❤ grammatical mistake tha

  • @arungayakvad5891
    @arungayakvad589110 ай бұрын

    Bich me topic bas bataya Karo sir ye app ya comment Karo Aisa mat kiya karo

  • @kuldipbalmiki3774
    @kuldipbalmiki37744 ай бұрын

    Kaam ki baat Jada bola kre or faltu ki baat kam

  • @5gCatfunnyDance

    @5gCatfunnyDance

    Ай бұрын

    तुमको वीडियो देखना है तो देखो इसी तरह अच्छा लगता है सर का क्लास ,एसी comment मत करो

  • @sameerraaw007

    @sameerraaw007

    Ай бұрын

    😂😂😂😂

  • @india3089
    @india3089 Жыл бұрын

    Thanks sir

  • @RiteshPednekar-he3zc
    @RiteshPednekar-he3zc2 ай бұрын

    Wow

  • @Excel_Tutorial

    @Excel_Tutorial

    2 ай бұрын

    You're welcome 😊

  • @Hello_Youth
    @Hello_Youth Жыл бұрын

    Maine f4 click ki thi phir bhi nahi hua sir

  • @vijaycreation6127
    @vijaycreation612710 ай бұрын

    Thanks sir

Келесі