Two Excel Dynamic Array Functions: UNIQUE and SORT
Excel Training Learn how to use two of the dynamic array functions that are in Microsoft 365: the UNIQUE function[…]
Read more
Author: Noel
Create an Excel Macro that Highlights Rows
Excel Training Learn how to create a VBA Excel Macro that will highlight every other row of whatever area of[…]
Read more
Excel Spilled Results and Fixing the SPILL! Error
Excel Training Learn how Excel can now “spill” results of formulas in Microsoft 365 versions of Excel. Credit Chester Tugwell
Read more
Excel Dynamic Dependent Drop-down Lists for Entire Column – No Complicated Formulas Required
Excel Training I demonstrate how to create dependent drop-down lists in Microsoft Excel. A dependent drop-down list displays values dependent[…]
Read more
How to Add Text to the Beginning and End of a Cell in Excel – 3 Methods
Excel Training I demonstrate how to add text to the beginning and/or end of a cell or multiple cells.
Read more