Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Automation in Excel: VBA and Office Scripts

Description

With recorded macros and Office Scripts, an Excel user can create a set of tools to automate and simplify their personal workflows. Visual Basic for Applications has long been the language of automation in Excel, but recently Office Scripts were introduced for workbooks to be automated, even when hosted in SharePoint and OneDrive. This session will illustrate how to create custom shortcuts and handle common issues in seconds.

Topics include:

  • Recording and editing macros for common multi-step processes
  • Developing Office Scripts for standard workflows
  • Customizing the Quick Access Toolbar
  • Creating custom Ribbons for Excel