The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

In Microsoft Excel, the IMPRODUCT function is an Engineering function; its purpose is to return the product of 1 to 255 complex numbers.

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

The best new tool from Microsoft Excel is undoubtedly the SCAN function. Here's how to use it to calculate running totals. Find the full guide at Spreadsheet Point.