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...
by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively.. You can view Part one here (Steps one to three) Just a reminder about what deferred income...
by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively, but that will be for another post…:-) There are seven steps in this so I have published...
by admin | Mar 14, 2018 | Excel | General
So one of the questions that comes up when I am helping customers with this is how do you calculate what percentage of your staff are compliant. In this scenario, I have set up 16 employees who each have to do a Health and Safety and Induction course. Some of them...
