Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER () and TEXTBEFORE () in this tutorial.

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function ...

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.

In Microsoft Excel, there are over 50 + Financial functions available. When you enter a financial function or insert one, you will see the syntax of the function.

Learn how to use N function in Excel, which is an Information function that returns information about the current operating environment.

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.

Avoid misleading results in Excel! Learn the pitfalls of the Percent Of function and how to replace it with precise ...

At the Build 2018 developer conference that's taking place these days in Seattle, USA, Microsoft announced support for custom JavaScript functions in Excel.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.