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
Author: Mary
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
How to use Excel Index Match (the right way)
MS Excel Tips How to use Excel Index Match (the right way) Credit Leila Gharani
Read more