by admin | Sep 26, 2020 | Excel | General
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 | Excel | General
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 | Excel | General
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 | Excel | General
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 | 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...
