August 2023 Updates in Microsoft Excel: Insights from Expert
August 2023 Excel update introduces Python in Excel, available to Beta Channel users and other features for public preview.
The August 2023 Excel update introduces Python in Excel, available for public preview. This feature is gradually rolling out to Beta Channel users on Windows using Excel version 2309 (Build 16818.20000) or later. Also included in this release are Stale Value Formatting and Monospaced Font in the formula bar.
For Current Channel users on Windows, New features include Simplified Sharing Across M365, Improved Save As/Discard Dialog, and Power BI Connected Tables.
Features for Excel for Windows:
- Python in Excel (Insiders Beta)
- Stale Value Formatting (Insiders Beta)
- Monospaced Font in the formula bar (Insiders Beta)
- Power BI Connected Tables
- Improved Save As/Discard Dialog
- Simplified Sharing across Microsoft 365
- Access and Explore Office Add-Ins (Insiders)
Features for Excel for web:
- Simplified Sharing across Microsoft 365
- Access and Explore Office Add-ins
Detailed Feature Description
The Python in Excel feature allows you to natively integrate Python and Excel analytics in the same workbook, without any setup. Python coding can be done directly into a cell, with calculations run in the Microsoft Cloud and results returned to the worksheet, including visualizations.
The Stale Value Formatting feature addresses the issue of values becoming outdated when manual calculation mode suspends calculations. These outdated values are referred to as 'stale'.
Read the full article What's New in Excel (August 2023)
Learn about What's New in Excel (August 2023)
Microsoft Excel has released a new update in August 2023 with several new features. Python in Excel is available as a public preview, which allows users to type Python directly into a cell and have calculations run in the Microsoft Cloud and results returned to the worksheet. Stale Value Formatting and Monospaced Font in the formula bar are also available to Beta Channel users on Windows. Current Channel users on Windows will now have Simplified Sharing Across M365, Improved Save As/Discard Dialog, and Power BI Connected Tables. Excel for web users will have access to Simplified Sharing across Microsoft 365 and Access and Explore Office Add-ins. Python in Excel allows users to combine Python and Excel analytics within the same workbook, with no setup required. It also allows users to visualize their data with Python in Excel. Stale Value Formatting suspends calculations, which means that the values in cells can become out of date. Monospaced Font in the formula bar provides a consistent view of formulas. Improved Save As/Discard Dialog allows users to save or discard changes to the workbook. Simplified Sharing Across M365 provides an easy way to share a workbook with other users. Power BI Connected Tables allows users to connect directly to Power BI data. Access and Explore Office Add-ins provides access to Office Add-ins.
More links on about What's New in Excel (August 2023)
- August 2023 updates for Microsoft Office
- Aug 8, 2023 — List of office updates released in August 2023 ; Microsoft Office 2016 · Excel 2016 ; Microsoft Office 2013 · Excel 2013 ; SharePoint Server ...
- What's New in Excel (July 2023)
- Jul 25, 2023 — You can now format data points in your chart using the Home Ribbon Controls. With this update, you can choose the fill color for each individual ...
- What's new in August 2023
- Aug 22, 2023 — This document details the new features and capabilities launched on the Microsoft Community Training platform in August 2023.
- 30 updates for Microsoft 365 Education | August 2023
- Aug 8, 2023 — 30 updates for Microsoft 365 Education | August 2023 · 1. Microsoft Reflect · 2. OneNote · 3. Forms · 4. Whiteboard: New toolbar UI, start with ...
- Release notes for Current Channel
- 2 days ago — Article; 08/28/2023 ... These release notes provide information about new features and non-security updates that are included in Current ...
- Monthly news - August 2023
- Aug 1, 2023 — This is our monthly "What's new" blog post, summarizing product updates and various new assets we released over the past month across our ...
- 8 Awesome New Excel Formulas for 2023 | Do you know ...
- These formulas include Vstack, Hstack, textsplit, textbefore, textafter, image function, converting images to tables, TOCOL, TOROW, Take, Drop, and Expand ...
- What's New in Microsoft Excel
- Aug 17, 2023 — Contextures Blog: What's your favourite way to troubleshoot Excel formulas? Video shows new Excel features coming soon! June 1, 2023.
Keywords
Python in Excel, Stale Value Formatting, Monospaced Font, Power BI Connected Tables, Improved Save As/Discard Dialog, Simplified Sharing Across M365, Access and Explore Office Add-Ins, Aggregate and Visualize Data, Manual Calculation Mode, Microsoft Cloud.