Learn how to use the DAYS Function in Excel.
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.
Learn how to use the TEXT Function in Excel.
The SUMPRODUCT function in Excel is a useful tool when you are working with large data sets or multiple arrays. An array...
The MMULT function in Excel is used for matrix multiplication.
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!
HLOOKUP Function Glossary What is HLOOKUP?HLOOKUP ExampleExact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook or...
Learn to use the DAY Function in Excel.
Learn to use the ABS Function in Excel.
Learn to use the INDIRECT Function in Excel.