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

Microsoft's Excel development team announced on Friday, December 4, 2020 that the beta version of LAMBDA, which allows you to define your own custom functions using Excel's formal language, has ...

The Excel ASIN function returns the arcsine or inverse of a number. In this tutorial, we will explain how to use the ASIN function in Excel.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how ...

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

How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y. By calculating a function at a ...

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...