Monthly Archives: May 2019

Unstack data across columns with #Excel Pivot Table

Posted on May 29, 2019 by

Another commonly seen problem in daily work.  Many hours are spent on reshaping data, we all know that.  Nevertheless, if you are good in Excel, doing this task is not difficult at all.   Indeed, there are many ways to solve … Continue reading →

Rate this:

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

Waterfall chart is just a few clicks away with #Excel 2016

Posted on May 18, 2019 by

Did you know, you can plot a Waterfall chart in #Excel in less than a minute…Provided that you are using Excel 2016 or later! 🙂 No Kidding! You may download a Sample File to follow along.

Rate this:

Posted in Chart | Tagged , , | Leave a comment

Split cell contents separated by line feed into rows with #Excel #PowerQuery – Part 2

Posted on May 13, 2019 by

Last week, I showed you how to split cell contents separated by line feed into rows with Power Query.  That was easy when we are dealing with only one column.  If you don’t know how, you may read the post … Continue reading →

Rate this:

Posted in Excel in Action, Power Query | Tagged , | 5 Comments

Free Excel Dashboard Webinars by Mynda Treacy

Posted on May 11, 2019 by

If you’ve ever felt like: “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s the point?” “If I … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Split cell contents separated by line feed into rows with #Excel #PowerQuery

Posted on May 4, 2019 by

After an in-house training, a colleague came to me and asked if there is a way to do the following: The problem here is the contents in cells are separated by a line feed (line break).  A cell may contain … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Identify missing files in a folder with Power Query

Posted on May 1, 2019 by

It is a common task to compare two lists in Excel.  This can be achieved with MATCH function.  But what if you want to compare a list of filenames stored in your spreadsheet, with the files you’ve got in a … Continue reading →

Rate this:

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