This function returns a bitwise ‘XOR’ of two numbers (XOR was first introduced in Excel 2013 and at the current rate of publishing these articles we should get to this one by 2044)...

In order to see some M language in action, I return once again to the query I created in Two (Queries) Become One.

It’s time to find thee antidote to the recent BITLSHIFT function and you shouldn’t feel bitter (BITR?).

As a programmer, I was often asked to produce delimited versions of reports which could easily be picked up by Excel. Whilst it is possible to clean non-delimited files in Excel, it’s a laborious and repetitive process, which is why it made more sense to pay for a programmer to automate it.

Last week, we talked about putting a message box into your VBA code. This week, we’re going to look at another useful way of giving information back: the Status Bar.

Welcome to our new Power Query blog. The built-in functionality of Power Query means that many tasks can be accomplished at the press of a button. But what if there isn’t a button for what needs to be done? Then it’s time to delve into M, the programming language behind Power Query.

’m starting to get used to these functions now, well a BIT anyway (get it?)...

This week, we’re going to look at how to set up message boxes in Excel and VBA...

Welcome to our new Power Query blog. So far I have shown that a variety of data can be extracted and loaded into queries and worksheets. Today I look at how to keep that data current by triggering automatic refreshes.

We have finally been mentioned on an issue of InTheBlack!