14 Jun 2026
If you’re a regular viewer of my videos you’ll have heard me talk about Dynamic Arrays. It’s something I cover frequently. However I’ve had a few people contact me who like my videos but don’t really understand what Dynamic Arrays are, even though they’ve been a part...
31 May 2026
If you’ve ever needed to generate a sample dataset in Excel quickly for example fake sales data, financial records, employee data, or something completely custom, this video shows you exactly how to do it using AI. In the video I use Claude to build two datasets...
3 May 2026
Did you know you can use emojis in Excel on a Mac? It’s easier than you think and once you know how, you’ll find all sorts of ways to make your spreadsheets more visual, clearer, and a lot more engaging to look at. In this video, I’ll show you how to...
29 Mar 2026
There are several ways that you can create a running total in Excel and in this video I show 2 methods. One method works with any version of Excel. The second method, which is much simpler, uses the SCAN function and is only available to 365 subscribers. Watch on...
22 Mar 2026
In this video, I’ll show you how to combine multiple columns into a single column in Excel 365 without copying and pasting. If you’ve ever worked with data spread across several columns (emails, survey responses, contact lists or exports from other systems), you’ll...
