Excel Tips

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 Elo 20249min

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 Kesä 20249min

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 Kesä 202410min

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 Touko 202410min

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 Huhti 202411min

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 Helmi 202411min

For accounting and finance professionals, it's vital that you keep up-to-date with changes to Microsoft Excel functionality. This episode explains what you need to know, including the latest changes ...

1 Helmi 202415min

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 Excel techniques together.  In this episode, we s...

4 Tammi 202417min