New Update New Excel features added by Microsoft

[silversurfer]

Welcome to the August 2023 update. This month, we are incredibly excited to announce the public preview of Python in Excel, which is gradually rolling out to users running Beta Channel on Windows – Excel for Windows version 2309 (Build 16818.20000) or later. Watch this YouTube video by Excel MVP Leila Gharani and this YouTube playlist by Excel MVP Carlos Barboza, and sign up to be notified about future availability for Python in Excel.

Also rolling out to Beta Channel users on Windows are Stale Value Formatting and Monospaced Font in the formula bar. Furthermore, Current Channel users on Windows will now have Simplified Sharing Across M365, Improved Save As/Discard Dialog, and Power BI Connected Tables.


Excel for Windows:

1. Python in Excel (Insiders Beta) Read more here >
2. Stale Value Formatting (Insiders Beta) Read more here >
3. Monospaced Font in formula bar (Insiders Beta) Read more here >
4. Power BI Connected Tables Read more here >
5. Improved Save As/Discard Dialog
6. Simplified Sharing across Microsoft 365 Read more here >
7. Access and Explore Office Add-Ins (Insiders) Read more here >

Excel for web:

1. Simplified Sharing across Microsoft 365 Read more here >
2. Access and Explore Office Add-ins Read more here >

What's New in Excel (August 2023)

Check out what's new in Excel this month

techcommunity.microsoft.com

 

[silversurfer]

Welcome to the September 2023 update. This month, we are thrilled to share that Python in Excel is now available to all Enterprise, Business, Education, and Family and Personal users running Beta Channel on Windows, starting with build 16.0.16818.20000 – and then to the other platforms at a later date. Also, we are excited to introduce the Python Editor from Excel Labs and Copilot support for Python in Excel.

Tune into our upcoming Ask Me Anything (AMA) session on Reddit, r/excel, for questions, answers, and more information on Python in Excel. Submit your questions when the AMA goes live on September 27 at 9 AM PT, and join us live for answers and discussions on September 28 between 9-10 AM PT.


Excel for Windows:

1. Python in Excel (Insiders Beta) Read more here >
2. Python Editor from Excel Labs (Insiders Beta) Read more here >
3. Copilot Support for Python in Excel (available in preview later this year) Read more here >
4. Data Validation Autocomplete Read more here >

Excel for Mac:

1. Data Validation Autocomplete (Insiders) Read more here >

What's New in Excel (September 2023)

Python in Excel available to more Insider Beta users on Windows, Python Editor, Copilot support for Python in Excel, and more

techcommunity.microsoft.com

 

[silversurfer]

Welcome to our October 2023 update! This month we are excited to share several new features rolling out across Excel for the web, Windows, and Mac. The Automate Work button, Formula Authoring Enhancements, and Queries and Connection Pane are now available in Excel for the web. Web Connector Enhancements and Optimized Narrator Screen Announcements have started rolling out to users of Excel for Windows; and Checkboxes in Cells and the ability to control your Data Conversions, to Insider users [on Excel for Windows].

Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps make Excel better for everyone.


Excel for the web

1. Automate Work Button Read more here >
2. Formula Authoring Enhancements Read more here >
3. Queries and Connections Pane

Excel for Windows

1. Checkboxes in Cells (Insiders) #FIA Read more here >
2. Control Data Conversions #FIA Read more here >
3. Web Connector Enhancements #FIA Read more here >
4. Optimizing Screen Narrator Announcements Read more here >

Excel for Mac

1. Control Data Conversions #FIA Read more here >

What's New in Excel (October 2023)

Checkboxes, data conversion control, web connector and more!

techcommunity.microsoft.com

 

[silversurfer]

Welcome to the November 2023 update. This month we are excited to share a number of new features rolling out across Excel for the web, Windows, and Mac. GROUPBY and PIVOTBY, and Export Loop Tables to Excel are both available to Windows and Mac Insiders. Trendline Equation Formatting is now out to all web users, and Workbook Links are now live for Windows users.

Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps make Excel better for everyone.

Excel for web:

1. Trendline Equation Formatting

Excel for Windows:

1. Workbook Links #FIA Read more here >
2. GROUPBY and PIVOTBY Functions (Insiders) Read more here >
3. Export Loop Tables to Excel (Insiders) Read more here >

Excel for Mac:

1. GROUPBY and PIVOTBY Functions (Insiders) Read more here >
2. Export Loop Tables to Excel (Insiders) Read more here >

What's New in Excel (November 2023) | Microsoft Community Hub

GROUPBY, PIVOTBY, trendline equation formatting and more

techcommunity.microsoft.com