In this video, you will learn how to create a Loan EMI Calculator in Microsoft Excel. We have explained step by step how to create –
1) Input Table
2) EMI Calculation Table
3) Small Pie chart to show to % share of Principle Amount and Interest
4) EMI repayment table
5) Dynamic Print Area setup with INDIRECT Function

Download the practice file from below link:
https://www.pk-anexcelexpert.com/excel-loan-emi-calculator-free-template-for-easy-amortization/

Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
https://youtu.be/dxmG5BRJgVQ

Learn Step by Step Pivot table:
https://www.pk-anexcelexpert.com/pivot-table/

Download the Free Project Management Dashboard
https://www.pk-anexcelexpert.com/excel-dashboard/project-management-dashboard

See our Power BI Dashboard videos:
https://youtube.com/playlist?list=PLbDvAYjpWJ7B3SA-3euReObYM9St5lt5b

Learn and download our interactive Excel dashboards free of cost-
https://youtube.com/playlist?list=PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF

Download the Calendar Control in VBA from below link
https://www.pk-anexcelexpert.com/fully-functional-dynamic-calendar-control-in-vba/

Download our free Excel utility Tool and improve your productivity:
https://www.pk-anexcelexpert.com/pks-utility-tool-v3-0-free

See our Excel Products:
https://www.pk-anexcelexpert.com/products/

Visit to learn more:
Chart and Visualizations: https://www.pk-anexcelexpert.com/category/blogs/charts-and-visualization/
VBA Course: https://www.pk-anexcelexpert.com/vba/
Download useful Templates: https://www.pk-anexcelexpert.com/category/templates/
Dashboards: https://www.pk-anexcelexpert.com/excel-dashboard/

Watch the best info-graphics and dynamic charts from below link:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CEAHn-iuGSeLbUtFnYekHr

Learn and free download best excel Dashboard template:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF

Learn Step by Step VBA:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH

Website:
https://WWW.PK-AnExcelExpert.com

Facebook:
https://www.facebook.com/PKAnExcelExpert

Telegram:
https://t.me/joinchat/AAAAAE2OnviiEk5o1o8i4w

Pinterest:
https://www.pinterest.com/PKAnExcelExpert/

LinkedIn:
https://www.linkedin.com/company/pk-anexcelexpert

Twitter:
https://twitter.com/priyendra_kumar

Instagram:
https://www.instagram.com/pkanexcelexpert

Visit our Amazon Store
https://www.amazon.in/shop/pkanexcelexpert

Please take the opportunity to connect and share this video with your friends and family if you find it useful.