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.
Have you ever spent hours wrestling with messy spreadsheets, trying to clean up data that just won’t cooperate? Or maybe you’ve found yourself manually merging files, painstakingly copying and pasting ...
A super easy way to generate new records from multi-value columns using Excel Power Query Your email has been sent Have a complex Excel problem? Power Query to the rescue! Analyzing data often means ...
Once data is loaded into Excel, Copilot allows users to ask questions in natural language instead of building new formulas.
How-To Geek on MSN
5 everyday actions that Power Query does better than regular Excel tools
Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.
When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.
Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results