Excel Tells You This Month’s EMI - EMIBYMONTH Formula Explained - Part 02 @ExcelExciting
Excel Tells You This Month’s EMI - EMIBYMONTH Formula Explained - Part 02  @ExcelExciting
Uploaded July 2025 | Updated November 2026, 2 days ago
In this video, I’ll show you how to automate your EMI tracker in Excel using the powerful EMIBYMONTH() formula — built with LET, LAMBDA, SEQUENCE, and REDUCE. Forget dragging formulas. With just one custom function, Excel will tell you how much EMI you’ll pay each month and when each one ends.

Whether you’re managing loans, credit cards, or planning your monthly budget, this solution is dynamic, scalable, and works on both Mac & Windows.

⏱ Time Stamp
00:00 Intro


🔍 What you’ll learn:
✔️ How to build the EMIBYMONTH() function step by step
✔️ Automate monthly EMI calculations using LET and LAMBDA
✔️ Use SEQUENCE, REDUCE, VSTACK, and BYCOL for logic and layout
✔️ Instantly see monthly totals without dragging formulas

📥 Want the Excel file? Just comment "EMI Tracker Part 2" and I’ll send it to you.
👨‍🏫 By Faraz Shaikh | Microsoft MVP | Excel Exciting
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk

📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨‍👩‍👧‍👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting

👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well


***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #Excel #EMITracker #LAMBDA #LET #PersonalFinance #FarazShaikh
Excel Tells You This Month’s EMI - EMIBYMONTH Formula Explained - Part 02Un-Stack Data classic way using Excel Online & Excel Mac | Two SolutionToday Date in Power Query (Excel & Power BI) - 2 MethodsPower Query, as voted by the community! with Fay BordbarExcel Trick# 31 – Convert Numbers to Text Using Formula   #shorts #excel #excelexcitingConvert Number to Words In Microsoft Word [mac & windows]Super Cool FILTER Excel Tip Chandeep (Goodly) with Faraz Shaikh (ExcelExciting.com)Excel Trick# 1- Calculate Age In Excel & GoogleSheets - #ShortsHow to create Actionable reports in Excel with Tine OzimicExcel with 41Million+ Records & still why UK have Data Loss of COVID-19 Cases?Excel Trick# 10 - Insert Euro € symbol on Excel for Mac - #shorts #excel #exceltips #exceltricksBuild Better Excel BI Models Faster with Ken Puls
Faraz Shaikh |

Excel Tells You This Month’s EMI - EMIBYMONTH Formula Explained - Part 02

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER