❎ How to use Excel

Currently Playing: 👩‍💻 How to use Office Scripts in Excel & Power Automate

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step tutorial, learn how you can use Office Scripts in Excel on the web to automate repetitive and mundane tasks. Additionally, learn how you can trigger you scripts automatically using Power Automate. With Power Automate, you can set a Teams message, an email, or other app to trigger your script. 👋 Additional resources - Sample Excel data to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whLBdxb4JyYYdN27ddw?e=smo1Zj - Fundamentals of Programming in Python: https://youtu.be/b093aqAZiPU - Macros Tutorial in Microsoft Excel Desktop: https://youtu.be/uyj_OljPlcU - Introduction to Power Automate: https://youtu.be/dDO4Y4aDYXw - Microsoft Office Scripts documentation: https://docs.microsoft.com/en-us/office/dev/scripts/ - Office Scripts overview: https://support.microsoft.com/en-us/office/introduction-to-office-scripts-in-excel-9fbe283d-adb8-4f13-a75b-a81c6baf163a?ui=en-us&rs=en-us&ad=us - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 2:18 Requirements 2:42 Access Office Scripts 5:23 Record actions & run script 8:59 Check where script is saved 9:33 Run script on another worksheet 10:09 Code editor to tweak script 16:05 Share script with others 17:02 Trigger script with Power Automate 23:10 Advanced Power Automate 24:01 Additional resources 24:42 Wrap up 📃 Watch related playlists and videos - Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY - Playlist with all my videos on Power Automate: https://youtube.com/playlist?list=PLlKpQrBME6xKE_fxQ_YzHVV7HluHpifW9 🚩 Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert