Please note javascript is required for full website functionality.


Monday Morning Mulling: October Challenge

30 October 2017

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.

Final Friday Fix: October Challenge

27 October 2017

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

Power Query: Managing Many Queries

25 October 2017

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

A to Z of Excel Functions: The CORREL Function

23 October 2017

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

VBA Blogs: Scoping Variables

20 October 2017

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

Power Query: Initial Problems

18 October 2017

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

VBA Blogs: The Value of Declaring Variables

13 October 2017

Take an in depth look of the good coding practice in declaring variables how it helps write better VBA code.

Power Query: If You Can’t Tell Them Apart, Join Them

11 October 2017

Sometimes, the tasks I have to do are less than thrilling...

A to Z of Excel Functions: The CONFIDENCE.T Function

9 October 2017

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CONFIDENCE.T function.