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?

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

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

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

Is CONFIDENCE your NORM?...