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

[@Excel_Tutorial]

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

[@dadramobilehub7119]

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

[@RAEES_Kaushar]

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

[@AmKing_of_curses]

Sahi hai

[@rishabhdube714]

Ha bhai

[@Ar_Rehan985]

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

[@poojakajla5032]

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]

You're welcome 😊

[@gopinathwarade5185]

Very important knowledge and best teaching

[@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]

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

[@dance4you701]

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

[@ejazhaq1160]

Satish bhai Bohat bhaddiya, jeety rahiye aap

[@rmjoshi51]

Very nicely explained

[@GagandeepSinghCF]

Good Job. useful information

[@BankerWriterMosharaf]

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

[@vijaycreation6127]

Thanks sir

[@user-gj5ot8ww8q]

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

[@Excel_Tutorial]

Please keep watching the new videos that I am uploading.

[@kashtiarora4603]

Thanks

[@MOTOVLOGJB]

good info welldone

[@arjunmohod6886]

Great vdo Satish sir maja aali khuppp chhan as usual❤

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@Talk_verse]

Useful 😊😊 1st comment in 30 sec

[@VivekKumar-il7ux]

Nice sir ji ❤🎉❤🎉🎉🎉

[@yhharishadyar7843]

Good video sir

[@abodisom_official]

Nice video 👌

[@dimple10sharma]

very nice sir, easily samj a gya...

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@Abdul_Qadoos_Wazir]

Like your way of teaching ❤❤❤

[@Excel_Tutorial]

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

[@goodman-it2qy]

Nice

[@articfox5636]

Sir continue the formul series please
For data science

[@estatezo]

Thank you

[@Excel_Tutorial]

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

[@rackuptechnical8484]

VERY NICE SIR

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@mubashirrehmanmubashirrehman]

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

[@irfanshaikh5577]

Please make a video on AWS

[@mayur6167]

100%❤like

[@shivarajhugar8915]

Very nice and excellent teaching method ❤

[@Excel_Tutorial]

Keep watching

[@smitasomulwar693]

Nice vidio

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@sriprakashrai8395]

Vety good

[@Excel_Tutorial]

Keep watching the new videos I am uploading.(th-cam.com/video/3aanQhWeUTo/w-d-xo.html)

[@akstarnonmusic8008]

Sir love u yar

[@Excel_Tutorial]

Keep watching

[@ramakantyadav8914]

Wow

[@prashantthakur9947]

RD intrest calculation explain

[@anilchoudhary2610]

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

[@bhaveshb5883]

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

[@bps7557]

Sir, how about adding moratorium period.

[@anjalipatil1667]

Sir apka mis report video mil sakat hai kya

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

[@vishnuvamshi4645]

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😢

[@singhdeepaknibi]

Weekly emi ka formula mil skta hai kya sir

[@earnmoney7651]

Love from 🇳🇵🇳🇵🇳🇵🇳🇵

[@Excel_Tutorial]

Keep watching the new videos I am uploading.(th-cam.com/video/3aanQhWeUTo/w-d-xo.html)

[@HarshvardhanSoni-l9x]

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

[@Maanvisible100]

Next part. Kro bhai

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@notificationjob5997]

Sr freelance ki video lekar aayo ji work kse krte hai

[@atish_razz0101]

Good sir bank 🏦 lone ki jkari di

[@rajababurajababu5572]

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

[@artistnir7738]

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

[@puneet9710]

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.

[@yolnsghf]

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

[@AJAYSONKAMBLE-wr9ti]

Sir divasavar kadun dhakhva interest aani mahinyavar

[@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 😢

[@GK.chaleng.for.]

Sir practice sheet per formula nahi hai

[@devgiri4980]

🎉

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@arunkumar4u]

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

[@Mishi_k2023]

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

[@farjanamashrafe]

🇧🇩❤️

[@rudrapratap-jb7ji]

Default EMI kaise calculate karte Hain

[@sharmadigitech7984]

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

[@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]

Or mere pc me hamesha $ ka symbol hi aata hai

[@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]

Thank you 😀

[@sonuyt4896]

5:38

[@Vachanpatel]

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]

What is your rate of interest?

[@AmKing_of_curses]

Bwst teacher India

[@Excel_Tutorial]

Keep watching the new videos I am uploading.(th-cam.com/video/3aanQhWeUTo/w-d-xo.html)

[@tulasimaharana2948]

Error aarahahe kya karu

[@Hello_Youth]

Sir cell fix nahi ho raha hai😅

[@Hello_Youth]

Maine f4 click ki thi phir bhi nahi hua sir

[@roshnishetty6979]

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

[@PrinceKumar-uq2fh]

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

[@arungayakvad5891]

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

[@kuldipbalmiki3774]

Kaam ki baat Jada bola kre or faltu ki baat kam

[@INDIANBHAKTISONG]

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

[@sameerraaw007]

😂😂😂😂

[@india3089]

Thanks sir

[@RiteshPednekar-he3zc]

Wow

[@Excel_Tutorial]

You're welcome 😊

[@SayyidaMehnaz]

Thank you sir