by admin | Aug 10, 2020 | Excel | General
When I had finished helping the user get set up with her data set – which is now working away merrily and taking her minutes instead of hours, I found myself wondering was there a way to automate it even further. When I asked in my network, the most common...
by admin | Jul 27, 2020 | Excel | General
Last week I showed you how to set up a Form in MS Forms. I hope you have come down from the excitement of all that (!) and are now ready for Phase Two.. A – Getting your data into Excel and cleaning it upB – Constructing a pivot table to summarize the...
by admin | Jul 20, 2020 | Excel | General
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 13, 2020 | Excel | General
In many organisations, users have to contend with reports and forms that were designed – literally – in the last century. I was recently asked to help a user with one of these. In the attached file you will see what it looked like at the beginning (see...
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...
