How to Calculate Dates with WORKDAY and NETWORKDAYS in Excel
Microsoft Excel Tips and Tricks In this video, we dive deep into two crucial date functions in Excel: Workday and[…]
Read more
Category: Excel
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
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