by admin | Jul 27, 2020 | Case Studies - How To
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 | 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 | Jun 18, 2018 | Case Studies - How To
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 | Case Studies - How To
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 1, 2018 | Case Studies - How To
Recently I got asked by a colleague to help her identify compare two lists of providers in Excel. In one list there was a list of providers available in May. In the other she had a list of providers available in January. She wanted to identify what providers were in...
by admin | Jul 24, 2017 | Case Studies - How To
In a class recently the subject of age calculation came up, which reminds me of when my son was young and would ask me how old I was. “19”, I would say succinctly. He was at the age when he was learning basic maths. “So what would make you 12 when...
