Monthly Archives: May 2020

Insert blank columns to table in #PowerBI Desktop

In Excel, it is a common (but not necessarily a good) practice for people to add a thin blank column in a table to give a visual effect of divider.  Like the screenshot below: To insert a blank column in … Continue reading

Rate this:

Posted in Power BI Desktop | Tagged , , | 6 Comments

More #Excel videos with English Voice Over…

Well… I know I know, I haven’t written new posts for a while.  I was lazy in previous weeks; enjoying summer breezes.  You know what, if I were not doing Excel on weekends, I would probably have been enjoying hiking … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

Split date ranges from cells with #Excel #PowerQuery

Take a look at the challenge presented above.  Is it possible to do it in Excel? Be honest, without Power Query, I have no idea how to do it but manual work. 😁🤦‍♂️ Believe it or not, with Power Query, … Continue reading

Rate this:

Posted in Power Query | Tagged , , , | Leave a comment

Replace blanks with zero in #Excel

Following the techniques used in the previous post , we can perform many Excel magics for different scenarios.  On top of my mind is to replace blank cells with zero.   The first task is to select all blank cells in … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment