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
Tag: excel
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
How to Fix an Excel Table that’s Slow to Scroll or Respond
Microsoft Excel Tips and Tricks In this video, I demonstrate how to resolve a performance issue caused by whole column[…]
Read more