Functions

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

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.

DSUM Function

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

EXACT Function

0
The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If...

TODAY Function

0
Learn to use the TODAY function in Excel.

NOW Function

0
Learn to use the NOW Function in Excel

NETWORKDAYS Function

0
The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically excludes weekends...

DATEDIF Function

0
The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A common error...

Latest Tutorials