How to add a user interaction into Power Query
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 reports. However, it does have limitations. In this e...
30 Sep 202411min
Learn a smart way to hide blank or zero rows
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 create a system that effortlessly hides blank and zero r...
31 Aug 20249min
The power of heat maps for sales and costs data
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 technique often used for climate data, but equally ...
1 Aug 20249min
3 powerful macros to streamline your workflow
There's a misconception that Excel macros are outdated or unnecessary. In this episode we set the record straight and explore their continued value. Delve into three practical macros that can streamli...
30 Jun 20249min
Level up your custom functions skills
Tune in to discover how mastering custom functions can help simplify two complex issues with Excel formulas. Improve your problem-solving skills by harnessing the power of custom functions. For fast a...
3 Jun 202410min
How to create a dashboard using Excel's dynamic arrays
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 arrays to create a dashboard. For fast access, use ...
1 Mai 202410min
How to automate report building in Excel (part 2)
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 review a report that's using dynamic arrays to cre...
2 Apr 202411min
How to automate report building in Excel
Are you an accountant or finance professional looking to enhance your daily workflows? Don't miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effort...
29 Feb 202411min
