Excel Formulas and Functions

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.

Learn in how to use IF function in two minutes!. Video Lesson includes.

PMT function in excel can be easily used to get total loan payment per period assuming equal payment and constant interest rate.

Easily find and return the column letter of an Excel cell with the COLUMN() function or CELL() function combined with the MATCH() function or a logical expression

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

Easily find and return the row number of an Excel cell with the ROW() function or CELL() function combined with the MATCH() function or a logical expression

VLOOKUP function can be used to lookup and retrieve data from a given column referenced by a value of the first column. Learn More...