Tag: Tables

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 »

Tagged with: , , , , ,

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 »

Tagged with: , , , , , , ,

A few years ago I picked up on this gem of a tip of Dick Kusleika in his blog at his The Daily Dose of Excel site on using the Table Name prefix of “tbl”.  If you are not dropping …

Using a Table Name prefix for productivity Read More »

Tagged with: , , , ,

Well it’s the Boxing Day holiday here in Aussieland and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day.  Fantastic stuff.  But also, this is the time of the year to think …

Make Using Tables your New Year’s Resolution Read More »

Tagged with: , , , , , ,

In past posts I have talked about a ‘database’ approach or how an Excel  data analyst approaches data in their spreadsheeting or financial modelling.  Anyone from an IT background would say of course.  But I came from an accounting and …

Organise data like an Excel Analyst Read More »

Tagged with: , , , , ,

This is general post for anyone out there not using Pivot Tables.  You need to!  I am also going to do a similar post shortly for anyone not using Tables as well.  I think both tools are just so very …

Learning to use Pivot Tables Read More »

Tagged with: , , , ,