Please note javascript is required for full website functionality.
MVP

Blog

Blog

Introduction to VBA: Recording Macros

20 January 2017

Every Friday, we intend to post a blog talking about VBA and highlight the benefits, the pitfalls, and cover a range of basic concepts that everyone who uses VBA should know.


Power Query - What's in a Name?

18 January 2017

Welcome our new Power Query blog. Today I extract information from a file name.


A to Z of Excel Functions: the BINOMDIST Function (Part 2?)

16 January 2017

Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. ...


Introduction to VBA

13 January 2017

If you’ve never used macros but want to understand how they work, this series is for you...


Power Query – Painless Unpivoting

11 January 2017

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


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


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


Power Query – One Folder, One Query

4 January 2017

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


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.


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.


Newsletter