Why spend an hour when one formula can do it in seconds?

Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday ...

There is a common mistake that people who have learned Power Query tend to make: trying to do everything with Power Query. Power Query is not a panacea. It is important to understand what it excels at ...

At 49, I taught myself Power Query. As a member of the employment ice age generation, I started in non-regular employment and, after changing jobs nine times, I joined a foreign-affiliated IT company.

This article is not about ethics, privacy, security, ownership, or corporate governance — I am going to circumvent all of this here by using some made-up data relating to supermarket sales: Here, I ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...