This function returns the cotangent of the given angle. For those of you who don’t find trigonometry riveting you really shouldn’t be so obtuse, but the cotangent is the inverse of the tangent function...

Since I have reached the milestone of my 50th issue, I have covered a whole list of Power Query features. Talking of lists… (it’s an ellipsis, get it?)

You probably think we talk a load of hyperbolics here, but that’s what happens when we are under the COSH...

The first in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA.

This week I look at bringing in two tables of data and summarising some of that data. At the same time..

Not to be confused with cos lettuce, this function returns the cosine of the given angle...

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.