How to create vertical lines in line charts

Messy, unstructured data.  It slows reporting, creates errors, and tests everyone's patience. Right?  This episode breaks down how the new Regular Expressions (REGEX) work and how they help you fi...

2 Maalis 6min

You may know The Seven Habits of Highly Effective People as a cornerstone of modern business thinking.  But what happens when those same principles from this book are applied to one of the most wide...

2 Helmi 12min

Excel Tips Summer Season Encore presentation from October 2025 In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance...

1 Tammi 14min

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

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

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

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

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