Excel tips, tricks and tutorials for healthcare professionals.
You can use this ramp up trick to apply a phasing profile to planned expenditure but I am illustrating it here to model the monthly delivery of planned savings. In the NHS we tend to refer to savings as either...
Excel offers the option to insert a series of trendlines on your charts.
I’m moving to pastures new and will be leaving behind a well-loved SQL Server database, complete with a rich array of patient level data. At my new job I will likely have to make do with an Access database and...
It seems that each NHS planning round inspires me to produce yet another Excel Bridge template.
I regularly need to set up new tables in my SQL Server Database from data held externally as either text or csv. It sounds like an incredibly straightforward task but always sends me scurrying off to google for advice on...