Building Excel Online Automation with Office Scripts
by Brent Allen
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.
About the author
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,... more 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.