Imagine this: you’re managing a sprawling Excel spreadsheet with thousands of rows of data. You need to identify high-priority tasks, flag anomalies, or categorize entries based on specific rules.

Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...

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

Microsoft released new Excel features in September 2025 for Windows, Mac, iOS, and web users, with a focus on updates to the desktop and web clients, but no new features for Android users. The primary ...

Disclosure: Our goal is to feature products and services that we think you'll find interesting and useful. If you purchase them, Entrepreneur may get a small share of the revenue from the sale from ...