The Excel that we see is only the visible part of Excel. Obviously. We don’t normally see the invisible part of anything. If we did it would not be invisible...
Philosophy
Or … from WFH to WTF? Imagine a normal day in a normal office, at normal times (which, sadly, ‘now’ is not). You need to update a spreadsheet that the...
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...
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...