by admin | Mar 3, 2020 | Excel | General
This year I have been inspired by Gretchen Rubin and her sister Elizabeth Craft to try out a strategy called 20 for 2020. The idea behind this is simple, pick 20 things that you would like to do/work on and commit to doing them for the year. So the 20 I have picked...
by admin | Jul 12, 2019 | Training Records Management
A follow up question I have received a lot is about what to do if you have once off records, expired records etc. So in this video I have addressed this issue. There’s a quick revision of how you use the vlookup() function to calculate expiry dates but the main...
by admin | Apr 16, 2019 | Excel | General, Training Records Management
A question I get asked a lot on this website is about how to create expiry dates for different courses in Excel. So here is a video that shows you how to do it. It does require that you have a list of courses with their duration in days e.g. a course...
by admin | Nov 1, 2018 | Excel | General, Training Records Management
A while back I was working with a company and one of the issues that came up was how to track if managers had completed their monthly one to one meetings with their staff. They needed to see who had completed them and who hadn’t. The issue was that while they...
by admin | Sep 26, 2018 | Excel | General
This year I attended a conference about John O Donohue , an Irish philosopher/mystic/poet who died in his early 50s. At that conference a friend of his called Dr Dan Siegel talked about how quantum physics and mysticism were now converging and discovering what they...
