NHS Excel

I’ve just spent 2 hours with our DBA trying to force SQL to apply the 80/20 rule to a massive data source. I’m so pleased with the result that I have to write it up as a tutorial even though...

sql-server

I’ve just inherited a monthly finance timetable that provides a series of working day deadlines for each month of the year. The way it has been set up requires quite a bit of manual adjustment to ensure that bank holidays...

function dates eomonth workday

In this post I’ll demonstrate how to generate annual growth rates based on historic linear trends. It effectively adds the % annual growth rate to a linear trendline produced on an excel chart.

charts

This is a fantastic little macro that I picked up from The Spreadsheet Guru

macro tips iferror

How many times have you had to set up a custom format to show a negative cell value in red font with brackets?

tips custom-formats styles