This is a simple test I created for a client. It is to evaluate candidates who have ‘Excel to Macro Level’ on their CV/Resume. The button ‘New...
Archive - February 2020
Here’s the kind of the weird conversations I get drawn into. I was explaining a solution to an Excel problem that involves looping though a range of cells. Nothing...
When I see a blog post or a question or answer on a forum that seems to suggest that ‘VBA is something extra and not really part of proper Excel (really)’ I...
Since there’re tons of Excel courses online and in-classroom training, does the business world really need any more? To use Excel you need to know how to use it 🙂...
Whenever I demonstrate a powerful idea that usually has ALREADY made a huge difference in an organisation, there’s always somebody who’s coming from some...
PREVIEW! Excel has some powerful features. Here’s a chance to see whether you have mastered them. How would you use them in a real life situation? Download the...
Exactly that. Imagine a bus has overturned and some of the passengers are trapped underneath. Superman flies in, as he does, and lands in a flourish. The people are...
First a clarification. This blog is about the many questions asked on Excel forums, where the question asked is ‘how can I do this using this tool or...
This is another rant that could get me into trouble if I’m not careful with my words! Let me start with a real-life illustration. I visit my family in Sri Lanka...
Since the beginning of Excel I’ve been playing a little game. Mainly for my own amusement, though it also helped me further my career while improving processes in...