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: https://1drv.ms/x/s!AmxrofZZlZ-whLBdx…
  • 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/offi…
  • Office Scripts overview: https://support.microsoft.com/en-us/o…
• 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