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.

If our Final Friday Fix challenges don’t quite scratch your Excel itch, there are plenty of Excel challenges to be found out in the wild.

The latest updates see Microsoft add a slew of DAX functions (well, three anyway!), improve slicer type formatting and bring Metrics to the Windows application.

This is going to stuff up a few textbooks! Power BI is updating its accent colour to teal.

This latest set of updates see the introduction of an Optimize Ribbon which makes your report creation experience more streamlined, especially if you are working in DirectQuery mode.

The latest updates see the Navigation pane is now Generally Available for Excel for Windows, and for Windows and Mac Insiders, Automate Tasks with Office Scripts enables you to automate repetitive tasks in your Excel work. There are other additions / improvements too.

The latest updates see the Navigation pane is now Generally Available for Excel for Windows, and for Windows and Mac Insiders, Automate Tasks with Office Scripts enables you to automate repetitive tasks in your Excel work.

Tomorrow, SumProduct’s very own Tim Heng and Liam Bastick are both taking part in the Microsoft Excel World Championship 2022, albeit in two very different roles.

The latest updates see the release of Check Performance for Excel web users to help speed up your workbooks and dynamic array support for Windows users.

This month’s update includes Power BI metrics, Modeling (sic) updates, deployment pipelines and more.