Monthly Archives: June 2019

Send a cell content to Google search

Posted on June 29, 2019 by

This is a continuation of previous post, in which I talked about the potential use of Smart Lookup for an Excel  dashboard.  However there is limitation.  It drove me to think of an alternative. Instead of asking user to trigger Smart … Continue reading →

Rate this:

Posted in Formula | Tagged | Leave a comment

Smart Lookup in #Excel 2016 or later

Posted on June 22, 2019 by

Have your heard of Smart Lookup?  Don’t confuse it with Excel Functions.  It is nothing related to formula writing in Excel.  Simply consider it is a web search engine (Bing) embedded in Excel. Watch it in action, and you will … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

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