Too Many Grades!

April 15, 2016 | Kevin Crooks
How long is a piece of string? Have you ever heard that question? A common answer is “twice as long as from one end to the middle”, but perhaps an overlooked response is “according to which unit of measurement?”.  Read More

Rabbits, Fibonacci & Schematiq

February 03, 2016 | Kevin Crooks
What do breeding rabbits and Schematiq have in common? I hear you ask, or maybe you didn’t. Read More

An Example Of How Schematiq Makes Things Easy

March 07, 2015 | Kevin Sinclair
Here’s a little example of Schematiq’s amazing power to distil a spreadsheet into a few cells whilst still making the details easy to see. Let’s suppose I want to have a little widget in my spreadsheet that tells me who my favourite baseball team are playing that night, and whether it’s a day or night game.  Read More

Excel bites: How to find links

February 26, 2015 | Kevin Sinclair
So have a guess who my favourite person in the world is. Nope, not Sergio Aguero. Not Danny Macaskill. Not even Harrison Ford. Actually, it’s Bill Manville. You don’t know who he is? Fair enough, no reason why you should. But he’s my hero because he wrote the second-best thing I ever saw on the internet. Read More

Excel Bites – Self-Sizing Validation Lists

October 02, 2014 | Admin
Excel Bites is an occasional column devoted to useful and simple tricks and techniques that as an Excel user you might well have seen before, but if not you really ought to hear about. Read More