How to use Office Scripts in Excel & Power Automate

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: CookiesSold.xlsx
– 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

⌚ 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

Posted by Contributor