What's New in Excel - 2025 Version

Excel continues to receive regular feature updates in 2025, particularly for Microsoft 365 subscribers, and many of the most impactful changes focus on AI integration, formula capabilities, and productivity improvements. Microsoft Copilot integration within Excel has expanded, allowing users to analyze datasets, generate insights, create PivotTables, and write formulas using natural language prompts directly in the workbook. New and enhanced functions continue to be added to the dynamic array function library, building on the foundation of XLOOKUP, FILTER, SORT, UNIQUE, and SEQUENCE introduced in recent years. Navigation improvements make moving within large, complex workbooks faster and more intuitive. Content management features simplify working with large datasets by improving filtering, sorting, and range management capabilities. Excel expert Derek Henry, CPA, CFE covers the most impactful 2025 Excel updates in Aurora Training Advantage's 60-minute on-demand Business Administration webinar, designed for finance, accounting, and operations professionals who use Excel regularly but haven't had time to explore recent additions.

Microsoft Copilot in Excel is an AI-powered assistant integrated into the Excel ribbon for Microsoft 365 subscribers. It allows users to interact with their spreadsheet data using natural language—typing or speaking questions and instructions rather than manually constructing formulas, pivot tables, or charts. Copilot can analyze a selected data range and provide a summary of key trends and patterns, suggest relevant charts or PivotTable layouts, generate complex formulas based on a plain-language description of the desired calculation, highlight anomalies or outliers in datasets, and help format or restructure data. It works best when data is structured as a formal Excel Table with consistent headers. Copilot Pro offers more advanced capabilities than the free tier, including multi-step automation and deeper data analysis workflows. For finance, accounting, and operations professionals who spend significant time in Excel, Copilot can meaningfully reduce the time required for routine analysis tasks. Excel expert Derek Henry, CPA, CFE demonstrates how to use Copilot and other new Excel features effectively in Aurora Training Advantage's on-demand Excel 2025 updates webinar.

Many Excel users are unaware of powerful features introduced in recent years that can dramatically improve efficiency. Dynamic array functions—including XLOOKUP (the modern replacement for VLOOKUP), FILTER (which returns a range meeting specific criteria), UNIQUE (which extracts distinct values), SORT (which sorts a range dynamically), and SEQUENCE (which generates a series of numbers)—can replace dozens of lines of complex legacy formulas with single, readable functions. The LET function allows you to define named variables within a formula, reducing repetition and improving readability. The LAMBDA function enables you to create fully custom, reusable functions without VBA. Power Query is dramatically underused as a data transformation tool—it can clean, reshape, and combine data from multiple sources with point-and-click ease and refreshes automatically when source data changes. Named Ranges and structured Table references make formulas self-documenting and easier to audit. The Camera Tool creates live-linked images of cell ranges that update automatically, useful for executive dashboards. Derek Henry, CPA, CFE highlights these and other underused Excel tools in Aurora Training Advantage's on-demand Excel 2025 webinar.

Excel has introduced several navigation improvements that help users work more efficiently within large, complex workbooks. The Navigation Pane—available in Microsoft 365—provides a panel on the right side of the window that shows a structured view of all sheets, Tables, named ranges, PivotTables, charts, and other objects within the workbook, allowing direct navigation to any element with a single click. This is especially valuable for workbooks with many sheets or embedded objects. Checkboxes in cells can now be inserted natively without requiring form controls, improving interactive dashboard design. The Sheet View feature allows individual users to create personal filtered views of a shared workbook without affecting what other users see. Improved search functionality within Excel makes it faster to locate cells, formulas, and named ranges. Tab scrolling improvements make working with many sheets easier. For professionals who work with large financial models, reporting workbooks, or data analysis files, these navigation improvements can meaningfully reduce time spent finding and moving between relevant content. Excel expert Derek Henry covers Excel navigation improvements in Aurora Training Advantage's on-demand Business Administration webinar on Excel 2025 updates.

Excel remains the dominant tool for financial modeling, reporting, budgeting, and data analysis across finance and accounting functions—but the version most professionals learned on years ago has been dramatically enhanced. Users relying on VLOOKUP when XLOOKUP is available, manually refreshing data when Power Query can automate it, or writing nested IF statements when SWITCH or IFS would be cleaner are leaving significant efficiency gains unrealized. More critically, teams that don't stay current lose the ability to maintain workbooks built by colleagues who have adopted newer approaches—creating maintenance gaps and audit risk. Continuing to develop Excel skills is also a career differentiator: finance professionals who are visibly more efficient and produce more sophisticated analysis are better positioned for advancement. The transition to AI-assisted Excel tools via Copilot and ChatGPT integration means that professionals who understand both traditional Excel and AI augmentation can work at a fundamentally different pace. Regular professional development in Excel—through structured webinars, practice, and peer learning—delivers direct productivity returns. Derek Henry, CPA, CFE provides accessible, practical Excel training for accounting and finance professionals through Aurora Training Advantage's on-demand webinar library.