From Agent Mode to Power Query: Microsoft Details New Excel Features Rolled Out in January 2026

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

Record tasks in Excel with Automate

Q. I noticed there is a new tab in my Excel 365 called Automate. What does this do? A. There is an Automate tab available in Microsoft 365, Excel for Microsoft 365 for Mac, and Excel for the web. The ...
How-To Geek on MSN

VBA is dying, and Microsoft is building Excel's future without it

Cloud collaboration, macro security, and new tools like Office Scripts, Power Query, and Python are pushing VBA to the ...
Analytics Insight

Microsoft’s January Excel Update Brings Copilot, Automation, & Power Query

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

How ChatGPT is Changing the Game for Excel VBA Automation

Automating Excel tasks with ChatGPT has become a highly effective way to simplify workflows, especially when creating VBA (Visual Basic for Applications) macros. By using artificial intelligence, you ...

15 Modern Excel Functions Worth Knowing in 2026 That Outclass Clunky Workflows

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

Using the Free Version of Excel? You’re Missing These 5 Features

Microsoft Excel online lacks functionality compared to paid versions that include features including advanced formulas and charts. Powerful data analytics tools like Power Query and Power Pivot are ...