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.
If you need to enter a date in a formula you typically use the DATE function to create the date. You can enter the date as Text and Excel will convert it for you.
A recent update to Excel has made a major improvement to Excel PivotTables.
Its the first week of 2025 and I just built my first pivot of the year AND the number format from the source data was applied to the PivotTable – WOOHOO!
I did a short video showing the new feature in action.
This made me more excited than it should. You can update a setting in Excel Options to change the Excel interface to use English UK spelling which is also Australian spelling. So, Center becomes Centre, and Customize becomes Customise – woohoo!
Stories are how we learn best. We absorb numbers and facts and details, but we keep them all glued together into our heads with stories.