by admin | Oct 19, 2020 | Excel | General
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 | Oct 12, 2020 | Excel | General
Quite often I get people asking me how to do X or Y and this video addresses how Excel would be used to identify what is early, late and on time – assuming a 10 day buffer (either side). I am using this to experiment with the IFS function ( a new function in...
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...
