by admin | Sep 13, 2021 | Case Studies - How To
Last week I showed you how to set up your payment journal in a way that would allow you to both track the total amount and break it down across different categories and VAT Amounts. You can check that blog post here.. In this week’s blog post I look at how you...
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 | Jun 21, 2021 | Excel Path - Step by Step
In this tutorial what I am looking at is the alternative to Vlookup() – Index/Match which is – astonishingly enough – a combination of two functions: Index and Match. I give an explanation of Match in this tutorial as well. You can download the...
