by admin | Aug 31, 2020 | Case Studies - How To
Formulas, formulas, formulas – everyone’s favourite Excel topic. In this table I have identified a number of FAQs and I have put together a table to help you decide what feature to use when… ScenarioFormula/FunctionPull in missing data from somewhere...
by admin | Aug 24, 2020 | Case Studies - How To
As a follow on from the Part One part of this blog post this week we are going to look at how to show the longest wait by age bracket. You can download the file...
by admin | Aug 17, 2020 | Case Studies - How To
A few months ago, I was asked by someone on my mailing list to help her set up a spreadsheet to help track her waiting list. She had to submit monthly metrics showing the number of patients by age and number of weeks they had been waiting. One way to do this is by...
by admin | Aug 10, 2020 | Case Studies - How To
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 | 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...
