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 moreExcel Training Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP replaces the VLOOKUP[…]
Read moreExcel Training Learn how to use two of the dynamic array functions that are in Microsoft 365: the UNIQUE function[…]
Read moreExcel Training Learn how to create a VBA Excel Macro that will highlight every other row of whatever area of[…]
Read moreExcel Training Learn how Excel can now “spill” results of formulas in Microsoft 365 versions of Excel. Credit Chester Tugwell
Read moreExcel Training I demonstrate how to create dependent drop-down lists in Microsoft Excel. A dependent drop-down list displays values dependent[…]
Read more