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.

IT之家 1 月 27 日消息，微软昨日（1 月 26 日）发布博文， 宣布为提升云端办公的数据处理效率，网页版 Excel 现已全面支持 Power Query 功能 。这意味着用户无需依赖桌面版客户端，可以在浏览器中，直接完成复杂的数据导入与处理工作。

Excel’s Power Query is a powerful tool that enables users to transform and manage data with ease. However, to truly harness its capabilities and streamline your workflow, it’s crucial to understand ...

Merge lists even with typos and inconsistent names. Tune the similarity threshold, use a transform table, and audit results ...

PowerQuery is a powerful tool in Excel that allows you to import, clean, and analyze data from various sources. One of the key features of PowerQuery is its ability to refresh data automatically, ...

Have you ever faced the frustration of trying to combine multiple Excel files, only to realize their sheet names don’t match? It’s a common headache for anyone working with data from varied sources.

Microsoft Excel: How to use Power Query to display a list of duplicate values or records Your email has been sent Whether duplicate records are good or bad depends on specific conventions that you ...