by admin | Nov 30, 2020 | Tracking Training Records in Excel
A while back one of my customers asked me about a way to create a unique ID from a customer’s name and a random number. Of course I was intrigued and using a combination of Left(), Right() and Randbetween() helped her do just that. Yum, I do love me an Excel...
by admin | Nov 2, 2020 | Case Studies - How To
A question that comes up from time to time is how to get your PDF data into Excel. There are of course many online options to do so – just do a quick Google for “convert PDF to Excel” . However in this tutorial and video I want to show you how you...
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 | Oct 12, 2020 | Tracking Training Records in Excel
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 | 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...
