Unlock Excel’s potential with June 2023’s new features for improved productivity
Microsoft Excel remains a dominant tool utilized in various business and personal contexts, serving the purposes of data analysis, visualization, experimentation, documentation, and planning. In order to meet the evolving demands of users, Microsoft consistently improves Excel by introducing new features. Now, let’s delve into the recent updates.
In Excel for the web, users can now save time with recommended formulas that appear when typing the “=” symbol in the formula bar. While limited to basic formulas like SUM, AVERAGE, COUNT and more, this feature provides contextual insights. In addition, users working with formula data benefit from full-column formula suggestions that provide dynamic formulas instead of static text, setting this apart from traditional Flash Fill. These features are currently available to users whose primary language is English.
Visualizations in Excel for the web have received an update, allowing users to format charts using the Home Ribbon Formatting controls. In addition, chart elements can be moved around the chart, allowing greater customization options. The much-requested feature, Name Manager, has been reintroduced, allowing users to easily name selected ranges of cells.
In Excel for Windows, Current Channel and Monthly Enterprise Channel members can now take advantage of Office Scripts to record actions and automate repetitive tasks. In addition, Current Channel customers can use the reapplication wizard when creating an Excel file. This feature streamlines the handling of interruptions during editing and provides the ability to save a copy of pending changes or revert to previous versions.
Current channel users also have access to “Feedback in Action (#FIA)” features, including dynamic tables from Power Query’s Get Data option, Rapid Refresh for automatic refresh in shared workbooks during co-editing (soon to support multiple workbooks and Excel for Mac), and the ability include images and other data types in pivot tables.
Excel for Mac introduces three new features based on user feedback. First, users can now create easy-to-use PDF files that mirror the functionality of the Win32 version. Second, an improved unified search experience helps insiders find content from documents, commands, how-to articles, and Bing-based web results. Finally, support for PivotTable images is now available for Excel for Mac Insiders.
As always, Microsoft welcomes feedback from Excel users about existing features and suggestions for new ones. The feedback portal is easy to use so that users can send feedback and participate in the continuous development of the software.
