In this Excel Training video, we're leveraging date calculations in Excel, unveiling a versatile formula that empowers you to count the number of days between user-specified start and end dates. But...
Posts by John Gleave
In this Excel Training video, we'll show you how to create a dynamic percentage increase or decrease formula. This versatile formula calculates the percentage change between two values, providing you...
In this Excel Training video, we're unveiling a secret formula that takes your text search skills to a whole new level. We understand that sometimes, searching for text in Excel can be a bit like...
In this Excel Training video, we'll be focusing on currency rates, and we've got a neat trick up our sleeves. We'll unveil a method that allows you to retrieve currency rates directly within Excel,...
In this Excel Training video, we'll give you the cheat code for creating dynamic sequences of numbers and letters within your spreadsheets. Whether you're organizing data, setting up tables, or...
In this Excel Training video, we'll show you how to use patterns to selectively retrieve information from your datasets. We'll unveil a clever and efficient formula that calculates precisely which...