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

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

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

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 REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel for the web.

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.

How to Use the Countif & Countifs Functions in Excel. Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

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.

Excel custom functions can also be created as Excel add-ins so that they are available for use in all workbooks. To create a function, open a new Excel workbook and create a small worksheet as shown ...