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 | Nov 8, 2021 | Excel | General
Often when we get data it’s done in the format as seen below However quite often we need it to be organised differently – for example if I want to set this up to be able to calculate the monthly total for each product in a pivot table – not...
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 | Oct 18, 2021 | Excel Path - Step by Step
I was recently asked in a class about grouping entries together. In that case it was fish lengths but what I show here applies to a wide range of options. The first method shows you how to use the inbuilt facilities of Excel pivot tables to group numbers into...
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...
