How to add a user interaction into Power Query

Excel macros are far from obsolete. And here's why.  This episode explores why VBAs (Visual Basic for Applications) still play an important role in workflow efficiency for accountants and finance pr...

1 Juni 9min

Most finance professionals have made this mistake at least once.  You open last month's file, update the numbers, hit save, and only then realise you should have saved it as this month's version of ...

1 Maj 7min

What if you could simplify Excel date calculations with one powerful custom function?  Well, this episode explains how.  You'll learn:  How to handle different date increments including days, ...

1 Apr 7min

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 Mars 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 Feb 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 Jan 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 Dec 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 Nov 20258min