## Concatenate

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

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…

## Excel Online Cheat Sheet

Excel Online Cheat Sheet - A Quick Guide To Excel's Web Version In this post, we cover Excel Online's main features.  Looking for excel shortcuts? See our Excel Shortcuts Page!  …

## HLOOKUP

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…

## Excel Mortgage Calculator

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…

## FV

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…

## PV

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…

## PPMT & IPMT

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…

## PMT

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 -…

## TOCOL

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…

End of content