Excel Spilled Results and Fixing the SPILL! Error
Microsoft Excel Tips and Tricks Learn how Excel can now “spill” results of formulas in Microsoft 365 versions of Excel.[…]
Read more
The Learning Zone
Dedicated to everything Learning, learning is fun
Excel Dynamic Dependent Drop-down Lists for Entire Column – No Complicated Formulas Required
Microsoft Excel Tips and Tricks I demonstrate how to create dependent drop-down lists in Microsoft Excel. A dependent drop-down list[…]
Read more
Two Excel Dynamic Array Functions: UNIQUE and SORT
Microsoft Excel Tips and Tricks Learn how to use two of the dynamic array functions that are in Microsoft 365:[…]
Read more
Create an Excel Macro that Highlights Rows
Microsoft Excel Tips and Tricks Learn how to create a VBA Excel Macro that will highlight every other row of[…]
Read more
Using Excel’s XLOOKUP Function
Microsoft Excel Tips and Tricks Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP[…]
Read more