How to use Office Scripts and Power Automate to do Boring Excel Tasks for You

Video Description

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses Learn how to effortlessly run Office Scripts in Excel online, without even opening your files! Discover how to automate tasks across multiple Excel sheets and files seamlessly. 📌 What You'll Learn: ▪️ Create and Run Office Scripts: Discover how to record a script in Excel for tasks like formatting. We'll show you how to script for multiple sheets in a file. ▪️ Adjust Scripts for Broader Use: Modify your script to work on every sheet of your Excel file. ▪️ Seamless Integration with Power Automate: Learn to use Power Automate to run your script on all files in a folder, schedule tasks, and more. In this video you'll learn how to trigger an Office Script with Power Automate in Microsoft Excel. Office Scripts in Excel on the web lets you automate your day-to-day tasks. It's like running a macro on the web. You can repeat your recorded Excel actions on different workbooks and worksheets without ever opening the files. You can run your script from your mobile, based on a schedule, or if something happens in another app. As we setup this Office Script, I'll show you how you can apply your script to each worksheet. So we'll use Office Scripts to loop through each sheet in the file. In this step by step tutorial we'll create an office script that applies s special formatting to all sheets in an Excel file. The script should run not just on one file but on any file in a specific folder. With Power Automate we will loop though all files in a folder and if we come across an Excel file it will apply the script. 00:00 How to Run an Office Script in Excel With Power Automate 01:27 Recording an Office Script 03:17 How to Edit and Adjust an Office Script 06:36 How to Setup the Flow in Power Automate 10:49 Testing the Flow to Trigger the Office Script 11:34 Wrap Up ⯆ Link to complete blog post: https://www.xelplus.com/office-scripts-with-power-automate LINKS to related videos: Introduction to Office Scripts: https://youtu.be/fny4zUycp_w Power Automate Beginner's Guide: https://youtu.be/SUsik0FGzI0 ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel #officescripts #powerautomate