Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the CALL Function

20 March 2017

Look, before we go anywhere here, this function is for advanced users only. If you use the CALL function incorrectly, you might be looking for a new computer – well at best, you’ll have to restart your PC....

Read more


A to Z of Excel Functions: the BITXOR Function

17 March 2017

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

Read more


Power Query: M-Body Personified

15 March 2017

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

Read more


A to Z of Excel Functions: the BITRSHIFT Function

13 March 2017

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

Read more


Updating your Status (Bar) in Excel

10 March 2017

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.

Read more


Power Query: M-Powered

8 March 2017

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

Read more


A to Z of Excel Functions: the BITOR Function

6 March 2017

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

Read more


Using Message Boxes in Excel

3 March 2017

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

Read more


Power Query - Time for Refreshments

1 March 2017

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.

Read more


In the Black

28 February 2017

We have finally been mentioned on an issue of InTheBlack!

Read more


Newsletter