Please note javascript is required for full website functionality.



XLOOKUP and XMATCH Now Across Office 365 Insider Fast

9 September 2019

It is now believed – although not officially confirmed – that XLOOKUP and XMATCH have now been rolled out to all Office 365 Insider Fast users.

Power BI Mobile Apps Gets a New Look (Preview)

3 September 2019

Power BI Mobile provides the tools you need to stay connected to your data, wherever you may be. However, as organisations grow, it becomes increasingly difficult for Power BI users to discover and manage the content that matters to them on the go. Microsoft has...

XLOOKUP and XMATCH: Two New X-Men for Excel

29 August 2019

Late August 2019 and Microsoft has added two new functions, XLOOKUP and XMATCH. For reasons that will become clear, here I will mainly consider the former function – because once you understand XLOOKUP, XMATCH becomes obvious (nothing personal, XMATCH).

Countdown to 8 out of 10 Cats does SumProduct

24 August 2019

For those clients and / or readers in the UK, SumProduct’s very own Liam Bastick is to be a contestant on the legendary quiz show, Countdown.

Power BI MVP Book - A Compendium

24 August 2019

There’s a new Power BI book out – but it’s not like a normal book used to learn Power BI.  This book is a selection of articles from 21 Power BI MVPs, including our very own Liam Bastick.  Each chapter focuses on a particular subject instead, rather than provide a...

August 2019 Updates for Power BI Desktop

15 August 2019

The August release has another hotly anticipated feature from the Microsoft Business Application Summit: grouping.  Grouping in reports, similar to PowerPoint’s grouping, lets you easily organise groups of visuals to move and resize them as a set.  This month’s...

July 2019 Updates for Power BI Service and Mobile

12 August 2019

Two-thirds of the way through the year and the rate of change in Power BI and Service continues.

Excel Blog Return

31 July 2019

After a six-year hiatus, we are pleased to announce SumProduct has managed a return visit to Microsoft’s Excel Blog.

Power BI Service Gets Fresh

25 July 2019

Announcing a public Preview of the ‘new look’ for Power BI Service.

July 2019 Updates for Power BI Desktop

21 July 2019

With this month’s update comes the first feature release from Microsoft’s recent announcements at the Microsoft Business Application Summit (MBAS): icon sets.