I traded the static results of Flash Fill for dynamic formulas that update automatically.

Microsoft’s January 2026 update puts Excel back in the spotlight. After a brief pause late last year, the company has resumed its monthly feature recap, and thi ...

Once data is loaded into Excel, Copilot allows users to ask questions in natural language instead of building new formulas.

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Microsoft updates for Excel in January 2026 introduce Agent Mode with Copilot, new import tools, clearer error messages, Power Query on Mac and Web, and Office Scripts automation to ease daily tasks.

What if I told you that the tools you’ve relied on for years, VLOOKUP and XLOOKUP, might actually be holding you back? Sure, they’ve been the go-to formulas for countless Excel users, but as datasets ...