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:

Update 11/08/21 Well two interesting recent developments have occurred regarding this post! Microsoft MVP Rick Rothstein kindly contacted me about much more elegant code than I have below trying to assign 6 table columns to a range variable so the …

Check range for specific characters – Customizing the Ribbon 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: