👩‍💻 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
- Office Scripts overview:

⌚ 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

🚩 Connect with me on social

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ 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

[ameriknu]

Since we are working everyday it excel, maybe you can showcase power automate or power automate desktop on how to build flows to copy data from one excel to another, delete row/columns update pivots, save and send via email as attachment. That will be amazing

[derekcanmexit]

It's amazing what Microsoft can do to help automate one's workflow -- very curious to learn more!

[AmyWharton]

Hi Kevin. This is great!!! I'd love it if you would do videos showcasing more advanced applications of Power Automate and Office Scripts. Thanks so much!

[gajabathiarjuntg]

Great video Kevin. Never heard of this word Office Scripts but you've now explained Office scripts are useful to automate your day-to-day tasks and how it works. Thanks Kevin 😀

[dougtvedt]

Great video, Kevin! Thank you very much! As someone that has several repetitive monthly reports to do, I've been seeking a way to automate them for a long time. I've developed a lot of macros to help with automation, but was unfamiliar with Scripts until this video. My question is how to use both macros and scripts to completely automate this process.

[VonKrause]

This channel is really helpful it should get more attention. I hope you will reach 1 mill some day

[jameszhou]

great stuff Kevin! one thing i must say is that you got really good voice to deliver the training. normally i cannot bear any vid over 15 min, but this 25 min, it felt pretty short. if you got any courses available in udemy or elsewhere, please let me know. thanks.

[itsamazing]

I never thought you can program in Microsoft office this is just very useful to me

[canirmalchoudhary]

Very insight tutorial on Office Script

[Simon-vcwk]

Might be best to convert sample dataset to a table, that way if new rows are added your profit column calculation formulae won't be impacted.

[prokorshopal]

0:05 - Hi Kevin! 👋
24:53 - 238th thumbs up from me! 👍 Cheers!

[ashokanselliah]

Very.much interesting. I will start today itself and it will save tons of time. Many thanks Kevin for your invaluable information in this video

[newmandoss]

Yes, it's very useful, its level more than macro, but a lot to learn for using this😁

[Rizwan]

This is exactly what I was looking for... 😍👏

[nurulnajwasafie]

This is fun!!! thanks for the content. Looking forward for more from you :D

[maheshkakar]

Hi Kevin, your video are very interesting with simple and to the point explanation.
Thank you for your video which help us to understand this excel with interest.

[jeffkerr]

That is pretty cool. Thanks and keep them coming.

[corochena]

Very nice intro video about Office Scripts!

[suzannecadden]

Hi Kevin! I just found your channel and really appreciate your videos. I JUST learned a little about VBA, wrote (copied and tweaked) a couple of macros and I am super proud of the work I have done. Now we decided to use a particular file in Teams so there is one macro I need to convert from VBA to Script. I wrote the script and when I run it, I am not getting any errors but it also doesn't accomplish my goal. I can't record the script because I am trying to enable outlining on a protected sheet which is something I needed to accomplish via macro. Do you know if this can even be done in a script or is it something that can only be done in VBA in the desktop version of excel? Thanks for your thoughts!

[chrisr]

Thanks you kevin for this video you are the best youtuber