Monthly Archives: June 2019

Send a cell content to Google search

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

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

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…

…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

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