The greatest sign of success for a teacher is to be able to say, “The children are now working as if I did not exist.” But this holds true for leadership in general—give people space and they flourish.
Maria Montessori
Source: The Montessori Method (1912)
Excel has a built-in Template that can generate a QR code – see how to access it.
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.
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.
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.
Chris Brogan