Principal and Interest Calculation In Excel | Excel For Finance | Excel Videos and Tutorials
Вставка
- Опубліковано 6 лют 2021
- #ExcelforBeginners #excelbyneerajarora #msexcel
Hey guys in this video we are learning about how to use PPMT and IPMT formula in Excel.
The Excel PPMT function can be used to calculate the principal portion of a given loan payment. For example, you can use PPMT to get the principal amount of payment for the first period, the last period, or any period in between.
And IPMT function can be used to calculate the interest portion of given loan payment in a given payment period. For example, you can use IPMT to get the interest amount of payment for the first period, the last period, or any period in between.
Make sure to like and comment on this video to get more such content in the future.
Share with your friends if you believe that this video can help them.
Related video's
Excel Lecture 1 | Excel for Beginners ( हिंदी ) | Excel Tutorials By CA Neeraj Arora- • Excel Lecture 1 | Exce...
Excel Smart Sum | Excel का ये Hack आपको बनाएगा ऑफिस में सबसे Smart | Neeraj Arora- • Excel Smart Sum | Exce...
Find Blank Cells In Excel | Neeraj Arora - • Find Blank Cells In Ex...
Finding and Highlight In Excel | Excel For Beginners | Neeraj Arora- • Finding and Highlight ...
Excel Trick | Excel Smart Drag Down | Neeraj Arora - • Excel Trick | Excel Sm...
Excel Repeat Function | Magic Trick in Excel | Neeraj Arora - • Excel Repeat Function ...
About Neeraj Arora
Neeraj Arora is a renowned teacher for courses/qualifications like CA, ACCA. He is also known for imparting knowledge on Investing, Personal Finance to young minds of India. He is the co-founder of EDU91 and Fin Learn Club. His areas of teaching and studying include Auditing, Strategic Management, Income Tax, GST, Investing, Stock markets, Personal Finance, Excel, etc. He always believes in सीखना बंद तो जीतना बंद।
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/cours...
😍 Why Choose Excel Club By Neeraj Arora? 😍
✅ 50+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 350+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 3500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
All Prices Running On Discounted Prices. Limited Time Offer Expires Soon.
Related Topics
-Excel For Beginners
-MS Excel
-Excel Tutorials
-Excel Lectures
-excel for beginners in hindi
-ms excel full course in hindi
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/courses/description/Excel-Club
thanks sir
Great sir 👍👍🙏🙏🙏🙏🙏🙏
Thank you very very much sir ji
Alhamdulillah bahot mast sir...thanks a lot❤️❤️❤️❤️
Thank you Sir 🙏.. learn new lession 👍 waiting for next ❤️❤️👌🏼
Waiting for next video
Kyun sir Maja Aa Riyo Jindagi mei dhasu hi?
First comment sir
Please sir upload the pivot table lecture
Can be available simple interest calculator in excel like
Month date principal amount pri.deposite /wridhal interest balance
But interest calculator simple rate but effect of deposited or wridhal calculator in interest
Multiple person multi loan how can maintenance in excel
Make more video regarding finance.
Sir please upload a complete video on Pivot Table in detail
Sir
Please make a video on index and match function.
Sir please make a video on mail merge
Sir plz upload pivot table
Nice video sir trial balance sheet, profit and loss account and balance sheet ka excel file format with formulas ho to pls share me
Sir I want to copy the value of a1 cell in a3 cell. Is there any shortcut for that?
Late op
Hi, in my excel workbook I have 200+ sheets & sheet names defined.
Every sheet contains data like student name father name address and mob no.s
if I enter sheet name I should get all the data in that particular sheet
Sir please vlookup me sath paivad tabel ki vedio baba do please
pait table ke sath vlookup kese lagate h
Is present value means sanctioned amount??
yes
Kisi company ka exel work starting to end tk ka work ka vdo bnao or use kase send krte h kase present krte h vo btao pls sir...💫
Sir , kya ICAI MS OFFICE provide karta hai apne students ko??
if function
Or jo course h iske baare me btao thoda ki is course ko krne ke baad reaume me add kr skte h advanve exel 🙄, or cource kasa h vdos h usme ya pdf vgera.. Mera mtlb thoda smjhao sir uske bare me,or pls rply kra kro
1:23
What is the The Relation Between Excel and Girlfriends...🤣🤣🤣🤣🤣🤣🤣
Sir aap data tab bato ji
When I have calculated, result is showing in $.
Sir what is the promo code😭i could not copy some skill20 it was showing or exactly what I could not recall. 😭
Sir, You talk like carry !
EMI Calculator Excel me Weeks Bala bana ke dikhao
Kyu ki mujhe bhi pta h ki month or years ka Emi calculator bna h or mujhe Weeks me chahiye
explain why its giving you answer in red you not explain that
01:23 Girl Friend aapki student nikli to?
Haha baap chalega
Baatay jaada hai,explanation Kum hai
if you not explain properly then you are zero