Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.

This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...

Launch Microsoft Excel Create a table or use an existing table from your files Place the formula into the cell you want to see the result Press the Enter Key Launch Microsoft Excel. Create a table or ...

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. One of the ...

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

Have you ever found yourself staring at an Excel spreadsheet, trying to figure out how to make sense of all the numbers and data? Maybe you’ve spent hours manually calculating groups, splitting dates, ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

How to create a sorted unique list in an Excel spreadsheet Your email has been sent Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE ...

As you create Excel spreadsheets for your small business, time and date functions frequently add both convenience and programming capability to your workbooks. There's good news with date functions.

Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex ...