This post is about a common business problem of grabbing messy data from a transactional document and updating a data set to collect history. So in this post we will use VBA arrays to gather messy data ie consolidate it. In my previous life, I was in Commodity Export Marketing, so I am using the […]
Use VBA Arrays to gather messy data Read More »
So this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system. See here for Part A. This example concerns automating entries on your bank statement you can reliably identify. In my case it was to record bank transfers from my cheque account to an interest
I have been putting off blogging about this topic because it’s unwieldy to explain and involves work done many years ago that I would do better now. I cringe a bit seeing an Offset formula now which I would only use these days as a last resort because it’s volatile. But let’s see if it
Using Excel Templates to upload to an accounting software – Part A The Cash Book Read More »
What does Excel Consulting mean? Sometimes people who have a ‘real job’ and don’t work at a computer all day and know how to use a nail gun and an angle grinder ask, what do you do for a living mate? If I say financial modelling, I get a really odd look like they didn’t
Excel Consulting. What Do You Do for a Living mate? Read More »