Introduction to Office Scripts & How to Tweak Macros to Automate Tasks in Excel

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

Get started with Office Scripts. Similar to Excel VBA macros, Office Scripts allow users to automate tasks in Excel. The fundamental difference is that VBA macros are developed for desktop solutions and Office Scripts are currently only supported by Excel on the web (and in Excel for Teams).

We'll record a macro to automatically create a column chart for different data ranges. I'll also show you how you can review and edit your code in the code editor. For example how to make the fixed selected range dynamic by adjusting the recorded macro in Office Scripts. We will use variables and getSurroundingRegion to create dynamic ranges. I will also show you how to use Console.log to debug your code and how to make your chart title dynamic by using a cell reference instead of a fixed title.

00:00 Introduction to Office Scripts
00:38 How to Record a Macro in Office Scripts (Record Actions)
04:15 Review the Code in the Code Editor
06:00 How to Run a Macro
06:34 How to Adjust the Script for Dynamic Ranges
08:26 Dynamic Ranges with Office Scripts
09:36 How to Debug Code with Console.Log
11:03 Use Existing Scripts on Different Spreadsheets
12:09 Script Editing Options
13:16 How to Run Office Scripts in Microsoft Teams
13:47 Wrap Up

LINK to video comparing VBA to Office Scripts: Excel VBA VS Office Scripts:    • Do You Need to SWITCH from Excel VBA ...  

LINK to Excel VBA video that records a similar macro with VBA:    • How to Create & Use Excel Macros (Rea...  

Link to the complete blog post: https://www.xelplus.com/office-script...

★★★ My Online Excel Courses ► https://www.xelplus.com/courses/

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ 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:   / lgharani  
LinkedIn:   / 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!

#excel #officescripts