Содержание
Course Overview 1m 45s Course Overview 1m 45sContrasting Office Scripts to Other Office Automation Technology 17m 9s History of Excel Automation 6m 31s Gaps in Existing Framework 6m 22s Introducing Office Scripts 3m 19s Summary 55sRecording an Office Script 12m 9s Introduction 31s Demo - Enabling Office Scripts in Microsoft 365 1m 48s Macro Security in VBA 1m 14s Demo - Recording and Running an Office Script 2m 3s Demo - Recording and Running a VBA Macro 1m 3s Comparing Office Scripts and VBA 4m 55s Summary 32sCustomizing a Recorded Office Script 20m 58s Identification of Issues in a Recorded Script 4m 8s Demo - Deleting Incorrect Actions from a Recorded Script 3m 3s Demo - Adding New Actions to a Recorded Script 9m 52s Demo - Recording New Actions to a Temporary Script 3m 24s Summary 29sAdding New Code to an Office Script 30m 29s Getting Started with a New Script 1m 24s Comparing Variables in Office Script to VBA 4m 38s Program Flow – Office Script vs. VBA 4m 20s Assigning Sheets and Ranges 6m 32s Changing Properties for a Range 3m 42s Demo - Writing an Office Script 8m 59s Summary 52sIntegrating External Data Using Power Automate 22m 3s Why Do We Need Parameters in Scripts? 2m 56s Configuring the Office Script Action 3m 46s Demo - Triggering a Script from Power Automate 3m 18s Adding Parameters to an Office Script 4m 44s Demo - Using Office Scripts with Power Apps Parameters 5m 42s Summary and Conclusion 1m 34s