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.

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.

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

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...

Right now, I'm working off one of Microsoft's infamous giant press releases. The company has a tendency to do brain dumps in press release form, so we both have to sift through the release to give you ...

For $20 a month, Microsoft's Copilot Pro is designed to seamlessly integrate with Microsoft 365, providing AI-powered features across various applications in the suite. If you're an Excel user, ...