Excel tips, tricks and tutorials for healthcare professionals.
NHS Excel - tips and tricks
A while ago I published a post that demonstrated how to use a macro to generate multiple pdf files for distribution, by working through a filtered list. I’ve recently acquired a macro solution to do something similar but in this...
A clinician recently asked me to explain how Acute Kidney Injury (his particular area of interest) impacted on the Trusts income position. Given that Acute Kidney Injury (AKI) rarely occurs in isolation, and from our Trust’s experience appears as a...
I recently wrote a post on the excelpivots site showing how you can use pivot tables to compare data without resorting to the inferior VLOOKUP method.
Catchy title I think you’ll agree - GETPIVOTDATA click bait if ever I saw it…
Here’s my second SQL server tutorial of the week, this time demonstrating how to import csv files into SQL tables, I may have to change the name of the blog at this rate.