Power Query Merge
Merging in Power Query is a useful feature that automates and replaces XLOOKUP functions. But please make sure the look up table doesn’t have duplicates.
(more…)Extracting Data from the Web with Power Query
Power Query can import table-based data direct from the web. As an example, we can extract the public holiday dates for Western Australia from the WA government website. This process is sometimes called web scraping.
(more…)Introduction to Power Query 2025
In January 2025 I ran a free webinar on Power Query - the best way to import data into Excel. 170 attended and over 100 people provided feedback with an average score of 92%. Some of the feedback is shown below. Introduction to Power Query10/10Really enjoyed this webinar - the conversion of MYOB style reports is such a useful tool to know.C StevensonJanuary 2025 Introduction to Power Query10/10Terrific session - very clear and concise and very useful information. The explanation…
Get the Sign Right in Excel
I was recently working with some data that had some issues with the sign on the quantities. The quantities should have had the same sign as the associated dollar amount, but they didn’t. Here is how I fixed it.
(more…)