Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com

In this stepbystep 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!AmxrofZZlZwhLBdx...
Fundamentals of Programming in Python:    • ‍ Python for Beginners Tutorial  
Macros Tutorial in Microsoft Excel Desktop:    • How to Create Macros in Excel Tutorial  
Introduction to Power Automate:    • Power Automate Tutorial for Beginners  
Microsoft Office Scripts documentation: https://docs.microsoft.com/enus/offi...
Office Scripts overview:
https://support.microsoft.com/enus/o...
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com'>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:    • ❎ How to use Excel  
Playlist with all my videos on Power Automate:    • Power Automate  

Connect with me on social
LinkedIn:   / kevinstratvert  
Twitter:   / kevstrat  
Facebook:   / kevinstratvert101912218227818  
TikTok:   / kevinstratvert  

Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...

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