How to use Python in Excel for sentiment analysis
Excel's core strength is working with numbers. And we love how it makes our data work more efficiently. However, what happens when the data is words? Python in Excel closes that gap, allowing yo...
1 Okt 8min
Create interactive Excel charts (part 2)
Can you make Excel reporting more interactive? Yes, you can. And it's all to do with dynamic arrays. In the second of this two-part series, discover how to create dynamic Excel charts this time usin...
1 Sep 8min
Create interactive Excel charts
Wouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays? This expert-led episode introduces the core techniques behind fle...
3 Aug 7min
How to create accounting reports with DAX
From trial balances to profit and loss statements, reporting sits at the centre of modern finance. This episode explores how finance professionals can use DAX (Data Analysis Expressions) formulas a...
1 Juli 9min
Why Excel macros still matter in 2026
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
Template tips to boost workflows
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
Increment dates easily in Excel
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
Master your messy data
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
