Please note javascript is required for full website functionality.

News

Value Preview ToolTips in Excel

27 January 2023

Microsoft has just added ToolTips to help you check your formulae directly in the Formula bar or in the cell you’re editing.


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.


Shortest Formula Challenge

20 December 2022

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.


December 2022 Updates for Power BI

14 December 2022

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.


Power BI Goes Green

30 November 2022

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


Late November 2022 Updates for Power BI

30 November 2022

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.


New Features for Excel November 2022

30 November 2022

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.


New Features for Excel Late October 2022

8 November 2022

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.


Microsoft Excel World Championship on ESPN

2 November 2022

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.


New Features for Excel October 2022

29 October 2022

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.


Newsletter