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...
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...
15 Mar 2026
Got data spread across multiple sheets that needs summarising with a Pivot Table? In this tutorial, I’ll show you the simplest method to combine data from multiple sheets in Excel 365 and turn it into a dynamic, fully interactive pivot table. All without Power...
22 Feb 2026
Creating a Pivot Chart in Excel should be quick but Excel insists on adding field buttons, a legend you don’t need, and a generic “Total” title. In this video, I’ll show you how to remove Pivot Chart buttons and legends and then turn the amended chart into a template...
