6.2 Office Scripts
A repetitive monthly task runs from one button.
Office Scripts are recorded or written in TypeScript, run in Excel on the web, and can be triggered on a schedule through Power Automate, which turns a repetitive monthly task into a button or a timer. The topic follows the choosing topic because scripts are the modern default for automating actions. Recording an action and then reading the generated code is the on-ramp. The common confusion is availability: scripts need the right kind of licence and do not run everywhere the desktop app does, so where they will and will not run is covered on purpose.
Work through these
Recording an action and reading the generated code
Recording an action and then reading what was generated is the fastest way into scripting. The generated code is often longer than it needs to be, which is itself instructive.
Editing the script: ranges, loops, conditions
Editing a recorded script into a useful one means working with ranges, repeating over rows and making decisions. These three ideas cover most practical automation.
Running scripts on a schedule with Power Automate
A script can be triggered on a schedule, or by an event, through the automation service. That is what turns it from a button into a process that runs unattended.
Licensing and where scripts will and will not run
Where scripts run depends on the licence and the platform, and this is worth checking before you build something on them. The limits are administrative rather than technical.
Practice file
- xl-08-automation-monthly.xlsx
A repetitive month-end formatting task, done by hand once, for you to automate.
Opens in Excel. Every name, number and address in these files is made up. No account needed to download.
Sign in to keep your progress.
Free resources
We haven't checked most of these for screen reader use yet.
Links last checked 29 Aug 2026.
Stuck here?
Ask a mentor. A real person answers, and they can see exactly which topic you're on. Usually within a couple of working days.
Checking your session…
Topics shown in module order.