Excel tips, tricks and tutorials for healthcare professionals.
I 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...
When you first start to dabble with macros and VBA, one of the first challenges you will face is fathoming out what to do with the personal macro workbook.
It’s Operating Plan time at work again, and that means long term financial models and bridge diagrams to show the causes of movement between years. I’ve previosuly written about Excel waterfall charts and I had to refer to my own...
Excel offers a number of conditional IF functions such as COUNTIF and SUMIF which allow you to count or sum a range based on the values in another column. If you have Excel 2007 or later you’ll have the really...
Chandoo published a useful tip recently for revealing the contents of hidden cells. Anyone who works in the NHS and ever has to deal with excel spreadsheets that originate for the DH will be very familiar with the frustration of...