Monthly Archives: June 2019

Excel Magic in One Minute

Posted on June 15, 2019 by

Last Friday was a public holiday in Hong Kong.  Yes, a long weekend!  Guess what I dd over the long weekend?  I’ve created a playlist – “Excel Magic in One Minute” on my YouTube Channel. The name says it all … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Apply Conditional Format for alternate row color based on groups…

Posted on June 8, 2019 by

…that works even when filter is applied. The situation: We have a table that we would like to apply color banding based on groups.  We can achieve this by inserting a helper column to identify the sequence of each group, … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | Leave a comment

Unstack uneven data across columns with #Excel #PowerQuery

Posted on June 5, 2019 by

This is a continuation of the previous post, in which I showed you how to unstack two columns of data by using Pivot Table as a helper, and together with a couple of excel tricks.  As mentioned, that approach is only … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment