Office Scripts are a new and exciting 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 use this powerful automation tool!
Learning Objectives
• Identify 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
• Differentiate two ways of sharing an Office Script with other users
Major Topics
• Introduction to Office Scripts
• Recording your first script
• Integration with Power Automate