Overview
Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!
Prerequisites
Fundamental knowledge of basic computer operations
Objectives
- List three benefits of using Office Scripts over legacy VBA macros
- Distinguish the storage locations for Office scripts vs. VBA macros
- Identify four reasons why Office Scripts may not be available for use
- List two ways of sharing an Office Script with other users
Highlights
- Introduction to Office Scripts
- Recording your first script
- Integration with Power Automate