It is highly recommended that values that are passed into formulae, subroutines and functions are variables. However what if the value of that variable does not change? There is a way to make it immutable by declaring it as a constant.

It’s time to move on...

Last Friday, we proposed one of the most puzzling challenges that we’ve had encountered so far, at last our solution...

Last Friday, we proposed one of the most puzzling challenges that we’ve had encountered so far. To dynamically pull data from this Hockey Statistics site using Power Query.

Welcome to this month’s Final Friday Fix! This Friday it’s going to involve a lot of Power Query work...

Welcome to our Power Query blog. This week I look at the options available to organise queries within a workbook.

Do we need to corral you regarding CORREL? If you say no, we might get into a fight concerning the OK corral… Anyway…

Last weeks’ blog examined the value of declaring variables. But variables can also be used in different subroutines and functions. If there are items that are known to have constant values throughout the entire workbook, they can be declared explicitly in one place...

Welcome to our Power Query blog. This week let's look at how to convert names into an alternative format.

Are you a CONVERT?