In this Excel training video, we'll guide you through the essential process of identifying external links, such as links or references to other workbooks. Managing external links is crucial for...
Posts by John Gleave
In this Excel training video, we'll guide you through the process of retrieving the day of the week in Excel by leveraging the platform's pre-existing functions. Excel provides a range of built-in...
In this Excel training video, we guide you through the process of enabling the developer tab in both Windows and Mac desktop versions of Excel. We'll also show you how to use some of the common...
In this Excel training video, we'll look at some of the logical functions in Excel. We'll look at IF, IF OR (where OR is nested within an IF function), and AND functions, providing you with a...
How to Count Non-empty cells using the COUNTIF Function in Excel
In this Excel training video, we'll be showing you how to use the versatile COUNTIF function. Our focus centers on an essential data analysis task: counting non-empty cells in your spreadsheet....
In this Excel training video, we'll be using some Excel functions to demonstrate how to extract substrings from your data. Our focus revolves around four fundamental functions: LEFT, RIGHT, MID, and...