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
Tag: excel
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
Do You Need to Switch from Excel VBA Macros to Office Scripts?
Microsoft Excel Tips and Tricks For decades Excel VBA Macros has been the best choice for automation topics in Excel.[…]
Read more