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 »

If you have ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into, I hope the following post helps you.  Basically this situation arises as you go about day to day coping …

Fix duplicated Conditional Formatting Rules Read More »

I did this very thing today, so thought I would share this tip with you as it saves me a lot of time.   Say you wanted to have this formula go into column 8 of the range you created in …

Entering a relative formula in VBA using the macro recorder Read More »

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 »

I talk a lot about Excel automation.  Automating with Excel helps us be more productive and efficient in our jobs.  Automating tedious tasks using advanced Excel features like Tables, Pivot Tables, Power Query, VBA or macros. The benefits are many …

My First PowerApp Read More »

It’s good to check out how Google Sheets are doing every now and then.  In my view, it just isn’t as powerful a tool as Excel.  Not sure how to say this better because I am not writing it off …

Google Sheets and Google Forms Read More »

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown …

Autocomplete Workaround for Validation Dropdowns Read More »

I have been having a 1st World problem.  For as long as I can remember, I create a new worksheet and the default cell vertical alignment is set to bottom which I hate.  There it is.  It’s no more than …

Rediscovering templates for new workbooks and worksheets Read More »

My last blog was on accessing personal macros from my custom ribbon. This blog is about where to store these personal macros.  These personal macros are the ones that save you time and tedious work.  There are basically two ways …

Personal Macros – Personal.xlsb or Add-In.xlam? Read More »

I recently finished a pet project of creating a custom ribbon in XML driven by an Add-In to access my personal macros.   These are the ones you collect over the years and use in your day to day work  to …

My Custom Ribbon using Formulas to Create XML code Read More »

I recently worked on a project that had three distinct and large datasets for different geographical areas in three workbooks.  Starting with the first workbook and dataset in a Table in its own worksheet, I created a worksheet of seven …

VBA to Change Pivot Table Source Read More »

Last week I implemented Pivot Charts for a client with three very large data sets, one of which was 30K rows and the other two being > 10K rows.  There was one obvious outlier skewing one of the charts but …

Tip for excluding Outlier data in Pivot Charts Read More »