by admin | Feb 14, 2023 | Excel Path - Step by Step
How to link external files into an Excel file and then change if required A common requirement is to pull data from one Excel file into another. You should begin by setting the scene. i.e. make sure you have all the files you need open. Let’s call those source...
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...
