Excel Table of Contents for Sheet Tabs with Hyperlinks | Create Automatically | Office Script Macro
Microsoft Excel Tips and Tricks In this Microsoft Excel video I tutorial I explain how to use an Office Script[…]
Read more
Tag: excel
New Python in Excel – Python + Excel + ChatGPT = Easy!
Microsoft Excel Tips and Tricks How to use Python in Excel natively using libraries like Pandas, NumPy, Matplotlib, Seaborn and[…]
Read more
Why Pro Excel Users Love SUMPRODUCT!
Microsoft Excel Tips and Tricks The Excel SUMPRODUCT function is one of Excel’s most versatile and underutilized functions allowing for[…]
Read more
Copy a list of Filenames into Excel Using Command Prompt in Windows
Microsoft Excel Tips and Tricks In this video I show you a really quick way of getting a list of[…]
Read more
Automatically Format Color Based on Expiry Dates in Excel | With Expiry Date Formula | 30, 90 Days
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial, I explain how to automatically format dates based on[…]
Read more