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

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.

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.

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 series, and serves as a worthy end-of-year challenge.

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

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

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

Our new Power Query blog continues. Today we look at manipulating a simple CSV file...

This function converts a binary number (base two) to a decimal number (base 10)...

This week saw the successful completion of the first running of our new three-day training course, the catchily-titled “Power Pivot, Power Query and Power BI”. Yes, maybe we need to change the name. We’ll get back to you on that one.