If you have any questions or need assistance, feel free to reach out to us.

Get Your 1-Hour Free Support Session Now!

Excel Formulas and Functions

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.

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.

How to get Excel column letter from match

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

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

How to return row number of a matching cell

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

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