Office Scripts automate Excel on the web (and new Excel for Windows) with TypeScript, the modern replacement for many VBA macros, and they can run from Power Automate on a schedule. Five lessons with ready scripts.

1. 1Office Scripts Lesson 1: What Office Scripts Are and the Action RecorderMeet Office Scripts: where the Automate tab is, licences, recording actions, reading the generated TypeScript, and how Office Scripts differ from VBA.
2. 2Office Scripts Lesson 2: TypeScript Basics for Excel UsersThe TypeScript you need for Office Scripts: let and const, types, if, for loops, arrays from getValues(), functions and console.log for debugging.
3. 3Office Scripts Lesson 3: Working With Ranges and TablesFind the used range, add tables, read and add table rows, sort and filter tables, and total columns — the core of…
4. 4Office Scripts Lesson 4: Formatting and Cleaning DataClean exports with Office Scripts: trim and case text, convert text numbers, remove blank rows, number formats, conditional formatting and freeze panes.
5. 5Office Scripts Lesson 5: Run Scripts From Power AutomateSchedule Office Scripts with Power Automate: Run script action, passing parameters in and returning results, daily refresh of a report file, and…

Related: your first Office Script, Office Scripts automation.