Monthly Archives: August 2020

#Excel #PowerQuery Challenge – Add value to CSV data in cells

Posted on August 30, 2020 by MF

As always, a picture tells thousand words. The above image explains clearly what we want to achieve, with Power Query in Excel of course. This problem was bought to my attention when I watched the Dueling Excel Podcast #192 by … Continue reading →

Rate this:

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

Learn how to build effective #Excel Dashboard from Mynda Treacy

Posted on August 15, 2020 by MF

Did you know… you can create such a beautiful dashboard using Excel? Did you also know… this visually appealing dashboard was built in just more than 30 minutes? No kidding! Check it out HERE and you will see. Want to … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Combine all visible worksheets from multiple #Excel files in a folder

Posted on August 11, 2020 by MF

It is a common task for us to combine all worksheets in a workbook. It could be a time consuming task without Power Query. With Power Query, it’s piece of cake. 😁 Wait? What about if you want to combine … Continue reading →

Rate this:

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