by admin | Sep 6, 2021 | Case Studies - How To
In some recent training I did I showed the participants a template I had created to allow a small business to track their expenditure. If I am really honest I’d actually recommend that if you are self-employed or running a business – a better investment...
by admin | Aug 30, 2021 | Case Studies - How To
This scenario came from a recent dilemma a customer had. They got basically the same CSV file every month from a customer but they wanted to have an ongoing summary of it. Of course they could always have done copy and paste – Ye Olde Reliable...
by admin | Aug 21, 2021 | Case Studies - How To
Another Judge Judy entry – “real cases real people” although the numbers are fake – sorry to disappoint you there… In this one I show you how to combine using the SUMIFS function with a slightly trickier function called INDIRECT to...
by admin | May 31, 2021 | Case Studies - How To
I was recently asked by a friend to help her identify who were the top three contributors in a project – based on Page Views and Participation. She also wanted to get some idea of frequency of contribution.. You can download the original (anonymised) file...
by admin | May 6, 2021 | Case Studies - How To
In this tutorial I am going to show you how to calculate the difference in hours/days/working days between two sets of dates. Put away our calendar/s and learn how to use these formulas instead. You can download the completed file here You can view the video...
by admin | May 3, 2021 | Case Studies - How To
I was recently asked by a participant in a class for some help with analysing case time duration – basically what was the average time duration from the opening of a support case to it being closed off and what time band it fell into. This required the use of...
