Tag: Power Query

How to extract tables from Powerpoint using just Power Query
How to extract tables from Powerpoint using just Power Query
Blog Posts

I’ve been using my solution to extract tables from Powerpoint a lot recently.  However, I’ve come across some situations where what looks like a table is actually an embedded Excel worksheet. This can be quite useful in Powerpoint as it provides the ability to create subtotals and apply other formulae. You can add these sort of… READ MORE

Bar-Mekko chart in Excel with Power Query
Bar-Mekko chart in Excel with Power Query
Blog Posts

Seems, Excel charts is an area that till now wasn’t considered in blogs as a target for Power Query application (Get & Transform in Excel 2016). Nevertheless, PQ can replace some VBA solutions and make your workbooks macro-free. In far 2015 my colleague Zoltán Kaszaki-Krsjak shared with me a very good example of how Power… READ MORE