by admin | Jan 31, 2022 | Case Studies - How To
In this video we are going to identify how to use Excel to identify waiting times. Some people have an appointment and others do not – they have a disappointment. I’m sorry but that makes me laugh. EVERY. SINGLE. TIME. Truly sad and pathetic I know…...
by admin | Jan 24, 2022 | Case Studies - How To
Many non-profits use Excel to track their finances. In this blog post I am going to use some sample data to show how you could capture a single payment – that often has to be allocated across multiple projects and/or expenses. You can download the original file...
by admin | Dec 14, 2021 | Case Studies - How To
Data cleansing is really the rubbish collection of Excel. It is not really anyone’s favourite job but if you want to get all those charts and pivot tables working properly – it all has to be done. It is somewhat similar to those cookery programmes where...
by admin | Oct 26, 2021 | Case Studies - How To
I was recently asked in a class about comparing two spreadsheets – as you can in Word. I hadn’t heard of anything but guess what – as with so many Microsoft products – turns out that there was a tool to do that..called Spreadsheet Compare. The...
by admin | Sep 21, 2021 | Case Studies - How To
So this is part three of a series of posts I am doing on creating a simple accounting system. Just a gentle reminder that if you think your business could grow – I would really recommend that you look at investing time and money into an actual accounting...
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...
