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…
Excel Day Type Custom Function
Let’s say you need to classify a series of dates as either Weekday, Weekend or Holiday. Here’s a formula and a custom function you can try.
(more…)Using Text Dates in Excel
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.
(more…)Excel PivotTable Formats
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. https://vimeo.com/1044630953
Change Excel’s Language
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!
(more…)