Home Excel Functions

Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

VLOOKUP Function in Excel

0
Comprehensive VLOOKUP glossary with downloadable examples.

AVERAGEIF Function

0
AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while...

Using INDEX and Match Functions Together

0
Using INDEX and Match Functions together – Alternative to VLOOKUP Before reading this tutorial, please make sure you understand...

SUMIF Function

0
The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators...

AverageIFS Function

0
Finding the arithmetic mean in Excel is very easy.  In this example, we will be using the AVERAGEIFS function. We will be finding...

Average Function

0
AVERAGE (Arithmetic Mean) Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up a list of numbers and...

Autosum Function

0
Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just about...

PMT Function

0
The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula...
ROUNDUP Function

ROUNDUP Function

0
The ROUNDUP function in Excel rounds numbers up a specified decimal place. This function rounds up all of the numbers.

INDEX Function

0
INDEX Function in Excel The Index Function in Excel returns the value of an array given a specific row...

Latest Tutorials

PPMT-Function

PPMT Function

NPER Function

NPER Function