by admin | Jul 8, 2020 | Excel | General
Many years ago when my son was small and loved a certain purple dinosaur, there was also a smaller dinosaur called BabyBop who had a comfort blankie that he carried around at all times. You can remind yourself about it here. Excel has one of those – it’s...
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...
