Please note javascript is required for full website functionality.



Power BI: Introduction to Power BI

11 January 2018

Welcome to the very first post in our new Power BI blog series! Power BI is a tool produced by Microsoft that is designed to assist people with creating business intelligence solutions

Power Query: Querying Query Options

10 January 2018

Welcome to our Power Query blog. This week, I look at the ‘Query Options’ screen and what it can do for me.

Power Pivot Principles: Introduction

9 January 2018

Want to create a PivotTable where formatting “sticks” and data may be referenced from a myriad of various sources at the same time?

A to Z of Excel Functions: the COUNTIF Function

8 January 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the COUNTIF function.

VBA Blog: Total Eclipse of the Heart

5 January 2018

The seventh in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA featuring the Totals Row.

Power Query: Rapidly Renaming Columns

3 January 2018

Welcome to our Power Query blog. This week I look at renaming many columns in one step.

Monday Morning Mulling: December Challenge

1 January 2018

December’s challenge was another deceptively simple question. All you needed to do was to create an in-cell list that provided only non-blank choices from two columns of data. Given our challenge specifically stated that VBA or “anything that appears on the...

Happy New Year 2018

1 January 2018

Wherever you are in the world, however you may be celebrating, all of us here at SumProduct would like to extend the season’s greetings to you as we now see in 2018 – we hope you stick to any resolutions made!

Final Friday Fix: December Challenge

29 December 2017

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights...

Power Query: Customising Custom Built Functions

27 December 2017

Welcome to our Power Query blog. This week I look at how to customise function descriptions by using M function meta-data.