Today, we’re going to look at a common application of VBA involving a range of skills that we’ve gone through...

As I described in Calendar Creation – Preparing for Dates building a calendar using Power Query is a collaboration between Excel and Power Query. Read this article to find out how!..

Do you know where your CEILING is precisely?? If not, this function won’t help you.

Last week, we showed you how to declare variables. This week, we’re going to use a variable to create a loop. Let’s introduce the For loop.

Building a calendar using Power Query is a collaboration between Excel and Power Query...

This function sounds like something you calculate whilst swinging from the chandeliers...

One of the most useful things you can do in VBA is to store values in the program’s memory, so that you can use it in the future...

Over the last few weeks I have shown some of the tasks that can be achieved with M language and functions. Today I look at how to replicate some familiar Excel formulas.

Last week, we looked at a strange event – in certain cases when you are creating running totals, Power Query stores the number in strange ways....

In celebration of having published three full months of Power Query blog articles, we’re dedicating the March Final Friday Fix to a Power Query problem!