Blog


An enhanced name manager for Microsoft Excel

An enhanced name manager for Microsoft ExcelNamed ranges are one of those marmite things in Excel, either you use them or you don't. I sit between the two camps and my utilisation depends on two things: Firstly who the end user will be and whether they'll need to interact with them. The other is a timesaving thing - their use will depend on if it will save me time over the long   more »



Malaga to Manchester flight GPX tracklog - aborted landing

Malaga to Manchester flight GPX tracklog - aborted landingThis flight was a cracker, made extra special not only for the fact it was the first I was able to fully record on my GPX logger for later analysis - but for the added drama of the flight. First off the skies that day were a bit congested so we had to do an extra loop over Warrington whist we were waiting, but next there was great excitement. As   more »



Extract a Surname from a string in Excel

Extract a Surname from a string in ExcelThere comes a point in every Excel users workflow that they've got to work with a list of names. Usually the data you get is in the wrong format, or you have to compare two dataset of different formats. This can be frustrating but here is a quick guide of how to manipulate them. This tutorial is based around extracting the surname / family   more »



The blog has now reached 50 posts!

The blog has now reached 50 posts!Well, I didn't think I had it in me to write so much, I'm generally not a person with much to say (this is a lot for me!). My general interest in all things tech had always since the early days compelled me to want to make my own website, trouble is you actually need to have some content to put on it. After a while toiling I'd decided   more »

Tags : 50 today blog RPI


Share page

Subscribe to newsletter

Search Posts

Back to top