Excel Blog
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...
Understanding Excel Formula
The real strength of Excel is its calculation power. An excel worksheet without any calculation can also be created in an MS Word (.doc or .docx) file. This post will help to understand excel formulas, from simple calculations to advanced ones, with nested built-in...