November 2016 – IMTHEBUS

Removing duplicates in a worksheet

This is a function I use most when dealing with mailing lists, it’s invaluable and incredibly simple. There are many times

Today I was approached by a very charming lady from Brazil to do some freelance work. She was articulate and well

One of the great markers of a person who knows what they are doing in Excel (and indeed life), is the ease

Mastering Filtering in excel is one of those watershed skills. I regularly teach it as the point you stop using Excel

As soon as you are using Excel to store any numbers, you have to be able to calculate with those

Ok, let’s be fair. This is probably the simplest of all things I will make the effort to post about,

So you said you were competent in Excel and all Microsoft programs, because that’s what you do on a CV isn’t it?

For the past decade and a half I have been using Excel on a near daily basis, and constantly striving

Creating your first Excel add-in can be a daunting task, I put it off for a long time preferring to