Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Powering Through Issues

22 November 2017

Sometimes, I am happily working away in Power Query when I hit a problem. Features are not there when I need them, something I’m sure should have worked doesn’t...


VBA Blog: Turning Tables

20 November 2017

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


Same-Sex Marriage Results - A Data Driven Analysis

17 November 2017

It’s been a big week in Australian politics, as the results of a voluntary postal survey have come back suggesting that Australians overall are in favour of legalising same sex marriage...


A to Z of Excel Functions: the COT Function

17 November 2017

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


Power Query: Birthday Lists

15 November 2017

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


A to Z of Excel Functions: the COSH Function

13 November 2017

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


VBA Blog: Unforget-TABLE, That’s What You Are

10 November 2017

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


Power Query: Expanding on Aggregating

8 November 2017

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


A to Z of Excel Functions: the COS Function

6 November 2017

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


VBA Blog: Constants is Her Name

3 November 2017

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.


Newsletter