Introductory Excel Office Scripts with Typescript/Javascript course

Learn to automate Excel by programming Office Scripts for Excel with TypeScript/JavaScript - Training contents

Microsoft Excel and the Office package can be automated by recording and programming so-called Office Scripts (as an alternative to VBA macros). The scripts are produced in a language called Javascript, or its very close relative Typescript. With our training courses for automating desktop and cloud Excel with Javascript/Typescript, you will learn to program Excel as well as the advantages and disadvantages of this technology.

Perhaps you were looking for our VBA macro courses for Excel instead?

Our intensive Office Scripts basics training in script programming for Excel teaches you how to use and code Office Scripts in Excel to automate Excel work tasks and reporting as well as to extend Excel features by programming functions. This introductory Office Scripts course for beginners also answers the question "what are Office Scripts".

Recording Excel Office Scripts 

  • Introduction to Office Scripts 
  • Setting up necessary pre-requisites
  • Recording your first Office Script with the Action Recorder
  • Automating common tasks in Excel using Office Scripts

Crash course/refresher in Typescript/Javascript

(If you are already familiar with Javascript/Typescript, you could skip this part.)

  • Javascript/Typescript in the browser (the console)
  • Our Typescript for Excel tutorial and exercises
  • Declare and use variables and constants the right way (let, const)
  • Manage and control program flow - iterations, conditions (if/else, while, for)
  • Create Javascript functions to split code into chunks
  • Understand and access Javascript objects {x: 1, s: "name"} and their methods and properties
  • Arrange and access data series and lists quickly using arrays [1,2,3]  
  • Catch and handle run-time errors (try/catch)
  • Find bugs and step through code

Excel Office Scripts programming environment

  • Set up and get to know ScriptLab, the Office Script code editor and development environment
  • Get an account on Github + what is a Gist?
  • Find and examine Microsoft's sample snippets

Introduction to Excel Office Scripts 

  • Script starting point (main)
  • Common Excel Office Script objects (workbook, worksheet, range)
    • Work with sheet values in data ranges
    • Format data ranges
  • Work with formulas in cells
  • Use named items
  • Use collections
  • Share your Office Scripts online
  • Use Office Scripts in Excel on the web
  • Store and share scripts on OneDrive and set access rights

Examine Microsoft's sample snippets

  • HTML DOM document object model basics and events
  • CSS basics
  • JQuery basics
  • Promises with async/await

Office Scripts: the Excel Object Model

  • Overview: The Excel object model
  • The Excel application object
  • The Excel object structure
  • Load properties
  • Use range with multi-valued properties
  • Office Scripts API reference

Tables: Read from and write to with Office Scripts

  • Create and access (read from and write to) Excel tables
  • Sort and filter Excel tables
  • Format tables

Excel charts and diagrams - create with Office Scripts

  • Create Excel graphs and set their properties
  • Set up chart data structure
  • Format charts, series and axes
  • Use external charts

Use Power Automate on the web to connect Office Scripts

(An optional add-on module.)

  • Create workflows using multiple Office apps and services
  • Manual script calls from Power Automate 
  • Use scripts outside of the Excel workbook
  • Schedule the execution of scripts
  • Set up triggers to run your scripts on certain events
  • Pass data to a Power Automate flow

Content add-ins

Not what you were looking for? 

Let us know and we will tailor a course / service or support to your particular needs!