Building Excel Online Automation with Office Scripts

Focused View

Brent Allen

3:28:42

39 View

0. Course Overview

0. Course Overview.mp4

01:45

0. Course Overview (2).mp4

01:45

1. Contrasting Office Scripts to Other Office Automation Technology

0. History of Excel Automation.mp4

06:31

0. History of Excel Automation (2).mp4

06:31

1. Gaps in Existing Framework.mp4

06:22

1. Gaps in Existing Framework (2).mp4

06:22

2. Introducing Office Scripts.mp4

03:19

2. Introducing Office Scripts (2).mp4

03:19

3. Summary.mp4

00:55

3. Summary (2).mp4

00:55

2. Recording an Office Script

0. Introduction.mp4

00:31

0. Introduction (2).mp4

00:31

1. Demo - Enabling Office Scripts in Microsoft 365.mp4

01:48

1. Demo - Enabling Office Scripts in Microsoft 365 (2).mp4

01:48

2. Macro Security in VBA.mp4

01:14

2. Macro Security in VBA (2).mp4

01:14

3. Demo - Recording and Running an Office Script.mp4

02:03

3. Demo - Recording and Running an Office Script (2).mp4

02:03

4. Demo - Recording and Running a VBA Macro.mp4

01:03

4. Demo - Recording and Running a VBA Macro (2).mp4

01:03

5. Comparing Office Scripts and VBA.mp4

04:55

5. Comparing Office Scripts and VBA (2).mp4

04:55

6. Summary.mp4

00:32

6. Summary (2).mp4

00:32

3. Customizing a Recorded Office Script

0. Identification of Issues in a Recorded Script.mp4

04:08

0. Identification of Issues in a Recorded Script (2).mp4

04:08

1. Demo - Deleting Incorrect Actions from a Recorded Script.mp4

03:03

1. Demo - Deleting Incorrect Actions from a Recorded Script (2).mp4

03:03

2. Demo - Adding New Actions to a Recorded Script.mp4

09:52

2. Demo - Adding New Actions to a Recorded Script (2).mp4

09:52

3. Demo - Recording New Actions to a Temporary Script.mp4

03:24

3. Demo - Recording New Actions to a Temporary Script (2).mp4

03:24

4. Summary.mp4

00:29

4. Summary (2).mp4

00:29

4. Adding New Code to an Office Script

0. Getting Started with a New Script.mp4

01:24

0. Getting Started with a New Script (2).mp4

01:24

1. Comparing Variables in Office Script to VBA.mp4

04:38

1. Comparing Variables in Office Script to VBA (2).mp4

04:38

2. Program Flow Office Script vs. VBA.mp4

04:20

2. Program Flow Office Script vs. VBA (2).mp4

04:20

3. Assigning Sheets and Ranges.mp4

06:32

3. Assigning Sheets and Ranges (2).mp4

06:32

4. Changing Properties for a Range.mp4

03:42

4. Changing Properties for a Range (2).mp4

03:42

5. Demo - Writing an Office Script.mp4

08:59

5. Demo - Writing an Office Script (2).mp4

08:59

6. Summary.mp4

00:52

6. Summary (2).mp4

00:52

5. Integrating External Data Using Power Automate

0. Why Do We Need Parameters in Scripts.mp4

02:56

0. Why Do We Need Parameters in Scripts (2).mp4

02:56

1. Configuring the Office Script Action.mp4

03:46

1. Configuring the Office Script Action (2).mp4

03:46

2. Demo - Triggering a Script from Power Automate.mp4

03:18

2. Demo - Triggering a Script from Power Automate (2).mp4

03:18

3. Adding Parameters to an Office Script.mp4

04:44

3. Adding Parameters to an Office Script (2).mp4

04:44

4. Demo - Using Office Scripts with Power Apps Parameters.mp4

05:42

4. Demo - Using Office Scripts with Power Apps Parameters (2).mp4

05:42

5. Summary and Conclusion.mp4

01:34

5. Summary and Conclusion (2).mp4

01:34

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Brent Allen

Instructor's Courses

Brent Allen is a finance and technology professional with an MBA from Queen's University and is a Certified Professional Accountant in Canada. He has worked as a finance and technology professional for large businesses across multiple sectors, including TD Securities, McDonald's and BentallGreenOak. In his roles as a financial and business analyst, he has been responsible for automating key financial processes using Excel, Access and VBA. He has acted as a system owner for key financial systems, training both finance and technology teams on processes and systems. He believes in the constant improvement of financial processes using the Microsoft Power Platform, as well as other modern methods for ingestion, analysis and presentation of data. When not deep in a spreadsheet or database, he enjoys following the local Toronto sports teams, and is an avid NFL fantasy football team manager.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.