Getting started with Python 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 GROUPBY and PIVOTBY explained
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
Better share price reports with Excel's new tool
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
Elevate your Pareto analysis skills with Excel
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
Unlock the power of Microsoft Forms in Excel
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
New tool explained: boost your efficiency with checkboxes
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
Improve your PDF data handling with Power Query
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
Handy hack to create timeline charts
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
