One of the major features Microsoft highlights as part of the October 2025 release is Agent Mode in Excel. This is another AI feature, but unlike many others added in the past, this one does sound ...

The CHOOSECOLS formula is a catalyst when it comes to selecting specific columns from a table. This formula allows you to streamline your data analysis process by quickly and easily extracting the ...

Microsoft 365 roadmap adds new features for Edge, Outlook, Excel, and Copilot, including AI code execution, toolbar updates, ...

It's that time of the month again: when Microsoft recaps everything new that it introduced in Excel during the past four weeks. This roundup is useful because it allows us to see the improvements ...

Microsoft Excel users can now access Copilot using a new COPILOT function, which pulls AI assistance directly into formulas and cell operations. This function is not a Copilot chat or sidebar, but a ...

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

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Every time Steven publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from ...