What a strange question. Or is it? Let me explain. Back in the days at uni I had a Sinclair Cambridge calculator. A tiny dark grey piece of plastic my friends called the...
Archive - November 2019
I came across this video from Paula Guilfoyle today via LinkedIn. How To Find the Nth Largest in Excel. There’s a couple of questions I would ask. Why do we need...
At my school exams for uni entrance I did Pure Mathematics and Applied Mathematics (along with Physics and Chemistry). Pure Mathematics is mathematics. Applied...
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...
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: