Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Building Excel Online Automation with Office Scripts

via Pluralsight

Overview

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.

Syllabus

  • 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

Taught by

Brent Allen

Reviews

Start your review of Building Excel Online Automation with Office Scripts

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.