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.
Tag Archives: data cleansing
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 Query
10/10
Really enjoyed this webinar – the conversion of MYOB style reports is such a useful tool to know.
C Stevenson
January 2025
Introduction to Power Query
10/10
Terrific session – very clear and concise and very useful information. The explanation of the meaning of town names in WA was a bonus!
A Roberts
January 2025
You can download the materials for the session using the button below the video.
Get the Sign Right in Excel
Get the ABS you deserve
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.