New Features for Excel July 2024

This month sees you able to use Copilot in Excel to unlock insights from data, work on data ranges resembling tables and prompt for step-by-step instructions including formula examples.  But that’s not all.  Pretty much half of our August newsletter is reproduced below (if you haven’t subscribed already, perhaps you should)!

The full list is as follows:

Excel for the web

• Copilot in Excel: unlocking insights from data
• Copilot in Excel: expanded data structure support and comprehensive answers
• Modernised Excel grid
• Synchronise Forms data to Excel

Excel for Windows

• Copilot in Excel: unlocking insights from data
• Copilot in Excel: expanded data structure support and comprehensive answers
• Checkboxes in cells
• TRANSLATE and DETECTLANGUAGE functions (Insiders)
• Python Editor (Insiders)
• Python in Excel: additional library support (Insiders)

Excel for Mac

• Copilot in Excel: unlocking insights from data
• Copilot in Excel: expanded data structure support and comprehensive answers
• Checkboxes in cells
• TRANSLATE and DETECTLANGUAGE functions (Insiders)
• Refresh data from Power Query’s ‘From Folder’ connector.

As always, we'll be detailing these updates in our September 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?