by admin | Oct 19, 2020 | Case Studies - How To
Ah, the Vlookup() – the staple of data linking since Excel was a child – 40 years ago…I’ve done a tutorial on it here but I want to explore how to make it more flexible . Let’s say you have a scenario where you need to pull in data and...
by admin | Sep 26, 2020 | Case Studies - How To
Recently I have been working with a group around using Excel for Accounts. Now let me be completely upfront here first. I personally do not use Excel for my accounts. I use QuickBooks and have done so since I set up in business in the mid-nineties. That’s what...
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...
