Spreadsheets & Data

Google Sheets Automation & Scripting

Stop redoing the same spreadsheet work every week

12 lessons4 modules9h 0m durationbeginner level

Instructor: StretchLearn Faculty

About this course

This beginner course teaches working professionals to eliminate repetitive spreadsheet tasks using Google Sheets' native automation: the macro recorder, dynamic formulas, data validation, pivot tables, and time-driven triggers. Every technique is shown with a real worked example you can copy. You finish with a small library of reusable automations and the judgment to know which tool fits which job.

Curriculum

Module 1: Automating With the Macro Recorder3 lessons

Recording Your First MacroPreview45m
Editing and Naming Macros for Reuse🔒45m
When Macros Are the Wrong Tool🔒45m

Module 2: Formula-Driven Automation3 lessons

Self-Updating Reports With QUERY🔒45m
FILTER, SORT, and Dynamic Arrays🔒45m
Pulling Data In With ARRAYFORMULA and IMPORTRANGE🔒45m

Module 3: Clean Data With Validation and Rules3 lessons

Dropdowns and Data Validation🔒45m
Conditional Formatting That Reacts🔒45m
Catching Errors and Duplicates Automatically🔒45m

Module 4: Scheduled and Connected Automation3 lessons

Time-Driven Triggers and Scheduled Scripts🔒45m
Connecting Google Forms for Live Intake🔒45m
Connected Sheets and Building Your Automation Plan🔒45m