SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a ...

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

How to Use the New Excel SCAN Function Excel’s SCAN function has transformed data processing by allowing calculations across data sets without explicit cell references.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

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.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.