Elevate your Pareto analysis skills with Excel
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 learn how to apply it effectively in Excel for smarter, da...
31 Mars 202510min
Unlock the power of Microsoft Forms in Excel
What if you could seamlessly collect and analyse data right inside Excel? In this episode, learn more about Microsoft Forms, a powerful tool in Microsoft 365 (which, by the time you read this may ...
3 Mars 202510min
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
