We recently put solar panels on our roof and so I have become interested in solar energy and how it all works.  If anything lends itself to being set out in a spreadsheet or financial model it is this.  I …

Household Solar Energy Spreadsheet Read More »

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 »

Here is a quick but really useful coffee break tip. I used this handy INDEX + MATCH based formula the other day and thought it was a good one to share… Say you have this typical accounting situation where you …

Dynamic sum formula for summing between two dynamic columns Read More »

If you are new to workbooks with macros here is a short 2 min video on the quick setup needed to work with them on your PC’s Excel and some basic points to be aware of…  

I don’t often re-post, but hard not to with this really good post on Excel VBA speed and efficiency  Well worth the read. https://www.soa.org/news-and-publications/newsletters/compact/2012/january/com-2012-iss42/excel-vba-speed-and-efficiency/

I hope you enjoy this YouTube from Matt Parket’s stand up routine on Excel spreadsheeting

This is another handy personal macro I use in my day to day spreadsheeting and application building.  It sits in my Add-In which has it’s own tab on my custom ribbon, but you might just use the ribbon QAT or …

Personal Macros – Locked & Unlocked cells Read More »

Want to sit in on a world class Excel seminar?  Microsoft has a fantastic seminar Microsoft Ignite for tech professionals including Excel Pros, the most recent was held just over a month ago in Orlando U.S. Sept 24-28 2018.  You …

Watch great videos on what’s new in the Excel world from Microsoft’s Ignite 2018 Seminar Read More »

This blog is about a really great tool I discovered to use for client Excel work, called Kanban Tool.  For significant projects like anyone else I need to plan how I should develop a spreadsheet and keep track of all …

Kanban Tool for Excel project management Read More »

Was enjoying my coffee this cold winter’s morning, reading my nerdy ipad edition of  The Australian newspaper and there was this article!   Read the first paragraph!  No way!  If there are men out there using my beloved Excel for that …

Are guys really using Excel for this? Read More »

Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated and messy Conditional Formatting.  I tweeked this code just a bit so that all …

Macro to fix Duplicate Conditional Formatting rules in Tables Read More »

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance.  …

Alternatives to Conditional Formatting Read More »