Functions

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

DAYS Function in Excel

0
Learn how to use the DAYS Function in Excel.

CONCATENATE Function

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

TEXT Function in Excel

0
Learn how to use the TEXT Function in Excel.

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

MMULT Function

0
The MMULT function in Excel is used for matrix multiplication.

XLOOKUP Function in Excel

0
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!

HLOOKUP Function in Excel

0
HLOOKUP Function Glossary What is HLOOKUP?HLOOKUP ExampleExact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook or...

DAY Function in Excel

0
Learn to use the DAY Function in Excel.

ABS Function

0
Learn to use the ABS Function in Excel.

INDIRECT Function

0
Learn to use the INDIRECT Function in Excel.

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Sum if between