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

##
Excel Mortgage Calculator

##
FV

##
PV

##
PPMT & IPMT

##
PMT

##
HSTACK

##
VSTACK

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

February 8, 2023

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

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 HSTACK is a function that allows you to stack 2 or more arrays horizontally. An array could be a single cell, row, column, or any combination of rows and…

January 11, 2020

Explanation VSTACK is a function that allows you to stack 2 or more arrays vertically. An array could be a single cell, row, column, or any combination of rows and…

January 11, 2020