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.

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.