Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Open an Excel workbook on your PC. You can now close the VBA window and go back to your Excel sheet. Pick a cell, type ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

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 announced that the XLOOKUP function in Excel, meant to supersede both HLOOKUP and VLOOKUP, is now generally available to Office 365 customers after months of testing with Insiders.

Microsoft Excel was first released in 1987 and — despite popular competitors such as Google Sheets — is still used by millions of businesses throughout the world. Described as the “world’s most ...

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.

The Excel Today function is simple to use and works with virtually all versions of Excel. You can manually enter the Today function or you can choose it from the Formulas tab on the Ribbon.

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