This question. I see a lot of posts asking where they can learn VBA. I always answer the question with a question. There’s VBA. And there’s applied VBA. VBA...
Philosophy
I had a compliment on my writing. Someone (who knows about these things!) pointed out that I explore commonly found spreadsheet problems but by examining things that...
I created this challenge in 2016 in response to a discussion going on at the time – the need for some standards on Excel Competence (ICAEW). Who decides how a...
I was reminded by Willem Gerritsen on this article from 2014, hosted by Oz du Soleil. Where are Excel & Google Spreadsheet Headed? Part 2 of 6 Quite apart from being...
An Add-In, or a high level tool (like a widget) makes it easy for us to carry out a specific task but only if what you want is exactly what the Add In developer intended...
In this video, you will see three Excel spreadsheets working in a way you don’t normally expect spreadsheets to work. Watch the video …Can you figure out...
This content is password protected. To view it please enter your password below:
Password:
When spreadsheets are perceived negatively, it devalues the entire Excel eco-system. The common problems we have with current spreadsheet practice were solved, in...
I’m following Laurentz’s article. This is going to be interesting. (25/11/2019) I’ve kicked it off like this: There’s a presumption that...
Well, this video has been a preview for a few weeks now – hoping to get some feedback from those interested in preventing spreadsheet risk. None so far. But the...