Select Page

Compare Tables in Excel & Power BI

Do you often find yourself in dire need to compare two tables in Excel? In today’s blog post, we will create an Excel workbook that compares two tables, and highlights the changes in a third table. You can load new versions of the tables, click Refresh All in Excel,...

Understanding Power Query Combine

Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data).  The new capability makes it easier to combine multiple copies of similar workbooks into a single table without...

Podcast with John Michaloudis!

Awhile back I recorded a podcast with John Michaloudis from MyExcelOnline and it went live today.  Fun chat, lots of excitement. We talk about all of the “beautiful accidents” which led me to where I am today.  We talk about… The post Podcast with John Michaloudis!...