New tool explained: boost your efficiency with checkboxes
Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you'll discover the power of checkboxes with practical examples to explore how this new function can streamline y...
2 Feb 202510min
Improve your PDF data handling with Power Query
Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occurrence. To help you, this episode explores Micro...
2 Jan 202512min
Handy hack to create timeline charts
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 build a timeline chart. For easy reference, here ...
1 Dec 202410min
Master calendar creation in Excel
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. Discover how to combine advanced functions to build a two...
31 Okt 202417min
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 Juni 20249min
