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
Author: Mary
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
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
Excel Solver example and step-by-step explanation
MS Excel Tips Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing[…]
Read more