Using Forms to capture data for analysis – Part One

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...

Meet IFError() – the blankie function of Excel

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...

My 20 for 2020

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...