Excel Tips

In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance and accounting professionals. Listeners will learn: How ...

1 Okt 202513min

In this third and final episode of a three-part series, we explore how the integration of Python unlocks advanced tools for analysis, automation and visualisation. Listeners will learn: How Py...

1 Sep 20259min

In this second episode of a three-part series, you will build on the basics from part one to gain a clear understanding of how to use Python directly within Excel cells. This includes using the Pa...

1 Aug 202511min

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