Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Replace repetitive copy-paste work by automatically combining, joining, and importing data directly inside Excel.

Editor’s note: “Behind the News” is the product of Sun staff assisted by the Sun’s AI lab, which includes a variety of tools such as Anthropic’s Claude, Perplexity AI, Google Gemini and ChatGPT. The ...

Here we will go through how Excel is structured, where you will find important and smart functions, and various peculiarities you should know. In short, we’ll show you how to make the program work for ...

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

The new ‘COPILOT’ function uses AI to generate summaries, tags, tables, and more based on a group of cells. The new ‘COPILOT’ function uses AI to generate summaries, tags, tables, and more based on a ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

Microsoft has introduced a powerful new function in its Excel spreadsheet application, allowing users to simplify their workflows by reducing the need for complex formulas. Excel’s latest beta version ...