by admin | Dec 21, 2022 | Personal
Failures and disappointments.. I have tried for the last couple of years to really lose weight – I have failed dismally. After two years of trying – doing all the right things, tracking food, walking regularly – something in me snapped and I stopped...
by admin | Nov 16, 2022 | Excel | General
This blog post was inspired by a recent dilemma. My wonderful VA – Zita Lewis – who helps ensure that all my course participants get what they need when they need it and quite frankly has much better attention to detail than I have 🙂 had got a list of...
by admin | Nov 10, 2022 | Excel | General
Power Query (AKA Get and Tranform) is Excel’s amazing data cleansing tool. You can use it to remove unwanted spaces in your data but I have noticed that sometimes it doesn’t remove everything that you would expect. This video shows you a technique you can...
by admin | Jul 27, 2022 | Personal
For the last couple of years I have gone into Low Power Mode for the Tour de France – which is three weeks in July. Essentially I don’t do any training but I still respond to emails a couple of times a week etc. I watch it on TG4 where two fans basically...
by admin | May 14, 2022 | Excel | General
One issue that can come up in adding up lists with subtotals and hidden rows is that the usual sum() will exclude hidden rows from your calculations. Equally if you have subtotals – you often don’t want those included in your calculations… So...