Office Scripts: Highlight Duplicates in a Table With One Button
A short Office Script for Excel on the web that highlights duplicate values in a chosen column, clears old highlights and runs from a…
Read article →Office Scripts
Automate Excel on the web with TypeScript.
📝
← Automation
Office Scripts
Automate Excel on the web with TypeScript.
📄 8 articles⬇️ 7 with practice files🕒 Updated 12 Nov 2026
🎓 Start here: SAP GUI Scripting Course → 🎓 Start here: AutoHotkey Course → 🎓 Start here: Office Scripts Course →Office Scripts Lesson 5: Run Scripts From Power Automate
Office Scripts Lesson 5: Run Scripts From Power Automate
Schedule Office Scripts with Power Automate: Run script action, passing parameters in and returning results, daily refresh of a report file, and emailing the…
Read article →Office Scripts Advanced: Tables, Charts and Automation
Office Scripts Advanced: Tables, Charts and Automation
Clean exports with Office Scripts: trim and case text, convert text numbers, remove blank rows, number formats, conditional formatting and freeze panes.
Read article →Office Scripts Basics: Automate Excel in the Browser
Office Scripts Basics: Automate Excel in the Browser
Find the used range, add tables, read and add table rows, sort and filter tables, and total columns — the core of most Office…
Read article →Office Scripts Lesson 2: TypeScript Basics for Excel Users
Office Scripts Lesson 2: TypeScript Basics for Excel Users
The TypeScript you need for Office Scripts: let and const, types, if, for loops, arrays from getValues(), functions and console.log for debugging.
Read article →Office Scripts Lesson 1: What Office Scripts Are and the Action Recorder
Office Scripts Lesson 1: What Office Scripts Are and the Action Recorder
Meet Office Scripts: where the Automate tab is, licences, recording actions, reading the generated TypeScript, and how Office Scripts differ from VBA.
Read article →Office Scripts: Automate Excel on the Web Without VBA
Office Scripts: Automate Excel on the Web Without VBA
Office Scripts bring automation to Excel for the web and Microsoft 365. Record a script, read the TypeScript it creates, and write a report-formatting…
Read article →Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
What Office Scripts are, how they differ from VBA, how to record and edit a script, a real clean-up example in TypeScript, and how…
Read article →