17COURSE / AUTOMATION & DEVELOPMENT
Automation & Development
Google Sheets & Apps Script
Master Google Sheets for data analysis, collaboration, and automation. From formulas and formatting to Apps Script and advanced data tools, learn the full power of Google's cloud-native spreadsheet.
03
Levels
10
Modules
1:1
Live
Enroll NowLive virtual sessions or on-site training
Google Sheets & Apps Script3 Levels • Live + On-site • Certificate of CompletionEST. 2025 — GROWWM
Topics / 01
What you will learn.
A snapshot of every topic covered across all three levels. Detailed daily curriculum is in the next section.
10Core topics
01Advanced Formulas
02ARRAYFORMULA
03QUERY Function
04Apps Script Basics
05Custom Menus & Triggers
06API Integration
07Sheets & Drive Automation
08Gmail Automation
09Collaborative Workflows
10Add-on Publishing
Curriculum / 02
Three levels.
One path.
Start where you are. Each level builds on the last — from your first formula to enterprise-grade automation.
Build a solid foundation with core concepts and essential skills.
Modules
02 / TOTAL01
Day 1: Spreadsheet Essentials
- Navigating the Google Sheets interface and toolbar
- Creating, renaming, and organizing spreadsheets in Drive
- Cell formatting: fonts, borders, colors, and number formats
- Essential formulas: SUM, AVERAGE, COUNT, IF, COUNTIF
- Absolute and relative cell references
- Conditional formatting rules for visual data highlights
- Sorting, filtering, and creating filter views
02
Day 2: Charts, Collaboration, and Sharing
- Building bar, line, pie, and combo charts
- Formatting and customizing chart appearance
- Sharing settings: viewer, commenter, and editor permissions
- Real-time collaboration and commenting
- Protected ranges and sheets for controlled editing
- Importing data from CSV and connecting to other sheets
- Printing, downloading as Excel/PDF, and version history
After this level
- 01Build formatted spreadsheets with essential formulas and functions
- 02Create charts and apply conditional formatting for data visualization
- 03Collaborate in real-time with sharing, comments, and protection
- 04Import and export data across formats including Excel and CSV
Audience / 03
Built for doers.
Prerequisites
Basic computer literacy.
- 01Teams using Google Workspace
- 02Analysts and project managers in cloud-first organizations
- 03Anyone transitioning from Excel to Google Sheets
Continue / 06