Category: Data Cleaning

I do data cleaning day in day out.  We all do.  This technique from Leila Gharani on You Tube is just so awesomely simple and effective you just wonder why you haven’t thought of this before.   It works on the …

Really good, simple data cleaning technique from Leila Gharani Read More »

Tagged with:

If you are working with output from other systems (or preparing input for other systems) you might need to find certain characters that cause problems.  In my case I was creating XML code for a custom ribbon from Excel formulas …

Check range for specific characters Read More »

Tagged with: , , , , ,

OK 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.  …

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries Read More »

Tagged with: , ,

Further to my recent post Business Model Renovation below is one of my ‘quick and dirty’ but handy and versatile macros I used in this project. It has been written this way because as I made changes to formulas in …

Business Model Renovation – Macros Read More »

Tagged with: , , , , , ,

This blog post is about how I approached a major job I took on about two and a half years ago in doing major alterations to a crucial, complex, legacy spreadsheet for a large Brisbane based company with 16 entities …

Business Model ‘Renovation’ Read More »

Tagged with: