Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
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: youtu.be/DOvHqukAGTY
LINK to Excel VBA video that records a similar macro with VBA: youtu.be/An-2Nxf_Dms
Link to the complete blog post: xelplus.com/office-scripts-macros-on-the-web
★★★ My Online Excel Courses ► xelplus.com/courses/
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz/
🎥 RESOURCES I recommend: xelplus.com/resources/
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: 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!
#excel #officescripts
- Introduction to Office Scripts & How to Tweak Macros to Automate Tasks in Excel ( Download)
- Automate Tasks in Microsoft Excel with Office Scripts ( Download)
- 👩💻 How to use Office Scripts in Excel & Power Automate ( Download)
- Do You Need to SWITCH from Excel VBA Macros to Office Scripts ( Download)
- How to use Office Scripts and Power Automate to do Boring Excel Tasks for You ( Download)
- How to Automate Your Excel Tasks with Office Scripts: A Guide for Beginners ( Download)
- Say Goodbye to Boring Excel Tasks: Create Cool Buttons to Run Office Scripts from ANYWHERE ( Download)
- Automatically Move Completed Tasks to an Archive (with Excel Office Scripts & Power Automate) ( Download)
- Automate your Excel tasks with Office Scripts ( Download)
- Automate Excel with Office Scripts and Power Automate ( Download)
- Automate tasks in Excel Desktop ( Download)
- No More VBA. ChatGPT to automates boring work with Office Scripts ( Download)
- How You can Automate ANY Excel Task - Microsoft Excel Macro Recording ( Download)
- Office Scripts: Top 5 tips to improve your scripting skills in Excel ( Download)
- Excel Automate Office Scripts JavaScript (TypeScript) Programming Tutorial - VBA Equivalent ( Download)
