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