Home Excel Functions

Functions

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

DAY Function in Excel

0
Learn to use the DAY Function in Excel.

VLOOKUP Function in Excel

0
Comprehensive VLOOKUP glossary with downloadable examples.

CONCATENATE Function

0
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

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

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

RANDBETWEEN Function

0
You can use Randbetween random Number Generation for a number or purposes in Excel. The Excel RANDBETWEEN function returns a random integer...

SUMPRODUCT Function

0
The SUMPRODUCT function in Excel is a useful tool when you are working with large data sets or multiple arrays.  An array...

Autosum Function

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

DSUM Function

0
The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.

HOUR Function in Excel

0
What time is it? The HOUR Function can grab, you guessed it, the HOUR!

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Calculate Work Days in Excel

Sum if between