by admin | Jul 20, 2020 | Case Studies - How To
I recently had a scenario where I had a customer who needed to capture timesheet data from her employees. She had been doing it manually up until then, chasing people for hours in the last minutes before doing a pay run. She decided to use Microsoft Forms to capture...
by admin | Jul 8, 2020 | Excel Path - Step by Step
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 | Personal
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 | Tracking Training Records in Excel
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 | Tracking Training Records in Excel
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...
