Unlock 7 underused Excel features you still need today
Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows. Smart power users know these older functions and their value – which is why...
1 Joulu 202516min
How to simplify complex calculations with custom functions
Did you know that you can transform the way you can build models, reports and schedules with custom functions? This episode guides you on how they make complex calculations cleaner and easier to ma...
3 Marras 20258min
Smarter, faster, easier: Here's what's new in Excel
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 Loka 202513min
Unleash the power of Python in Excel
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 Syys 20259min
Python in Excel: Practical applications
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 Elo 202511min
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 Heinä 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 Kesä 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 Touko 202512min
