Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App

Office Scripts Beginner Course: 5 Free Lessons

🤖
← All courses

Office Scripts Beginner Course: 5 Free Lessons

📘 5 / 5 lessons⬇️ 5 practice files🌱 Beginner💸 Free

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 Basics: Automate Excel in the BrowserFind the used range, add tables, read and add table rows, sort and filter tables, and total columns — the core of…
  4. 4Office Scripts Advanced: Tables, Charts and AutomationClean 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.

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →