Welcome to Excel Point Nepal, your trusted platform to learn Microsoft Excel in Nepali — from the very basics to advanced Excel formulas, VBA automation, dashboards, and data analysis. In this tutorial video, we will explain how to use the PPMT and IPMT functions in Excel after learning the PMT function. If you have already used the PMT function to calculate loan installments, this video will help you go one step further by breaking down the Principal Payment (PPMT) and Interest Payment (IPMT) functions in a simple and clear way. 📌 Why this video is important for you? In the real world, many people in Nepal use Excel for loan calculation, EMI schedules, banking data, and finance-related analysis. Using PPMT and IPMT correctly will help you separate the principal portion and the interest portion of any payment. This is very useful for data analysts, accountants, finance officers, and Excel learners who want to improve their skills. This tutorial is fully presented in Nepali language, making it easier for Excel beginners in Nepal to understand complex functions without confusion. Even if you are just starting your Excel journey, or preparing for advanced Excel skills, this video will give you the right foundation. At Excel Point Nepal, we regularly create tutorials on: Excel basics to advanced in Nepali Excel formulas and functions explained step by step Excel VBA for beginners Excel dashboards, reporting, and data analysis 👉 Subscribe to Excel Point Nepal today and continue your journey towards becoming an Excel expert in Nepali! #ExcelNepal #ExcelInNepali #ExcelFormulasNepali #ExcelPointNepal #PPMT #IPMT #PMTFunction Join this channel to get access to perks: https://www.youtube.com/channel/UCDJ2sYjsbBH68N2qd6li-fA/join Get more details: https://excelpointnepal.com/ #excelwithmenepal #excelpointnepal #excel #office #ExcelNepal #ExcelNepali YouTube Playlist: Excel for Beginners: https://www.youtube.com/watch?v=XU78GaRK3h8&list=PL_cRVuVYLWF3kT_YlUwuMewbkfJxYp-Sb Power BI for Beginners: https://www.youtube.com/playlist?list=PL_cRVuVYLWF2xkdv6oh-VRN-rZ8UX8Zro Power Query editor for beginners: https://www.youtube.com/playlist?list=PL_cRVuVYLWF1VxJZ6xtySGQKiT1Zm2Fav Excel VBA for Beginners: https://www.youtube.com/watch?v=FvlLVqx5gq0&list=PL_cRVuVYLWF2HnDtQeLOw0bWKD0IvL_tY Excel Functions: https://www.youtube.com/watch?v=LcIzRoxzpBA&list=PL_cRVuVYLWF1gq9rDR5hoMsSzT-BxwMJe Pivot Table & Charts: https://www.youtube.com/watch?v=FMsQfGCEsWA&list=PL_cRVuVYLWF1SxYijrr2U4iR8vmSYurLm Date & Time: https://www.youtube.com/watch?v=tQ8RKlYHMd4&list=PL_cRVuVYLWF2_pgTnxftEYRnsWWlJqUEJ Tricks & Tips https://www.youtube.com/watch?v=8rWGV44Ubhc&list=PL_cRVuVYLWF1VcqdGxVTpo73yp83LnAVs&pp=gAQB Your Comments My Reply: https://www.youtube.com/watch?v=-l3ZULLyYJ8&list=PL_cRVuVYLWF22tSs-GBgxoXv_2okSDl8u&pp=gAQB Short Videos https://www.youtube.com/watch?v=6rufV7J48D8&list=PL_cRVuVYLWF0twjXyQ6nf1XY-rCroA1VF&pp=gAQB Read more: https://excelpointnepal.com/how-to-convert-pdf-file-into-excel/ https://excelpointnepal.com/advanced-excel-training/ https://excelpointnepal.com/power-query-editor-for-beginners/ https://excelpointnepal.com/online-excel-training-in-nepal/ https://excelpointnepal.com/sumproduct-function/ https://excelpointnepal.com/number-to-words-in-excel/ https://excelpointnepal.com/excel-data-cleaning-visualization-course/ https://excelpointnepal.com/keyboard-shortcuts-for-excel/ Download important Excel files step 1 https://www.youtube.com/c/excelwithmenepal?sub_confirmation=1 step 2 https://drive.google.com/drive/folders/1lehFZynEUPLLiA9ajWwjTyrBYZiy5z2o?usp=sharing follow us Tiktok: https://www.tiktok.com/@excelpointnepal Facebook Page: https://www.facebook.com/excelpointnepal Instagram: https://www.instagram.com/excelpointnepal/ Telegram: https://t.me/excelpointnepal WhatsApp Community: https://chat.whatsapp.com/Lk3MbhZGTdsEJF0muIw3Dl Viber Community: Join Excel Point Nepal https://invite.viber.com/?g2=AQAZjpr9S%2FAxI1H28cQJ9tmnioWqfJxpnmEunvgu7T4WYJ0KaJPRK7mV9eSFKykS on Viber Google review: https://g.page/r/CX2XeswYNsXuEAI/review Facebook page: https://www.facebook.com/excelpointnepal/reviews Website: https://excelpointnepal.com/