Excel Tips
Episodes
Unlock 7 underused Excel features you still need today
01 Dec 2025
Contributed by Lukas
Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows. Smart power use...
How to simplify complex calculations with custom functions
03 Nov 2025
Contributed by Lukas
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 th...
Smarter, faster, easier: Here's what's new in Excel
01 Oct 2025
Contributed by Lukas
In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance and accoun...
Unleash the power of Python in Excel
01 Sep 2025
Contributed by Lukas
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...
Python in Excel: Practical applications
01 Aug 2025
Contributed by Lukas
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 directl...
Getting started with Python in Excel
01 Jul 2025
Contributed by Lukas
Unlock the potential of Python in Excel with this essential first episode in a three-part series. Designed for accountants, finance professiona...
Excel's GROUPBY and PIVOTBY explained
02 Jun 2025
Contributed by Lukas
Excel's new functions, GROUPBY and PIVOTBY, offer a smarter way to build reports. Instead of relying on traditional pivot tables, these new to...
Better share price reports with Excel's new tool
01 May 2025
Contributed by Lukas
Need to turn stock market data into smart, professional reports? Discover how to use Excel's new and powerful Stock History function to quickly tran...
Elevate your Pareto analysis skills with Excel
31 Mar 2025
Contributed by Lukas
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 lear...
Unlock the power of Microsoft Forms in Excel
03 Mar 2025
Contributed by Lukas
What if you could seamlessly collect and analyse data right inside Excel? In this episode, learn more about Microsoft Forms, a powerful tool in...
New tool explained: boost your efficiency with checkboxes
02 Feb 2025
Contributed by Lukas
Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you'll discover the power of checkboxes with practical examp...
Improve your PDF data handling with Power Query
02 Jan 2025
Contributed by Lukas
Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occur...
Handy hack to create timeline charts
01 Dec 2024
Contributed by Lukas
Excel doesn't have a built-in timeline chart but we'll show you how to create one. In this episode you'll learn how using a scatter chart can help you...
Master calendar creation in Excel
31 Oct 2024
Contributed by Lukas
Calendars are your go-to tool for planning. In this Excel Tips episode, you'll learn the steps to create a single-month calendar from scratch. Discove...
How to add a user interaction into Power Query
30 Sep 2024
Contributed by Lukas
Reports are crucial to your work, aren't they? Power Query is a valuable tool for importing many types of data into Excel to help you create these rep...
Learn a smart way to hide blank or zero rows
31 Aug 2024
Contributed by Lukas
Looking to improve your report-building skills? If so, this is the episode for you. Uncover tips on how to leverage multiple Excel features to creat...
The power of heat maps for sales and costs data
01 Aug 2024
Contributed by Lukas
Looking for ways to gain deeper insights from your sales and costs data in Excel? This episode explores the power of heat maps, a data visualisation t...
3 powerful macros to streamline your workflow
30 Jun 2024
Contributed by Lukas
There's a misconception that Excel macros are outdated or unnecessary. In this episode we set the record straight and explore their continued value. D...
Level up your custom functions skills
03 Jun 2024
Contributed by Lukas
Tune in to discover how mastering custom functions can help simplify two complex issues with Excel formulas. Improve your problem-solving skills by ha...
How to create a dashboard using Excel's dynamic arrays
01 May 2024
Contributed by Lukas
Do you want to improve your dashboard-creating skills in Excel? Look no further. This episode has all the expert tips you need to know using dynamic a...
How to automate report building in Excel (part 2)
02 Apr 2024
Contributed by Lukas
Don't miss this episode, the second in a three-part series that explains how you can use the power of dynamic arrays in report building. Learn how to ...
How to automate report building in Excel
29 Feb 2024
Contributed by Lukas
Are you an accountant or finance professional looking to enhance your daily workflows? Don't miss this episode, which delves into the exciting capab...
Master the latest Excel changes: your ultimate guide
01 Feb 2024
Contributed by Lukas
For accounting and finance professionals, it's vital that you keep up-to-date with changes to Microsoft Excel functionality. This episode explains w...
How to master using different Excel techniques together
04 Jan 2024
Contributed by Lukas
Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of...
Top Excel tips for your first 100 days in a new job
01 Dec 2023
Contributed by Lukas
Starting a new role in accounting and finance? We understand it can be stressful as you try to make a good first impression. This Excel Tips episode...
How to create improved data visualisations in Excel
01 Nov 2023
Contributed by Lukas
If you're looking for ways to display diverse types of data using Excel's charts and visualisation tools, this podcast, loaded with tips, will show yo...
Master 10 new and revamped Excel features
03 Oct 2023
Contributed by Lukas
Do you want an Excel edge? Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow...
Boost your skills with tips for Excel function updates
01 Sep 2023
Contributed by Lukas
Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help yo...
Unlock 14 expert tips for Excel formulas
01 Aug 2023
Contributed by Lukas
Unleash your Excel skills by using the valuable functionality of formulas. Go straight to episode sections: The formula bar – 1:06 Starting formul...
Why Excel can be a university student's secret weapon
02 Jul 2023
Contributed by Lukas
Are you a university student or recent graduate? Are you looking to gain a competitive edge in the job market, specifically in the fields of account...
22 Excel shortcuts to supercharge your efficiency
01 Jun 2023
Contributed by Lukas
Unlock your Excel efficiency with these 22 time-saving shortcuts for everyday work tasks. Tune in now to supercharge your productivity. Timest...
Excel and ChatGPT
04 May 2023
Contributed by Lukas
Can ChatGPT give accurate and reliable answers to Excel questions? Neale Blackwood CPA puts this popular AI tool to the test. Host: Neale Blackwood C...
Learn Excel's built-in artificial intelligence feature
06 Apr 2023
Contributed by Lukas
Artificial Intelligence (AI) has come to Microsoft Excel, and it will make your life easier when working with data. The AI function can easily cre...
How to use custom functions without macros
23 Mar 2023
Contributed by Lukas
Along with the LAMBDA function, other new functions make Excel's function language behave more like a programming language. Which can help you in vari...
How to do dynamic arrays (subscription version)
16 Mar 2023
Contributed by Lukas
An update to the subscription version of Microsoft Excel has the LAMBDA function, which addresses a key challenge when using dynamic arrays. To explai...
How to create vertical lines in line charts
09 Mar 2023
Contributed by Lukas
When creating a line chart in Microsoft Excel, do you need to insert a vertical line to mark something on the chart? To explain how is Excel expert...
Excel tips: how to use the new data types feature
02 Mar 2023
Contributed by Lukas
Today's episode examines the new data types feature in Microsoft Excel. There are four data types you can now import from the data ribbon, and that in...
Excel tips: how to work with dates and days
20 Feb 2023
Contributed by Lukas
Today's episode investigates working with dates and days in Microsoft Excel. Excel can perform basic addition and subtraction calculations using dates...
Excel tips: how to use Goal Seek
13 Feb 2023
Contributed by Lukas
Today's episode looks at a handy tool in Microsoft Excel called Goal Seek. It can be used to create a loan schedule with an interest-free period using...
Excel tips: how to improve your formatting
06 Feb 2023
Contributed by Lukas
Today's episode will help with your formatting in Microsoft Excel. Want to know how to make your files easier to read, understand and use? To explain ...
Excel Tips: New text functions for Excel
31 Jan 2023
Contributed by Lukas
In this episode, we look at three new text functions released in the latest (subscription) version of Microsoft Excel. The functions are: "Text Bef...
EXCEL TIPS, coming soon.
13 Jan 2023
Contributed by Lukas
Excel Tips is a podcast for accounting, business and finance professionals who are looking to sharpen their spreadsheet skills and learn new hacks and...