Author Archive

I’ve added a number of excel tutorials to the NHS Excel website and this will become the home for most of my excel related content. It’s been a busy month at work due to year end and the agreement of balances exercise but its been interesting from an excel point of view. We’ve had...
Read more »

This won’t appeal to many folks but just in case you’ve ever been excited by the NHS Code to Grouper spreadsheet and would like to squeeze that and the PbR tariff information spreadsheet onto your iPhone, I’ve written up a review of the NHS Reference or NHSRef iPhone app over on my NHS Excel...
Read more »

Waterfall charts have become all the rage in the office of late. They are popping up all over. I suppose it is no surprise, it’s springtime and we are well into the planning process and a waterfall chart is the perfect way to demonstrate how a starting position either increases or decreases through a...
Read more »

If you work with spreadsheets that are regularly being updated and amended by multiple users then you will know something about version control. If you then add to this mix, the need to periodically distribute the updated spreadsheet for public viewing you will be more than well aware that Microsoft Excel isn’t really designed...
Read more »

Excel to CrossTabI often find myself struggling to deal with data that has been rendered almost unusable by the data provider who has converted it to a cross tab format. Usually they think they are helping and have probably started with a nice flat list then spent ages formatting it so the data spreads...
Read more »

How to create a custom search folder in Microsoft Outlook 2007 that shows mail categorised in more than one specified category. A combined category search folder using the logical AND rather than the OR operator.
Read more »

I’m moving to a new job soon and wanted to take the opportunity to set up the new email system in line with GTD (Getting Things Done) methodology. Here’s my checklist for setting up the new system on Outlook 2007. Most tips and code are taken from Simon Guest over at Simon Says but I’ve amended...
Read more »

The blog post sounds a little Darwinian but I’m afraid it’s just a dull selection of VBA code that enables you to sort one array on the basis of values from another. A double sorting array. I’ve amended array sorting code from John Walkenbach and Anthony’s VBA Tutorials to create something I can understand....
Read more »

Here’s another VBA snippet post. I find it handy to have a store of regularly used macros on the blog so I can access them at any time, not that I need them that often of course. These particular snippets are useful routines for sorting arrays and can be called from other procedures. I’ve...
Read more »

I’ve been devouring word games over the last few weeks and found myself dreaming obsessively about 4-letter word combinations. Now it’s time to relax and to bring you my review of the Top 5 iPhone word games of all time. In my quest I’ve come across some awful games and some that just didn’t quite make...
Read more »