Please note javascript is required for full website functionality.


New Features for Excel December 2022

21 December 2022

The latest update sees the release of ‘Formula Suggestions’ and ‘Formula by Example’ for Excel web users: these are brand new capabilities designed to help save you time and learn more about Excel formulae as you use them.  Also for web users are ‘Suggested Links’, the IMAGE function and a new Search bar in the Queries pane.  For Windows users, a new keyboard shortcut is available to open the Power Query editor, and Insiders users on Windows can now get data from dynamic arrays and create nested Power Query data types to better organise your data.

The full list is as follows:

Excel for the web

  • Formula Suggestions
  • Formula by Example
  • Suggested Links
  • Add Search bar in Queries pane
  • IMAGE function

Excel for Windows

  • Add keyboard shortcut to open the Power Query editor
  • Create nested Power Query data types (Insiders)
  • Add Get Data from Dynamic Arrays (Insiders)
  • IMAGE function

Excel for Mac

  • IMAGE function.

As always, we'll be detailing these updates in our February newsletter (printing deadlines beat us to the January 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?