title
👩💻 How to use Office Scripts in Excel & Power Automate
description
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-whLBdxb4JyYYdN27ddw?e=smo1Zj
- 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
- Learn the fundamentals of Excel in just 2 hours: 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: 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
detail
{'title': '👩\u200d💻 How to use Office Scripts in Excel & Power Automate', 'heatmap': [{'end': 172.824, 'start': 135.909, 'weight': 0.796}, {'end': 259.237, 'start': 182.289, 'weight': 0.739}, {'end': 548.962, 'start': 529.748, 'weight': 0.756}, {'end': 579.863, 'start': 559.989, 'weight': 0.903}, {'end': 1039.453, 'start': 1019.3, 'weight': 0.758}, {'end': 1117.068, 'start': 1091.296, 'weight': 0.703}, {'end': 1207.902, 'start': 1158.261, 'weight': 0.782}, {'end': 1283.48, 'start': 1219.132, 'weight': 0.707}], 'summary': 'Learn how to use office scripts in excel on the web to automate repetitive tasks and save time, create profitable scripts in office resulting in a weekly profit of 2.3 million, automate excel tasks for efficient data management, and automate excel formatting tasks using typescript and power automate.', 'chapters': [{'end': 273.346, 'segs': [{'end': 172.824, 'src': 'heatmap', 'start': 49.963, 'weight': 0, 'content': [{'end': 54.384, 'text': 'Instead, I can use Office scripts to record all of these manual steps.', 'start': 49.963, 'duration': 4.421}, {'end': 58.125, 'text': 'And next week, when I get the latest cookie sales data,', 'start': 55.024, 'duration': 3.101}, {'end': 64.827, 'text': 'I can simply play back all of these steps and it can automate all of those different edits and formatting changes that I made.', 'start': 58.125, 'duration': 6.702}, {'end': 67.068, 'text': 'So my job is now a lot easier.', 'start': 65.227, 'duration': 1.841}, {'end': 75.878, 'text': "Now, if you've ever used macros before in Microsoft Excel or the desktop app, this probably sounds really familiar to you.", 'start': 67.895, 'duration': 7.983}, {'end': 82.58, 'text': "What's the difference between macros and Office scripts? Well, with Office scripts, it's all stored in the cloud.", 'start': 76.458, 'duration': 6.122}, {'end': 86.041, 'text': 'And the benefit is it makes it really easy to share with others.', 'start': 83.08, 'duration': 2.961}, {'end': 88.262, 'text': 'So at the Kevin Cookie company.', 'start': 86.721, 'duration': 1.541}, {'end': 94.604, 'text': 'if we get a new employee, I could just hand over the script to them and now they can run it, making my job even easier.', 'start': 88.262, 'duration': 6.342}, {'end': 101.728, 'text': 'Also, best of all, you can use Power Automate to kick off your Office script.', 'start': 95.564, 'duration': 6.164}, {'end': 109.252, 'text': "So what I mean by this is let's say my manager sends me an email saying, hey Kevin, the latest cookie sales data is now available.", 'start': 102.208, 'duration': 7.044}, {'end': 115.416, 'text': "I can use that email as a trigger to run my script so it'll now format all of the sales data.", 'start': 109.732, 'duration': 5.684}, {'end': 117.217, 'text': "Now I'm not really doing anything.", 'start': 115.736, 'duration': 1.481}, {'end': 121.179, 'text': "Hopefully they keep me on at the company because I'm not really doing much work.", 'start': 117.517, 'duration': 3.662}, {'end': 127.524, 'text': "Today we're going to run through first off how you can record an office script.", 'start': 122.441, 'duration': 5.083}, {'end': 129.764, 'text': "Then we'll also go in and we'll edit it.", 'start': 128.024, 'duration': 1.74}, {'end': 135.029, 'text': "We'll make some tweaks and then I'll show you how you can use Power Automate to kick off one of your scripts.", 'start': 130.126, 'duration': 4.903}, {'end': 138.591, 'text': "All right, let's jump on the PC and let's get started.", 'start': 135.909, 'duration': 2.682}, {'end': 144.833, 'text': 'Here I am now on my PC and to be able to follow along today, there are a few different requirements.', 'start': 138.951, 'duration': 5.882}, {'end': 150.034, 'text': 'First off, you need a work or school Microsoft 365 account.', 'start': 145.373, 'duration': 4.661}, {'end': 154.195, 'text': "Unfortunately, if you have a free personal account, this won't work for you.", 'start': 150.514, 'duration': 3.681}, {'end': 158.977, 'text': 'Also, you need access to OneDrive and also Excel on the web.', 'start': 155.036, 'duration': 3.941}, {'end': 162.558, 'text': "If you have all of those, you'll be able to follow along today.", 'start': 159.477, 'duration': 3.081}, {'end': 166.36, 'text': 'As a first step, head to Excel on the web.', 'start': 163.198, 'duration': 3.162}, {'end': 172.824, 'text': "Here I am on the Excel start page and I've already created a workbook called Cookies Sold.", 'start': 166.72, 'duration': 6.104}], 'summary': 'Office scripts automate manual steps, making job easier and shareable, using cloud storage, and integrating with power automate.', 'duration': 122.861, 'max_score': 49.963, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx22849963.jpg'}, {'end': 259.237, 'src': 'heatmap', 'start': 182.289, 'weight': 0.739, 'content': [{'end': 182.99, 'text': "Let's click on this.", 'start': 182.289, 'duration': 0.701}, {'end': 189.315, 'text': 'This now drops me in the cookies sold workbook and I get a sheet like this every single week.', 'start': 183.59, 'duration': 5.725}, {'end': 192.278, 'text': 'You get a view into my life here at the Kevin Cookie Company.', 'start': 189.435, 'duration': 2.843}, {'end': 198.623, 'text': 'And for all of you who thought that the Kevin Cookie Company was just a cover for tutorial videos, look,', 'start': 192.678, 'duration': 5.945}, {'end': 200.865, 'text': 'we actually sell cookies at this cookie company.', 'start': 198.623, 'duration': 2.242}, {'end': 202.987, 'text': 'See, we have the data right here.', 'start': 201.145, 'duration': 1.842}, {'end': 209.593, 'text': "To get started with Office Scripts, right up here on the top toolbar, there's a tab called automate.", 'start': 203.828, 'duration': 5.765}, {'end': 210.894, 'text': "Let's click on this one.", 'start': 209.993, 'duration': 0.901}, {'end': 215.876, 'text': 'This opens up the automate ribbon and we have a few different options here.', 'start': 211.414, 'duration': 4.462}, {'end': 219.158, 'text': "Let's take a moment to orient ourselves to what we have.", 'start': 216.157, 'duration': 3.001}, {'end': 226.342, 'text': 'Right over on the left hand side, I can click on record actions and this is very similar to recording a macro.', 'start': 219.798, 'duration': 6.544}, {'end': 230.944, 'text': 'Here I could go through, I could click, I can make changes, I can make formatting changes,', 'start': 226.782, 'duration': 4.162}, {'end': 233.966, 'text': 'and this will record all of those different steps that I take.', 'start': 230.944, 'duration': 3.022}, {'end': 239.049, 'text': "In a moment, we'll come back and we'll create our first office script using the recorder.", 'start': 234.486, 'duration': 4.563}, {'end': 245.311, 'text': "Right to the right of that over here, there's a gallery with a whole bunch of sample scripts.", 'start': 240.049, 'duration': 5.262}, {'end': 247.812, 'text': 'I could click into them to see how they work.', 'start': 245.791, 'duration': 2.021}, {'end': 253.634, 'text': "So here I'll click into this one and I could click in and actually see the code of how this script works.", 'start': 248.172, 'duration': 5.462}, {'end': 257.716, 'text': "So this is a good way to familiarize myself with what's possible.", 'start': 254.055, 'duration': 3.661}, {'end': 259.237, 'text': "I'm going to close out of this.", 'start': 257.736, 'duration': 1.501}], 'summary': 'Kevin cookie company uses office scripts to automate tasks, with a gallery of sample scripts available.', 'duration': 76.948, 'max_score': 182.289, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228182289.jpg'}, {'end': 233.966, 'src': 'embed', 'start': 192.678, 'weight': 5, 'content': [{'end': 198.623, 'text': 'And for all of you who thought that the Kevin Cookie Company was just a cover for tutorial videos, look,', 'start': 192.678, 'duration': 5.945}, {'end': 200.865, 'text': 'we actually sell cookies at this cookie company.', 'start': 198.623, 'duration': 2.242}, {'end': 202.987, 'text': 'See, we have the data right here.', 'start': 201.145, 'duration': 1.842}, {'end': 209.593, 'text': "To get started with Office Scripts, right up here on the top toolbar, there's a tab called automate.", 'start': 203.828, 'duration': 5.765}, {'end': 210.894, 'text': "Let's click on this one.", 'start': 209.993, 'duration': 0.901}, {'end': 215.876, 'text': 'This opens up the automate ribbon and we have a few different options here.', 'start': 211.414, 'duration': 4.462}, {'end': 219.158, 'text': "Let's take a moment to orient ourselves to what we have.", 'start': 216.157, 'duration': 3.001}, {'end': 226.342, 'text': 'Right over on the left hand side, I can click on record actions and this is very similar to recording a macro.', 'start': 219.798, 'duration': 6.544}, {'end': 230.944, 'text': 'Here I could go through, I could click, I can make changes, I can make formatting changes,', 'start': 226.782, 'duration': 4.162}, {'end': 233.966, 'text': 'and this will record all of those different steps that I take.', 'start': 230.944, 'duration': 3.022}], 'summary': 'Kevin cookie company sells cookies and offers office scripts for automation.', 'duration': 41.288, 'max_score': 192.678, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228192678.jpg'}], 'start': 3.671, 'title': 'Using office scripts in excel', 'summary': 'Discusses the use of office scripts in excel on the web, which can automate repetitive tasks, saving a considerable amount of time, and provides a practical demonstration of recording actions and exploring sample scripts.', 'chapters': [{'end': 150.034, 'start': 3.671, 'title': 'Using office scripts in excel', 'summary': 'Discusses how to use office scripts in excel on the web, which can save a considerable amount of time by automating repetitive tasks, such as formatting changes and adding formulas to data, using cloud-based scripts and triggering them with power automate.', 'duration': 146.363, 'highlights': ['Office scripts automate repetitive tasks in Excel on the web, saving considerable time by recording and playing back manual steps, such as formatting changes and formula calculations, reducing the need for repetitive manual work.', 'Office scripts are stored in the cloud, making it easy to share with others and enabling new employees to run the scripts, thereby streamlining workflow and improving efficiency at the Kevin and Cookie company.', 'Power Automate can be used to trigger Office scripts, such as formatting sales data upon receiving an email notification, automating tasks and reducing manual intervention, enhancing productivity within the company.', 'The chapter walks through recording, editing, and using Power Automate to trigger Office scripts in Excel on the web, providing a comprehensive guide for leveraging this automation tool to streamline tasks and improve efficiency.']}, {'end': 273.346, 'start': 150.514, 'title': 'Using office scripts in excel', 'summary': 'Explains how to use office scripts in excel, requiring access to onedrive, excel on the web, and a workbook named cookies sold, which provides a practical demonstration of recording actions and exploring sample scripts.', 'duration': 122.832, 'highlights': ['Access to OneDrive and Excel on the web is required to follow the tutorial To follow the tutorial, users need access to OneDrive and Excel on the web.', 'Workbook named Cookies Sold is used for practical demonstration The tutorial provides a practical demonstration using a workbook named Cookies Sold.', 'Explanation of recording actions in Office Scripts The chapter explains the process of recording actions in Office Scripts, similar to recording a macro.', 'Gallery with sample scripts for familiarization The tutorial demonstrates the availability of a gallery with sample scripts for familiarization and learning purposes.']}], 'duration': 269.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2283671.jpg', 'highlights': ['Office scripts automate repetitive tasks in Excel on the web, saving considerable time by recording and playing back manual steps, such as formatting changes and formula calculations, reducing the need for repetitive manual work.', 'The chapter walks through recording, editing, and using Power Automate to trigger Office scripts in Excel on the web, providing a comprehensive guide for leveraging this automation tool to streamline tasks and improve efficiency.', 'Office scripts are stored in the cloud, making it easy to share with others and enabling new employees to run the scripts, thereby streamlining workflow and improving efficiency at the Kevin and Cookie company.', 'Power Automate can be used to trigger Office scripts, such as formatting sales data upon receiving an email notification, automating tasks and reducing manual intervention, enhancing productivity within the company.', 'The tutorial provides a practical demonstration using a workbook named Cookies Sold.', 'Explanation of recording actions in Office Scripts The chapter explains the process of recording actions in Office Scripts, similar to recording a macro.', 'Gallery with sample scripts for familiarization The tutorial demonstrates the availability of a gallery with sample scripts for familiarization and learning purposes.', 'Access to OneDrive and Excel on the web is required to follow the tutorial To follow the tutorial, users need access to OneDrive and Excel on the web.']}, {'end': 447.656, 'segs': [{'end': 320.277, 'src': 'embed', 'start': 291.098, 'weight': 2, 'content': [{'end': 295.841, 'text': 'So here are some of the samples we saw before in this gallery, and then I see the addition of another one.', 'start': 291.098, 'duration': 4.743}, {'end': 304.507, 'text': "Online. there's a massive collection of different samples that I can look at, and this is one of the best ways to learn how to code using Office scripts.", 'start': 296.401, 'duration': 8.106}, {'end': 307.329, 'text': 'You could just look at different samples to see how they did it.', 'start': 304.567, 'duration': 2.762}, {'end': 313.993, 'text': 'Right up here near the top, I also have the option to simply kick off a new script not using the recorder.', 'start': 308.189, 'duration': 5.804}, {'end': 315.414, 'text': 'So I could just enter in my code.', 'start': 314.033, 'duration': 1.381}, {'end': 320.277, 'text': 'But once again, I want to start with the simplest possible method of creating a script.', 'start': 315.894, 'duration': 4.383}], 'summary': 'Gallery displays coding samples, offers vast online collection for learning office scripts.', 'duration': 29.179, 'max_score': 291.098, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228291098.jpg'}, {'end': 353.571, 'src': 'embed', 'start': 328.743, 'weight': 0, 'content': [{'end': 334.847, 'text': "And right now you see that it's recording and this is going to record every single step that I take.", 'start': 328.743, 'duration': 6.104}, {'end': 339.068, 'text': 'So any change that I make here will be captured over here in this pane.', 'start': 335.367, 'duration': 3.701}, {'end': 343.669, 'text': "So this really works best to record steps that you're pretty familiar with.", 'start': 339.608, 'duration': 4.061}, {'end': 348.19, 'text': "If you're clicking around and you're clicking on different buttons, remember, it's going to keep track of all of that.", 'start': 343.809, 'duration': 4.381}, {'end': 353.571, 'text': 'Also, another good technique to pulling together a script is you could record in chunks.', 'start': 348.79, 'duration': 4.781}], 'summary': 'Recording captures every step, best for familiar steps, can record in chunks.', 'duration': 24.828, 'max_score': 328.743, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228328743.jpg'}, {'end': 433.928, 'src': 'embed', 'start': 404.759, 'weight': 1, 'content': [{'end': 405.719, 'text': 'That looks good so far.', 'start': 404.759, 'duration': 0.96}, {'end': 409.78, 'text': "Now over here I want to calculate the profit, so for this I'll enter in the formula.", 'start': 405.859, 'duration': 3.921}, {'end': 417.962, 'text': "I'll take the revenue minus the cost, so here I'll do 5 minus 2, I'll close the parentheses, and next I'll multiply it by the number of cookies sold.", 'start': 409.82, 'duration': 8.142}, {'end': 419.902, 'text': "So there's my profit formula.", 'start': 418.542, 'duration': 1.36}, {'end': 422.323, 'text': "Now, as I'm making all of these changes.", 'start': 420.382, 'duration': 1.941}, {'end': 423.864, 'text': 'so here I bolded this row.', 'start': 422.323, 'duration': 1.541}, {'end': 425.705, 'text': 'I bolded this column.', 'start': 423.864, 'duration': 1.841}, {'end': 427.145, 'text': 'here I put in a formula.', 'start': 425.705, 'duration': 1.44}, {'end': 430.307, 'text': "you'll notice here that it's recording all of these different actions.", 'start': 427.145, 'duration': 3.162}, {'end': 433.928, 'text': "Here I'll take this formula and I'll apply it all the way down.", 'start': 431.087, 'duration': 2.841}], 'summary': 'Calculating profit by revenue minus cost, then multiplying by cookies sold.', 'duration': 29.169, 'max_score': 404.759, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228404759.jpg'}], 'start': 273.586, 'title': 'Automating script creation in office', 'summary': 'Explains the process of creating scripts in office, including recording actions, integrating recorded chunks, and automating repetitive tasks, ultimately leading to a profitable company with a weekly profit of 2.3 million.', 'chapters': [{'end': 447.656, 'start': 273.586, 'title': 'Automating script creation in office', 'summary': 'Explains the process of creating scripts in office, including recording actions, integrating recorded chunks, and automating repetitive tasks, ultimately leading to a profitable company with a weekly profit of 2.3 million.', 'duration': 174.07, 'highlights': ['The process of creating scripts in Office involves recording actions, integrating recorded chunks, and automating repetitive tasks. It explains the steps involved in creating scripts, including recording actions, integrating chunks, and automating repetitive tasks.', "The company's weekly profit amounts to 2.3 million. The company's weekly profit is highlighted, showing the success achieved through the automated script creation process.", 'The option to simply kick off a new script not using the recorder exists. There is an option to initiate a new script without using the recorder, providing flexibility in script creation.']}], 'duration': 174.07, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228273586.jpg', 'highlights': ['The process of creating scripts in Office involves recording actions, integrating recorded chunks, and automating repetitive tasks.', "The company's weekly profit amounts to 2.3 million.", 'The option to simply kick off a new script not using the recorder exists.']}, {'end': 818.824, 'segs': [{'end': 605.399, 'src': 'heatmap', 'start': 559.989, 'weight': 0, 'content': [{'end': 565.994, 'text': "Here I'll click into the folder called Documents, and within Documents there's another folder called Office Scripts.", 'start': 559.989, 'duration': 6.005}, {'end': 571.157, 'text': 'When I click on that, here I see a new script file called cookies sold formatting.', 'start': 566.434, 'duration': 4.723}, {'end': 573.459, 'text': 'So this is where all of my scripts are saved.', 'start': 571.457, 'duration': 2.002}, {'end': 579.863, 'text': 'Back in Microsoft Excel, here I have another sheet with all of the cookie sales data from April 10th.', 'start': 573.819, 'duration': 6.044}, {'end': 585.927, 'text': 'And when I click into this, this once again is just like it was on the other sheet before I started with all my edits.', 'start': 580.223, 'duration': 5.704}, {'end': 591.75, 'text': 'Here I can simply click on run And look at this, all of my editing has now been applied here.', 'start': 586.327, 'duration': 5.423}, {'end': 596.953, 'text': 'So once again, my job is pretty easy and I could use this script on any one of my worksheets.', 'start': 592.11, 'duration': 4.843}, {'end': 602.217, 'text': "So far, we've just been recording all of our steps and we ran them against two different sheets.", 'start': 597.554, 'duration': 4.663}, {'end': 605.399, 'text': "So congratulations, we're already starting to automate things.", 'start': 602.277, 'duration': 3.122}], 'summary': 'Automated script applied to excel data, simplifying editing process, automating tasks.', 'duration': 75.651, 'max_score': 559.989, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228559989.jpg'}, {'end': 691.788, 'src': 'embed', 'start': 668.118, 'weight': 7, 'content': [{'end': 675.746, 'text': 'but having just a very high level knowledge of how this works will allow you to tweak it so it works to meet your needs.', 'start': 668.118, 'duration': 7.628}, {'end': 682.495, 'text': 'Before we go through and look at the code to understand it at a high level, I do want to make one quick change.', 'start': 676.306, 'duration': 6.189}, {'end': 686.56, 'text': "Right up here in the top right hand corner, there's an ellipsis.", 'start': 683.216, 'duration': 3.344}, {'end': 687.642, 'text': "Let's click on this.", 'start': 686.801, 'duration': 0.841}, {'end': 691.788, 'text': "Within here, towards the bottom, there's an option for editor settings.", 'start': 688.022, 'duration': 3.766}], 'summary': 'Understanding the high-level concept helps to customize and optimize code for specific needs.', 'duration': 23.67, 'max_score': 668.118, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228668118.jpg'}, {'end': 822.045, 'src': 'embed', 'start': 796.329, 'weight': 2, 'content': [{'end': 801.192, 'text': "And so if I run this script, it'll run it across this page that we see right here.", 'start': 796.329, 'duration': 4.863}, {'end': 804.995, 'text': 'Here if I shift to 4, 3, well now this is the active worksheet.', 'start': 801.652, 'duration': 3.343}, {'end': 808.237, 'text': "So if I now run this script, it'll run it against this.", 'start': 805.315, 'duration': 2.922}, {'end': 816.342, 'text': 'Instead of saying use the currently active worksheet, I could also simply define a specific worksheet,', 'start': 809.278, 'duration': 7.064}, {'end': 818.824, 'text': "and in a little bit we'll come back and we'll do that.", 'start': 816.342, 'duration': 2.482}, {'end': 822.045, 'text': 'Okay, so so far we have our function main.', 'start': 819.464, 'duration': 2.581}], 'summary': 'Script runs on active worksheet, can be defined for specific worksheet.', 'duration': 25.716, 'max_score': 796.329, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228796329.jpg'}], 'start': 447.856, 'title': 'Automating excel tasks', 'summary': 'Covers automating data formatting in excel including recording and running a script, formatting cells, and removing unwanted changes, resulting in a more efficient data management process. it also explores automating excel tasks with office scripts, covering accessing onedrive, understanding typescript and javascript, making code edits, and adjusting editor settings.', 'chapters': [{'end': 544.438, 'start': 447.856, 'title': 'Automating data formatting in excel', 'summary': 'Covers the process of recording and running a script to automate data formatting in excel, including formatting cells as currency and removing unwanted changes, resulting in a more efficient data management process and potentially time-saving benefits.', 'duration': 96.582, 'highlights': ['The process of recording and running a script to automate data formatting in Excel The user demonstrates the recording and running of a script to automate data formatting in Excel, showcasing the potential time-saving benefits of the process.', 'Formatting cells as currency The user highlights the process of formatting revenue and cost columns as currency, enhancing the data presentation and potentially improving readability and analysis.', 'Removing unwanted changes and reverting data to its original state The user showcases the process of reverting data to its original state by removing unwanted changes, highlighting the flexibility and control offered by the automation process.']}, {'end': 818.824, 'start': 544.679, 'title': 'Automating excel with office scripts', 'summary': 'Explores automating excel tasks with office scripts, covering accessing onedrive, running scripts in excel, understanding typescript and javascript, making code edits, and adjusting editor settings.', 'duration': 274.145, 'highlights': ["Accessing OneDrive via the waffle in the top left-hand corner and navigating to the 'Documents' folder containing Office Scripts.", 'Running a script in Microsoft Excel to automate editing tasks on worksheets, demonstrating the ease of automation and the potential for using scripts on multiple worksheets.', 'Explaining TypeScript as the language used by the action recorder, providing the option to directly write code in JavaScript or TypeScript.', 'Making code edits and adjusting editor settings in Office Scripts, including customizing the font size for better readability.', 'Encouraging learning the fundamentals of programming with Python, as it shares common concepts with other programming languages.']}], 'duration': 370.968, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228447856.jpg', 'highlights': ['Automating data formatting in Excel by recording and running a script', 'Formatting cells as currency for improved data presentation', 'Removing unwanted changes and reverting data to its original state', "Accessing OneDrive and navigating to the 'Documents' folder", 'Running a script in Excel to automate editing tasks on worksheets', 'Explaining TypeScript as the language used by the action recorder', 'Making code edits and adjusting editor settings in Office Scripts', 'Encouraging learning the fundamentals of programming with Python']}, {'end': 1293.167, 'segs': [{'end': 1018.92, 'src': 'embed', 'start': 989.071, 'weight': 0, 'content': [{'end': 995.558, 'text': 'With this card view open, I can click on this ellipsis down here and here I have the option to share my script.', 'start': 989.071, 'duration': 6.487}, {'end': 996.359, 'text': "Let's click on this.", 'start': 995.638, 'duration': 0.721}, {'end': 1005.429, 'text': 'This opens up a prompt and basically anyone who has access to this workbook, I can also make it so they have access to this script.', 'start': 997.2, 'duration': 8.229}, {'end': 1007.651, 'text': "That sounds good, so I'll click on share.", 'start': 1005.829, 'duration': 1.822}, {'end': 1010.775, 'text': 'And just like that, my script has now been shared.', 'start': 1008.052, 'duration': 2.723}, {'end': 1018.92, 'text': 'So if anyone else comes in and opens up this workbook, they can click into this workbook and they can see all of the different shared scripts.', 'start': 1011.215, 'duration': 7.705}], 'summary': 'The speaker shares a script in a card view, allowing access to others in the workbook.', 'duration': 29.849, 'max_score': 989.071, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228989071.jpg'}, {'end': 1048.219, 'src': 'heatmap', 'start': 1019.3, 'weight': 0.758, 'content': [{'end': 1022.963, 'text': 'And here you see cookies sold formatting is one of those shared scripts.', 'start': 1019.3, 'duration': 3.663}, {'end': 1030.387, 'text': "Now that I've shared my workbook, I want to show you how we can use Power Automate to kick off your script.", 'start': 1023.543, 'duration': 6.844}, {'end': 1035.131, 'text': 'and before we do that, I simply want to undo some of the changes that this script made.', 'start': 1030.968, 'duration': 4.163}, {'end': 1039.453, 'text': "So here I'll delete the profit column and let me just get rid of the bolding here.", 'start': 1035.55, 'duration': 3.903}, {'end': 1041.994, 'text': "I'm going to leave the currency formatting as is.", 'start': 1039.813, 'duration': 2.181}, {'end': 1048.219, 'text': "If you've never heard of Power Automate before, it's kind of like the service if this then that.", 'start': 1042.734, 'duration': 5.485}], 'summary': 'Using power automate to kick off shared script, undo changes made, and delete profit column.', 'duration': 28.919, 'max_score': 1019.3, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281019300.jpg'}, {'end': 1121.61, 'src': 'heatmap', 'start': 1076.79, 'weight': 3, 'content': [{'end': 1078.971, 'text': 'Or maybe I get a message in Microsoft Teams.', 'start': 1076.79, 'duration': 2.181}, {'end': 1080.952, 'text': 'That can be a trigger for my script.', 'start': 1079.251, 'duration': 1.701}, {'end': 1082.853, 'text': 'I could even set up a schedule.', 'start': 1081.412, 'duration': 1.441}, {'end': 1090.656, 'text': 'Maybe I could set it up so every single week on Monday afternoon it simply runs this script so I could decide when it should run.', 'start': 1083.033, 'duration': 7.623}, {'end': 1097.739, 'text': "To get to Power Automate, let's go up to the top left-hand corner and once again let's click on the app launcher or the waffle.", 'start': 1091.296, 'duration': 6.443}, {'end': 1101.841, 'text': 'Within this list, you should see an option for Power Automate.', 'start': 1098.599, 'duration': 3.242}, {'end': 1106.403, 'text': "If you don't see it in this initial list, you can also go down and click on All Apps.", 'start': 1102.341, 'duration': 4.062}, {'end': 1108.544, 'text': "I see it here, so I'll click on this.", 'start': 1106.843, 'duration': 1.701}, {'end': 1117.068, 'text': "This opens up Power Automate, and once again, if you've never used it before, you can see a whole bunch of different examples of when you can use it.", 'start': 1109.204, 'duration': 7.864}, {'end': 1121.61, 'text': "Over on the left-hand side, I'll click on Create to create a new flow.", 'start': 1117.748, 'duration': 3.862}], 'summary': 'Using power automate to schedule and trigger scripts in microsoft teams.', 'duration': 44.82, 'max_score': 1076.79, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281076790.jpg'}, {'end': 1163.524, 'src': 'embed', 'start': 1137.867, 'weight': 1, 'content': [{'end': 1143.111, 'text': "Now for now, I just want to show a very basic example, so I'll click on instant cloud flow right here.", 'start': 1137.867, 'duration': 5.244}, {'end': 1145.852, 'text': "Basically, I'm going to initiate this flow.", 'start': 1143.431, 'duration': 2.421}, {'end': 1149.575, 'text': 'This opens up a screen where I can start building my flow.', 'start': 1146.353, 'duration': 3.222}, {'end': 1153.678, 'text': "Here for the flow name, I'll simply call this format cookie sales data.", 'start': 1149.915, 'duration': 3.763}, {'end': 1158, 'text': "Once I finish typing in my name, I'll select manually trigger a flow.", 'start': 1154.418, 'duration': 3.582}, {'end': 1161.403, 'text': 'Once again, I can have all sorts of different triggers for my flow.', 'start': 1158.261, 'duration': 3.142}, {'end': 1163.524, 'text': "Right down here, I'll click on create.", 'start': 1161.943, 'duration': 1.581}], 'summary': 'Demonstrating basic flow creation with manual trigger for cookie sales data.', 'duration': 25.657, 'max_score': 1137.867, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281137867.jpg'}, {'end': 1207.902, 'src': 'heatmap', 'start': 1158.261, 'weight': 0.782, 'content': [{'end': 1161.403, 'text': 'Once again, I can have all sorts of different triggers for my flow.', 'start': 1158.261, 'duration': 3.142}, {'end': 1163.524, 'text': "Right down here, I'll click on create.", 'start': 1161.943, 'duration': 1.581}, {'end': 1166.346, 'text': 'Here now I can start building out my flow.', 'start': 1163.964, 'duration': 2.382}, {'end': 1170.529, 'text': 'And right here, I see that the first step is just manually triggering this flow.', 'start': 1166.466, 'duration': 4.063}, {'end': 1172.07, 'text': "I'll click on new step.", 'start': 1170.949, 'duration': 1.121}, {'end': 1174.491, 'text': 'And here now I can choose what the next step is.', 'start': 1172.23, 'duration': 2.261}, {'end': 1179.755, 'text': 'Now I have this script in Excel online, and this is a work or school account.', 'start': 1175.032, 'duration': 4.723}, {'end': 1181.616, 'text': "So it's Excel online business.", 'start': 1179.815, 'duration': 1.801}, {'end': 1184.118, 'text': "I'll select this option as my next step.", 'start': 1182.057, 'duration': 2.061}, {'end': 1188.682, 'text': 'For Excel Online, there are all sorts of different actions I can take.', 'start': 1184.919, 'duration': 3.763}, {'end': 1190.524, 'text': 'Now, I want to run my script.', 'start': 1189.023, 'duration': 1.501}, {'end': 1194.188, 'text': 'So right here in this list, I see the option to run the script.', 'start': 1190.684, 'duration': 3.504}, {'end': 1196.19, 'text': "I'll select this option right here.", 'start': 1194.608, 'duration': 1.582}, {'end': 1199.493, 'text': 'Next, I need to define where my file is.', 'start': 1196.63, 'duration': 2.863}, {'end': 1203.077, 'text': 'Right here, first off, I need to select the location.', 'start': 1200.014, 'duration': 3.063}, {'end': 1207.902, 'text': "And for my location, this file is stored in OneDrive for Business, so I'll pick this.", 'start': 1203.457, 'duration': 4.445}], 'summary': 'Creating a flow in excel online with onedrive for business, involving manual triggers and script execution.', 'duration': 49.641, 'max_score': 1158.261, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281158261.jpg'}, {'end': 1210.844, 'src': 'embed', 'start': 1179.815, 'weight': 2, 'content': [{'end': 1181.616, 'text': "So it's Excel online business.", 'start': 1179.815, 'duration': 1.801}, {'end': 1184.118, 'text': "I'll select this option as my next step.", 'start': 1182.057, 'duration': 2.061}, {'end': 1188.682, 'text': 'For Excel Online, there are all sorts of different actions I can take.', 'start': 1184.919, 'duration': 3.763}, {'end': 1190.524, 'text': 'Now, I want to run my script.', 'start': 1189.023, 'duration': 1.501}, {'end': 1194.188, 'text': 'So right here in this list, I see the option to run the script.', 'start': 1190.684, 'duration': 3.504}, {'end': 1196.19, 'text': "I'll select this option right here.", 'start': 1194.608, 'duration': 1.582}, {'end': 1199.493, 'text': 'Next, I need to define where my file is.', 'start': 1196.63, 'duration': 2.863}, {'end': 1203.077, 'text': 'Right here, first off, I need to select the location.', 'start': 1200.014, 'duration': 3.063}, {'end': 1207.902, 'text': "And for my location, this file is stored in OneDrive for Business, so I'll pick this.", 'start': 1203.457, 'duration': 4.445}, {'end': 1210.844, 'text': 'Next, I need to choose a document library.', 'start': 1208.422, 'duration': 2.422}], 'summary': 'Using excel online, selecting and running script, defining file location in onedrive for business.', 'duration': 31.029, 'max_score': 1179.815, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281179815.jpg'}, {'end': 1283.48, 'src': 'heatmap', 'start': 1219.132, 'weight': 0.707, 'content': [{'end': 1225.298, 'text': "I'll click on this file picker right here, and this opens up a view of all of my folders in OneDrive,", 'start': 1219.132, 'duration': 6.166}, {'end': 1227.48, 'text': 'and at the very bottom I see my different spreadsheets.', 'start': 1225.298, 'duration': 2.182}, {'end': 1230.963, 'text': "Now my spreadsheet is called cookies sold, so I'll select this one.", 'start': 1227.82, 'duration': 3.143}, {'end': 1235.086, 'text': 'Now at the very bottom, I need to select the script that I want to run.', 'start': 1231.383, 'duration': 3.703}, {'end': 1241.311, 'text': "When I click on this drop down here, I see that there's only one script and it's called cookies sold formatting.", 'start': 1235.526, 'duration': 5.785}, {'end': 1243.052, 'text': "So I'll select this one right here.", 'start': 1241.411, 'duration': 1.641}, {'end': 1245.995, 'text': "Now that I'm all done, I'll click on save.", 'start': 1243.833, 'duration': 2.162}, {'end': 1251.179, 'text': 'To test out my new flow over on the left hand side, I can click on my flows.', 'start': 1246.455, 'duration': 4.724}, {'end': 1254.882, 'text': 'And right here I see format cookie sales data.', 'start': 1251.979, 'duration': 2.903}, {'end': 1259.265, 'text': 'I could click on this run or this play icon to run my script.', 'start': 1255.302, 'duration': 3.963}, {'end': 1260.046, 'text': "Let's click on this.", 'start': 1259.385, 'duration': 0.661}, {'end': 1262.968, 'text': 'This opens up a pane over on the right hand side.', 'start': 1260.586, 'duration': 2.382}, {'end': 1264.308, 'text': "I'll click on run flow.", 'start': 1262.988, 'duration': 1.32}, {'end': 1267.63, 'text': 'And here it said your flow run successfully started.', 'start': 1264.849, 'duration': 2.781}, {'end': 1268.611, 'text': 'That looks good.', 'start': 1267.651, 'duration': 0.96}, {'end': 1269.792, 'text': "Next, I'll click on done.", 'start': 1268.811, 'duration': 0.981}, {'end': 1276.796, 'text': "Back now on the Excel start page, I'll click into my cookies sold sheet and let's see if the formatting was applied.", 'start': 1270.232, 'duration': 6.564}, {'end': 1278.657, 'text': 'And look at this.', 'start': 1277.417, 'duration': 1.24}, {'end': 1283.48, 'text': 'Here I see all of my different column headers have been bolded and here all of the cookie types.', 'start': 1278.818, 'duration': 4.662}], 'summary': "Using onedrive, a script is run to format and successfully apply changes to the 'cookies sold' spreadsheet.", 'duration': 64.348, 'max_score': 1219.132, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281219132.jpg'}], 'start': 819.464, 'title': 'Automating office scripts', 'summary': 'Demonstrates using office scripts to automate excel formatting tasks, covering steps like selecting cells, setting bold, changing font, and removing formatting. it also covers modifying, sharing, and automating script execution using typescript and power automate.', 'chapters': [{'end': 906.976, 'start': 819.464, 'title': 'Office scripts demonstration', 'summary': 'Demonstrates how to use office scripts to automate formatting tasks in excel, including selecting cells, setting them to bold, changing font, and removing formatting steps, with a focus on the step-by-step process and the capability to modify properties.', 'duration': 87.512, 'highlights': ['Office Scripts automatically comments against the code, providing clarity and transparency in the automation process. The comments in Office Scripts provide clarity and transparency in the automation process, enhancing the understanding and maintenance of the code.', 'The script selects cells A3 through A9 and makes them bold, demonstrating the step-by-step process of selecting a range, getting formatting, font, and setting it to bold. The script demonstrates the step-by-step process of selecting a range and making it bold, providing a clear example of the automation process in Office Scripts.', 'The capability to modify properties, such as changing bold to true or false, is showcased, exemplifying the flexibility of Office Scripts in customizing formatting tasks. The demonstration of modifying the bold property showcases the flexibility of Office Scripts in customizing formatting tasks, enabling users to tailor the automation process according to their requirements.', 'The process of identifying and removing a step, such as removing the unintended formatting, is illustrated, highlighting the ease of managing and modifying automation steps in Office Scripts. The demonstration of identifying and removing an unintended formatting step highlights the ease of managing and modifying automation steps in Office Scripts, enhancing the adaptability and control over the automation process.']}, {'end': 1293.167, 'start': 907.417, 'title': 'Automating script sharing and execution', 'summary': 'Demonstrates how to modify, share, and automate the execution of office scripts using typescript, with an emphasis on sharing scripts and using power automate to initiate script execution.', 'duration': 385.75, 'highlights': ['Demonstrating how to share Office scripts with others and showcasing the sharing process on OneDrive, enabling others to access and run shared scripts within the workbook. The speaker illustrates the process of sharing Office scripts on OneDrive, allowing others with access to the workbook to run the shared scripts.', 'Showing the utilization of Power Automate to schedule and automatically trigger the execution of Office scripts, such as running scripts in response to specific events like receiving an email or a message in Microsoft Teams. The chapter illustrates the functionality of Power Automate in automating the execution of Office scripts, including the ability to schedule script runs and trigger them based on specific events like receiving emails or messages.', 'Detailing the process of modifying and reverting changes made by a script in the workbook, including deleting specific columns and undoing formatting changes. The speaker explains the process of modifying and reverting changes made by a script in the workbook, such as deleting specific columns and undoing formatting changes.']}], 'duration': 473.703, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx228819464.jpg', 'highlights': ['The capability to modify properties, such as changing bold to true or false, is showcased, exemplifying the flexibility of Office Scripts in customizing formatting tasks.', 'The process of identifying and removing a step, such as removing the unintended formatting, is illustrated, highlighting the ease of managing and modifying automation steps in Office Scripts.', 'Showing the utilization of Power Automate to schedule and automatically trigger the execution of Office scripts, such as running scripts in response to specific events like receiving an email or a message in Microsoft Teams.', 'Demonstrating how to share Office scripts with others and showcasing the sharing process on OneDrive, enabling others to access and run shared scripts within the workbook.']}, {'end': 1509.156, 'segs': [{'end': 1408.493, 'src': 'embed', 'start': 1369.909, 'weight': 1, 'content': [{'end': 1373.471, 'text': "So I'm going to go back to Power Automate and let's see if it can make these changes.", 'start': 1369.909, 'duration': 3.562}, {'end': 1378.593, 'text': "Back within Power Automate, I'll select my new flow and let me click on the run icon.", 'start': 1374.051, 'duration': 4.542}, {'end': 1382.635, 'text': "Right down here, I'll run the flow and it looks like it successfully ran it.", 'start': 1378.893, 'duration': 3.742}, {'end': 1385.537, 'text': "Let's now jump back into Excel and look at that.", 'start': 1382.735, 'duration': 2.802}, {'end': 1392.08, 'text': "Right now I'm back in Excel and it looks like it automatically applied all of my changes to this specific worksheet.", 'start': 1385.697, 'duration': 6.383}, {'end': 1399.384, 'text': "So far, we've just looked at a very simple example of how you can use Power Automate to kick off your Office script.", 'start': 1392.5, 'duration': 6.884}, {'end': 1403.348, 'text': 'But you can also use much more advanced scenarios.', 'start': 1399.844, 'duration': 3.504}, {'end': 1408.493, 'text': 'You could also take data from Power Automate and you can feed it into your script.', 'start': 1403.808, 'duration': 4.685}], 'summary': 'Power automate successfully ran a simple flow, applying changes to an excel worksheet.', 'duration': 38.584, 'max_score': 1369.909, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281369909.jpg'}, {'end': 1459.353, 'src': 'embed', 'start': 1431.324, 'weight': 0, 'content': [{'end': 1437.766, 'text': "Maybe your script will determine who's on point and then it could send that data to Power Automate and that could connect with Outlook.", 'start': 1431.324, 'duration': 6.442}, {'end': 1439.106, 'text': 'that then sends out an email.', 'start': 1437.766, 'duration': 1.34}, {'end': 1442.887, 'text': 'All of that is possible with Office scripts together with Power Automate.', 'start': 1439.566, 'duration': 3.321}, {'end': 1448.289, 'text': "Hopefully by now you're starting to get a sense for how much power Office scripts have.", 'start': 1443.627, 'duration': 4.662}, {'end': 1453.21, 'text': 'And when you combine that together with Power Automate, you get, well, a lot of power.', 'start': 1448.789, 'duration': 4.421}, {'end': 1459.353, 'text': "If you're curious about how you take this to the next level and all the different things that are possible with it,", 'start': 1453.911, 'duration': 5.442}], 'summary': 'Office scripts can send data to power automate to connect with outlook, offering a lot of power when combined.', 'duration': 28.029, 'max_score': 1431.324, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281431324.jpg'}, {'end': 1509.156, 'src': 'embed', 'start': 1490.092, 'weight': 3, 'content': [{'end': 1493.095, 'text': 'If this video helped you, please give it a thumbs up.', 'start': 1490.092, 'duration': 3.003}, {'end': 1496.759, 'text': 'To see more videos like this, please consider subscribing.', 'start': 1493.795, 'duration': 2.964}, {'end': 1502.527, 'text': 'Also, if you want to see me cover any other topics on this channel, leave a note down below.', 'start': 1497.5, 'duration': 5.027}, {'end': 1505.591, 'text': "Alright, well that's all I had for you today.", 'start': 1502.547, 'duration': 3.044}, {'end': 1509.076, 'text': 'I hope you enjoyed and as always, I hope to see you next time.', 'start': 1505.611, 'duration': 3.465}, {'end': 1509.156, 'text': 'Bye.', 'start': 1509.096, 'duration': 0.06}], 'summary': 'Video encourages likes, subscriptions, and feedback. ends with a positive farewell.', 'duration': 19.064, 'max_score': 1490.092, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281490092.jpg'}], 'start': 1293.187, 'title': 'Updating and leveraging power automate', 'summary': 'Covers updating a specific worksheet in power automate and leveraging office scripts to exchange data, enabling advanced scenarios, and demonstrating potential capabilities with a link provided for further exploration.', 'chapters': [{'end': 1385.537, 'start': 1293.187, 'title': 'Updating specific worksheet in power automate', 'summary': 'Demonstrates updating a specific worksheet in power automate by modifying the script to reference a particular worksheet and successfully running the flow to make the changes in excel.', 'duration': 92.35, 'highlights': ["Modifying the script to reference a specific worksheet by changing 'get active worksheet' to 'get worksheet 4-10-2021' resulted in successfully updating the second worksheet.", 'Running the flow in Power Automate successfully made the desired changes in Excel after modifying the script.', "Using 'Automate' and 'All Scripts' on the top toolbar allows accessing and editing the script in Power Automate."]}, {'end': 1509.156, 'start': 1385.697, 'title': 'Leveraging office scripts and power automate', 'summary': 'Introduces the integration of office scripts and power automate, showcasing how data can be exchanged between the two platforms, enabling advanced scenarios and a demonstration of the potential capabilities, with a link provided for further exploration.', 'duration': 123.459, 'highlights': ['The combination of Office scripts and Power Automate allows for advanced scenarios, such as receiving emails and feeding sender and subject data back into the script, and sending out emails through Power Automate based on script-determined criteria.', 'The video provides a link for additional information on getting started, scripting fundamentals, and various sample scripts, offering an extensive resource for learning and exploring the possibilities.', 'The demonstration highlights the seamless application of changes in Excel through Power Automate, showcasing practical implementation and automation capabilities.', 'The narrator encourages engagement by requesting likes, subscriptions, and topic suggestions, fostering community interaction and feedback for future content.']}], 'duration': 215.969, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/il7YS7Dx228/pics/il7YS7Dx2281293187.jpg', 'highlights': ['The combination of Office scripts and Power Automate allows for advanced scenarios, such as receiving emails and feeding sender and subject data back into the script, and sending out emails through Power Automate based on script-determined criteria.', 'The demonstration highlights the seamless application of changes in Excel through Power Automate, showcasing practical implementation and automation capabilities.', 'Running the flow in Power Automate successfully made the desired changes in Excel after modifying the script.', 'The video provides a link for additional information on getting started, scripting fundamentals, and various sample scripts, offering an extensive resource for learning and exploring the possibilities.']}], 'highlights': ["The company's weekly profit amounts to 2.3 million.", 'Office scripts automate repetitive tasks in Excel on the web, saving considerable time by recording and playing back manual steps, such as formatting changes and formula calculations, reducing the need for repetitive manual work.', 'The process of creating scripts in Office involves recording actions, integrating recorded chunks, and automating repetitive tasks.', 'The capability to modify properties, such as changing bold to true or false, is showcased, exemplifying the flexibility of Office Scripts in customizing formatting tasks.', 'The combination of Office scripts and Power Automate allows for advanced scenarios, such as receiving emails and feeding sender and subject data back into the script, and sending out emails through Power Automate based on script-determined criteria.']}