Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...
The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...
A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...
At its Ignite conference, Microsoft today announced an update to Excel that brings a new JavaScript API to the venerable spreadsheet app. With this new API, developers will be able to create custom ...
All details in this article are correct as of October 29, 2025. Accessibility to some of the latest Excel features depends on ...