Please note javascript is required for full website functionality.


July 2023 Updates for Power BI

12 July 2023

It seems a little quieter this month. Nevertheless, let’s get you up to date.

MVP Renewal 2023

7 July 2023

SumProduct is pleased to announce that two of our Directors, Liam Bastick and Tim Heng, have been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel for 2023-24.

Images and Data Types in PivotTables

5 July 2023

PivotTables allow you to easily create summaries, dashboards and reports, as well as aggregate information. Whilst data types and in-cell images are a powerful part of modern Excel, PivotTables have only been able to use a text description of these modern content types. Now, the images and data types come intact to your PivotTable rows and columns in both Excel for Windows and Excel for Mac. They also include the same interactions you have in your source data (image cards, data type icons, data type cards, etc.).

Formula by Example

4 July 2023

‘Formula by Example’ has now started to roll out to Excel web users. ‘Formula by Example’ looks for patterns as the user enters data in the worksheet. When it recognises a pattern, ‘Formula by Example’ offers a formula to fill the rest of the column with the recognised pattern.

Formula Suggestions in Excel

3 July 2023

Back in December last year, Microsoft announced ‘Formula Suggestions’ was beginning to roll out to Excel web users. Now, it is available to all web users with English set as their primary language (rules me out then: I use profane). Whether you’re new to Excel or have used it for years, ‘Formula Suggestions’ helps you create formulae more quickly and accurately by offering relevant suggestions based on your data and context. All you need to do is type "=" at the beginning of a cell, and Formula Suggestions will show you different formulae that you can apply to your data, along with a specified range.

New Features for Excel June 2023

30 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.

2023 End of Financial Year Sale

23 June 2023

FY2023 has been a good year for SumProduct. We’ve helped more clients than ever before, trained more people than ever before and told more bad jokes than ever before.

New Features for Excel May 2023

31 May 2023

This update sees several new features across Excel for the web, Windows and Mac.

May 2023 Updates for Power BI

26 May 2023

Microsoft Fabric has now been announced – but that’s not all!

Announcing Microsoft Fabric

24 May 2023

Time for conditioning! Microsoft Fabric, now in Preview, is an end-to-end, human-centred analytics product that brings together all of an organisation’s data and analytics in one place. It combines Power BI, Azure Synapse and Azure Data Factory into one unified software as a service (SaaS) platform.