Microsoft Excel: 8 New 2026 Features

Key insights

• Agent Mode: The video shows Excel’s new Copilot-driven Agent Mode that can iteratively build and modify sheets for you while keeping you in control.
  Use it to automate multi-step tasks, create workflows, and get suggestions without starting from scratch.
• Formula Completion: Excel now suggests and completes formulas as you type, so you spend less time on syntax and more on analysis.
  This feature speeds up formula creation and lowers the chance of errors in complex calculations.
• Descriptive Error Cards: Improved error handling displays clear error cards that explain the problem and offer fixes.
  These cards make debugging faster and reduce guesswork when formulas return errors.
• SPILL Pivot Tables & Auto Refresh: Pivot tables now support spill behavior and auto-refresh so results expand dynamically and update when source data changes.
  This keeps reports current and avoids distributing outdated summaries.
• Show Changes Extended Lineage: The Show Changes feature now gives deeper change history and lineage, showing who changed what and when with better context.
  Teams can trace edits more easily and audit changes across shared workbooks.
• Forms on Mac, Import Functions & New Get Data: The video highlights Forms integration on Mac plus a refreshed Get Data dialog and new import functions like IMPORTTEXT/IMPORTCSV.
  These updates simplify data capture and make importing text and CSV files faster across platforms.

Overview: Mike Tholfsen’s 2026 Excel Update Walkthrough

In a recent YouTube tutorial, Microsoft education lead Mike Tholfsen walks viewers through eight notable additions to Microsoft Excel for 2026. The video serves as a hands-on tour, highlighting changes that range from user interface refinements to deeper artificial intelligence integration. Overall, the presentation aims to show how these updates could speed up routine work and reduce common spreadsheet errors for both casual and power users.
Furthermore, Tholfsen demonstrates each feature in context, which helps viewers judge practical impacts rather than just theoretical benefits. As a result, his video is useful for IT managers, spreadsheet creators, and educators who need to plan training or rollout strategies.

Core Features and Interface Upgrades

Tholfsen highlights a set of practical improvements that improve everyday productivity. For example, Formula Auto-Complete and enhanced pivot table visuals reduce friction when building reports, while a redesigned focus cell and new navigation pane make it easier to work inside large workbooks.
Moreover, the update includes a Clean Data button that uses AI to detect anomalies and suggest fixes automatically, and a Pivot Table Auto Refresh option that keeps reports current without manual steps. Together, these changes aim to shave time from repetitive chores and help users maintain accuracy in fast-moving data environments.

AI Advances: Copilot, Agent Mode, and Formula Writing

One of the most talked-about additions is the deeper integration of AI through features like COPILOT functions and Agent Mode, which let users ask for analyses or generate formulas using natural language prompts. Tholfsen shows how the AI can draft formulas, suggest next steps for analysis, and iterate on worksheets with a degree of autonomy.
However, he also stresses that AI is an assistant rather than a replacement; users must validate results because automated suggestions can be incomplete or contextually off. Consequently, teams should pair these AI tools with clear review steps and governance to avoid introducing errors into important reports.

Data Import, Connectivity, and Error Handling

The video covers improvements to data import, including a refreshed Get Data dialog in Power Query and new functions such as IMPORTTEXT and IMPORTCSV, which simplify bringing external files into a workbook. Tholfsen demonstrates that these changes speed up data shaping and make repeatable imports easier to manage across projects.
In addition, Excel now surfaces more descriptive error cards, which help users understand and fix issues directly rather than guessing at causes. For teams that rely on automated pipelines, descriptive error handling and clearer lineage via Show Changes extensions can reduce debugging time and improve auditability.

Cross-Platform Parity and Usability on Mac and Web

Notably, Tholfsen points out that several features are arriving or improving on Mac and web versions, such as Forms integration for Mac and editable data label text in Excel for the web. These steps toward parity matter because many organizations operate in mixed-OS and browser environments and expect consistent capabilities.
Nevertheless, achieving full parity presents technical tradeoffs. Mac and web clients sometimes lag behind the Windows desktop in feature rollout, and developers must balance performance, security, and platform constraints when backporting complex Excel functions.

Tradeoffs, Adoption Challenges, and Practical Advice

While the new tools promise efficiency gains, Tholfsen’s walkthrough makes clear that tradeoffs exist between automation and control. For instance, automated cleaning speeds workflows but may obscure transformation decisions unless users inspect change logs, and AI-assisted formulas can accelerate work while requiring stronger validation and governance.
Therefore, organizations should pilot features with representative datasets, document validation checks, and train users on both capabilities and limitations. In conclusion, the 2026 Excel updates present meaningful productivity and usability improvements, but successful adoption will depend on combining the new tools with thoughtful oversight and practical training so teams can safely scale their use.

Keywords

Excel 2026 new features, Microsoft Excel 2026 update, Excel 2026 AI features, Excel 2026 collaboration tools, Excel 2026 data visualization, Excel 2026 Power Query improvements, Excel 2026 formulas and automation, Excel 2026 performance enhancements