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

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

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

As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.

Few things frustrate us more than the inability to crack an Excel task independently. We love formulas and conditional cells, but the best way to utilize these features isn’t always easy. Tap or click ...

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

We test Claude in Excel, a beta version add-in requiring a paid plan, and show where it saves time on formula fixes.

Please note: This item is from our archives and was published in 2021. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Can you show me how ...