Using Excel’s XLOOKUP Function
Excel Training Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP replaces the VLOOKUP[…]
Read more
Author: Noel
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
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