Microsoft 365

Excel

Microsoft Rolls Out Excel Canvas to Automate Self-Updating Copilot Reports

Microsoft is replacing static spreadsheet dashboards with Excel Canvas, a Copilot feature that automatically updates reports when underlying data changes. The tool eliminates manual chart rebuilding but requires strict AI auditing following the recent removal of the COPILOT() function....

Oct 08, 2026 37

Excel

Stop Writing Formulas for Excel PivotTable Percentages

The built-in calculation engine can instantly divide a salesperson's revenue by their specific region's subtotal. Adding the sales field twice lets you display raw dollar amounts and percentage shares side by side....

Sep 28, 2026 24

Excel

Microsoft Excel Now Fits Entire Databases Inside a Single Cell

Single cells can now store complete arrays and structured records without spilling into adjacent columns. A new Cell Explorer pane lets users filter this nested data directly within the traditional grid....

Sep 27, 2026 16

Excel

Microsoft Brings SpaceXAI's Grok to Copilot in Word and Excel

The initial rollout is restricted to Frontier Program customers and explicitly blocks access in the EU and UK. Meanwhile, the upcoming 2.1-trillion-parameter Grok 4.7 model is trained on SpaceX engineering data, making it a potential powerhouse for complex spreadsheet formulas....

Sep 13, 2026 36

Excel

Microsoft Forces Manual Migration for Excel Exchange Connector Users by 2027

Your Excel workbooks pulling Exchange data will break by April 2027. Microsoft isn't providing an automated migration path, and you'll be forced to upgrade to Office 2024 or M365 just to reconnect....

Aug 26, 2026 37

Excel

How to Build Custom Excel Functions Without VBA Using LAMBDA

Replace fragile VBA macros with native formulas, sort sales tiers automatically, and clean messy text imports in seconds. The LAMBDA function turns your most repetitive calculations into permanent, one-click tools....

Jul 10, 2026 34

Excel

How to Replace Excel Pivot Tables with the New GROUPBY and PIVOTBY Functions

Excel's new GROUPBY and PIVOTBY functions eliminate the need for manual refreshes. By turning summaries into live dynamic arrays, they fix the biggest flaw of traditional pivot tables....

Jun 23, 2026 65