Building Excel Online Automation with Office Scripts

Office Scripts for Excel helps users automate web-based spreadsheets. This course will teach you recording, editing, and debugging Office Scripts, while comparing with existing macro automation using VBA.

With more of Excel functionality going online, Excel automation will migrate from VBA into new Office Scripts. In this course, Building Excel Online Automation with Office Scripts, you’ll learn to create your own macros using the Office Scripts tool in Excel Online. First, you’ll explore what makes Office Scripts different than other frameworks. Next, you’ll discover how to record a macro using Office Scripts. Finally, you’ll learn how to customize and write your own macros using Office Scripts. When you’re finished with this course, you’ll have the skills and knowledge of Office Scripts in Excel needed to automate Excel Online spreadsheets.

• Course Overview 1min
• Contrasting Office Scripts to Other Office Automation Technology 17mins
• Recording an Office Script 12mins
• Customizing a Recorded Office Script 20mins
• Adding New Code to an Office Script 30mins
• Integrating External Data Using Power Automate 22mins