Excel Formulas and Functions
PMT function in Excel – 5 Minute Easy Guide
PMT function in excel can be easily used to get total loan payment per period assuming equal payment and constant interest rate.
Learn how to use VLOOKUP function
VLOOKUP function can be used to lookup and retrieve data from a given column referenced by a value of the first column. Learn More...
Excel obtiene el número de fila de un valor coincidente o según un criterio
Encuentre y devuelva fácilmente el número de fila de una celda de Excel con la función ROW() o la función CELL() combinada con la función MATCH() o una expresión lógica
Excel function NETWORKDAYS
You can use the NETWORKDAYS function to calculate the number of days between the start and end dates of a project, or to determine how many days are left in a certain time period.
How to use IF function in excel
Learn in how to use IF function in two minutes!. Video Lesson includes.
Excel: Get the Column Letter of a Matched Value (Formula + Builder)
Return the column letter of a matching cell with MATCH, INDEX, COLUMN and ADDRESS. Copy the ready-made formula, or build one for your own range with the free formula builder.
Excel: Return the Row Number of a Matching Value (Formula + Builder)
Get the row number of a matching cell in Excel with ROW, INDEX and MATCH. Copy the formula, or build one for your own range with the free formula builder.