How to automate report building in Excel

Unlock the potential of Python in Excel with this essential first episode in a three-part series. Designed for accountants, finance professionals and Excel power users, this episode introduces the...

1 Jul 20259min

Excel's new functions, GROUPBY and PIVOTBY, offer a smarter way to build reports. Instead of relying on traditional pivot tables, these new tools allow you to summarise datasets using dynamic, for...

2 Jun 202512min

Need to turn stock market data into smart, professional reports? Discover how to use Excel's new and powerful Stock History function to quickly transform raw share price data into clear, insightful re...

1 Mai 202512min

The Pareto principle is a powerful concept for business. In this episode we'll explore this principle (also known as the 80/20 rule) and learn how to apply it effectively in Excel for smarter, da...

31 Mar 202510min

What if you could seamlessly collect and analyse data right inside Excel? In this episode, learn more about Microsoft Forms, a powerful tool in Microsoft 365 (which, by the time you read this may ...

3 Mar 202510min

Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you'll discover the power of checkboxes with practical examples to explore how this new function can streamline y...

2 Feb 202510min

Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occurrence. To help you, this episode explores Micro...

2 Jan 202512min

Excel doesn't have a built-in timeline chart but we'll show you how to create one. In this episode you'll learn how using a scatter chart can help you build a timeline chart. For easy reference, here ...

1 Des 202410min