Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

Over the past two years, I have noticed that when I teach students about any issue in the U.S. or around the world, they express noticeable apathy and disinterest. When our current president was ...

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

Microsoft is introducing Agent Mode in Excel, part of its new approach to “vibe working,” where Copilot can analyze data, generate visualizations, and iterate on results through multi-step tasks.

AI Microsoft CEO Satya Nadella says it's time to stop talking about AI 'slop' and start talking about a 'theory of the mind that accounts for humans being equipped with these new cognitive amplifier ...

TL;DR: Microsoft is launching Copilot AI for Excel, a new feature that uses advanced language models to help users analyze data, summarize information, and generate ideas directly in their ...

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

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...