In this Excel Training video, we'll show you how to locate external links, such as references to other workbooks, within Microsoft Excel. First, we demonstrate how to access the Edit Links tool on...
Posts by John Gleave
In today's Excel Training video, we'll show you how to extract the day of the week from a date using the built-in functions, specifically TEXT and WEEKDAY. Understanding the day of the week can be...
In this Excel Training video, we'll focus on enabling and using the Excel developer tab, a crucial feature applicable to both Windows and Mac desktop versions. This walkthrough aims to provide a...
In this Excel Training video, we'll guide you through the effective utilization of Excel's IF function, demonstrate the integration of logical OR conditions within an IF statement, delve into the...
In this Excel Training video, we'll show you how to use the COUNTIF function in Excel to tally the number of non-empty (not blank) cells within a specified range. Additionally, we'll demonstrate how...
In this Excel Training video, we'll show you how to extract substrings using functions in Excel. The functions mentioned in this video are LEFT, RIGHT, MID, and SEARCH. But we also have a bonus tip...