Select Page

## Know Your EMI with Change in Interest Rate and Loan Amount

Goal:Today our goal is to calculate EMI (Equated Monthly Installment) with change of interest rate and loan amount Home loans in most countries are available at flexible interest rates. It means your interest rates may go down or up, based upon the market conditions....

## Difference of Two Dates with Exact Year(s), Month(s) and Day(s) in Excel

Goal:To get difference between two dates with the answer as exact year, month, and days. Simply it means, if we take two dates as 1-Jan-2009 and 2-Feb-2010, the required result (difference) will be 1 year 1 month 1 day.Algorithm:First of all we have to check whether...

## How To Delete Blank Rows In Excel Worksheet

Goal:To delete blank rows in-between used range of an excel worksheetTips to delete blank rows:If data is small and number of blank rows is less, it’s easier to delete the same However, in a scenario where data is huge and number of blank rows is in hundreds or...

## Sum of Every nth cell in Row or Column

Goal:Excel worksheet have number of rows and columns. Intersection of row and column is known as a “cell”. We insert data in these cells only. Every cell has got a row number and a column number. We have to add value of every nth cell in a row or column. In simple...

## Ordinal Number and Ordinal Date in Excel

Goal:To generate Ordinal Number and Ordinal Date in excel. An Ordinal Number is a number that tells the position of something in a list, such as 1st, 2nd, 3rd, 4th, 5th etc. An Ordinal Date denotes the position of a day in a given month and year; e.g., 8th June, 2020...