Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query – Painless Unpivoting

11 January 2017

Welcome our new Power Query blog. Today we unpivot data ready to append it to a query...

Read more


A to Z of Excel Functions: the BINOM.DIST Function

9 January 2017

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability...

Read more


A to Z of Excel Functions: the BIN2OCT Function

6 January 2017

This function converts a binary number (base two) to an octal number (base eight)...

Read more


Power Query – One Folder, One Query

4 January 2017

Welcome our new Power Query blog. Today we extract multiple files from a folder...

Read more


Monday Morning Mulling: December 2016

2 January 2017

Welcome again to 2017! Last week, at the end of December, we asked if you could create a chart that would have the number format of the chart axis dynamically change when the values being charted increase or decrease.

Read more


Happy New Year 2017!!

1 January 2017

Wherever you are in the world, all of us here at SumProduct would like to extend the season’s greetings to you, wherever you may be. We hope you have an EXCELlent time and a prosperous New Year.

Read more


Final Friday Fix: December 2016

30 December 2016

Here at SumProduct, we often get asked some pretty tough challenges – the ones that you typically can’t find answers to online. So it pleased us that there was an interesting question that we were asked earlier this month that deserves to appear in our Friday Fix...

Read more


Power Query – Appending Files

28 December 2016

Welcome our new Power Query blog. Today we append to an existing query...

Read more


A to Z of Excel Functions: the BIN2HEX Function

26 December 2016

We don’t want to put the hex on this function, but this converts a binary number (base two) to a hexadecimal number (base 16)...

Read more


Season's Greetings

23 December 2016

As the year winds up to a close, we’d like to wish everyone a Merry Christmas, Happy Holidays, Season’s Greetings, and any other well-wishing phrase that you might use wherever you are...

Read more


Newsletter