CONCATENATE Function Explanation The CONCATENATE function in Excel allows us to merge text from multiple cells into one cell. This can be useful for creating a single, combined string of…

FORMULATEXT Function Explanation The FORMULATEXT function in Excel allows us to display the formula of a cell as text. This can be useful for showing the underlying calculations of a…

Explanation HLOOKUP  is a powerful Excel function used to search for a value in a table or a range by matching it with data in a row. HLOOKUP is very…

Below is a mortgage calculator which can be used to calculate the monthly payment, and see the payment schedule based on the data provided. Once the results are generated based…

Function Explained FV function is used for the calculation of the Future Value of a loan or any other financial instrument. Example The bank agreed to give you a loan…

Function Explained PV function is used for the calculation of the present value of a loan. Syntax The PV arguments are as follows: Rate – That’s our interest rate.  Nper…

Function Explained PPMT and IPMT are both financial functions that can help us find the Principal and Interest amount of a certain payment.  PPMT function helps to calculate the Principal…

Function Explained PMT function is used to calculate the amount to be paid in each period on a loan or other financial instrument, such as bonds. Syntax =PMT(rate,nper,pv,[fv],[type]) rate -…

Explanation TOCOL takes a range/array and converts it into a single column. Example Syntax =TOCOL(array, [ignore], [scan_by_column]) array - The range/array of cells we want to convert into a single…