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

Skip to content
## Practice And Learn Excel Online For Free

##
Concatenate

##
FORMULATEXT Function

##
Excel Online Cheat Sheet

##
HLOOKUP

##
Excel Mortgage Calculator

##
FV

##
PV

##
PPMT & IPMT

##
PMT

##
TOCOL

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…

0 Comments

November 21, 2019

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…

February 8, 2023

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

July 30, 2022

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…

April 15, 2023

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…

January 12, 2020

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…

January 11, 2020

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…

January 12, 2020

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…

January 12, 2020

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

January 12, 2020

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…

January 11, 2020