My blog
My Blog page’s theme is to produce practical blog posts from my Excel consulting with large and small business clients from varied industries. These topics include spreadsheet design, choosing a sound approach to an Excel based solution, learning from mistakes, VBA programing (or macros), Tables, Pivot Charts, Pivot Tables, advanced formulas, Pivot Query, PowerPivot, Excel User Forms, Excel data cleaning and manipulation, conditional formatting, user friendly features and more.
Hope you find them useful 🙂
For those new to workbooks with macros
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
Great article on VBA efficiency
I don’t often re-post, but hard not to with this really good post from Kevin Roper of the Society of Actuaries on Excel VBA speed and efficiency Well worth the
Come Excel humour, stand up comedian Matt Parker on Excel spreadsheeting
If you are up for a bit of Excel humour, you may enjoy this YouTube from Matt Parket’s stand up routine on Excel spreadsheeting
Personal Macros – Locked & Unlocked cells
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
Watch great videos on what’s new in the Excel world from Microsoft’s Ignite 2018 Seminar
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
Kanban Tool for Excel project management
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
Finding Potential Pivot Table Collisions
Pivot Tables collisions or can be a real problem. A meeting is coming up in a few minutes and suddenly your beautifully crafted Pivot Table dashboard report that’s been working
Are guys really using Excel for this? Some weird Excel usage.
Talk about some weird Excel usage. I was enjoying my coffee this cold winter’s morning, reading my nerdy ipad edition of The Australian newspaper and there was this article! Read
Macro to fix Duplicated Conditional Formatting rules in Tables
Note this only works for Tables. One day I will adapt this code for a 2nd macro to work with a specified range. Following on from my recent post of
Alternatives to Conditional Formatting
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
Fix duplicated Conditional Formatting Rules
Have you ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into? This is what I mean by the term, duplicated Conditional
Use the macro recorder for VBA code for a relative formula
I did this very thing today, so thought I would share this tip with you as it saved me a lot of time. Say you wanted to have this formula
