New Features for Excel June 2023

The latest updates saw quite a few highlights.  There is ‘Formula Suggestions’ and ‘Formula by Example’ for Excel web users.  ‘Use Image’ and Data Types in PivotTables are now available for Windows and Mac Insider users, and ‘Generate an Accessible PDF’ is available to all Mac users.

You can check out the full list here:

Excel for the web

• Formula Suggestions
• Formula by Example
• Support Chart Formatting via Selection and Ribbon Buttons
• Move Chart Elements within Chart Player
• Name Manager

Excel for Windows

• Office Scripts (Current Channel and Monthly Enterprise Channel)
• Get data from Dynamic Arrays (Current Channel)
• Rapid Refresh (Current Channel)
• Guided Reapply (Current Channel)
• Use Image and Data Types in PivotTables (Insiders)
• Data Validation Dropdown List Autocomplete (Current Channel)
• Paste Values directly into your workbook using a Keyboard Shortcut (Current Channel)

Excel for Mac

• Generate an Accessible PDF
• Enhanced Search Experience
• Use Image and Data Types in PivotTables (Insiders).

As always, we'll be detailing these updates in our August newsletter.  Please remember we have virtual / online training in Excel which you can find out more about here.  If you are not already a subscriber, why not sign up at the bottom of any SumProduct web page?