Home Excel Functions

# Functions

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

0

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

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