Google Sheet with Scripts
Master Google Sheets formulas, dashboards and Apps Script automation with real capstone projects.
Course highlights
Sujeet Sir
21 Years Exp.
Excel | VBA | Power BI | SQL | Python
Data Analytics Expert & Corporate Trainer
- Sujeet Kumar Singh (MCA), founder of IPT Excel School since 2007
- Worked as MIS Executive and VBA Developer in 10+ companies
- Report consultant for 40+ organizations
What you will learn
Validation, IMPORTRANGE, QUERY, FILTER and ARRAYFORMULA.
Script editor, first macro and triggers.
JavaScript for Sheets: functions, loops, ranges and debugging.
Cleaning, daily and weekly reports and archive sheets.
Gmail, Drive, Forms and Calendar automation.
Dynamic charts, slicers and auto-updating dashboards.
JSON, live data, a custom CRM and real-time input.
Invoice generator, attendance system, task tracker and report cards.
BENEFITS
- Work from anywhere with shared live sheets
- Automate repeated tasks with scripts
- Connect Sheets with Gmail, Drive, Forms and APIs
YOUR GOAL
Build a Google Sheets tool that runs on its own.
WHO SHOULD LEARN
Teams that work in Google Sheets and want to automate.
COURSE OUTLINE
⬇ Download PDFModule 1 - Google Sheets essentials
- Formatting and shortcuts
- Data validation
- Conditional formatting
- IMPORTRANGE, IMPORTHTML and GOOGLEFINANCE
- IF, VLOOKUP, FILTER, QUERY and ARRAYFORMULA
Module 2 - Introduction to Google Apps Script
- What is Apps Script
- Script editor
- Writing your first macro
- Triggers (time-based, onEdit, onFormSubmit)
Module 3 - Scripting fundamentals (JavaScript for Sheets)
- Variables
- Functions
- Conditions and loops
- Ranges, sheets and cell values
- Custom functions
- Error handling and debugging
Module 4 - Data automation projects
- Automated cleaning and formatting
- Daily and weekly reports
- Moving data to archive sheets
- Summary sheets
- Google Translate and other web services
Module 5 - Google Workspace integration
- Gmail auto-emails
- Drive folders and files
- Google Forms submissions
- Calendar reminders and auto-docs
Module 6 - Dashboard design in Google Sheets
- Dynamic charts
- Drop-downs and slicers
- Linked charts with QUERY and IMPORTRANGE
- Auto-updating dashboards
Module 7 - APIs and webhooks
- APIs and JSON
- Live data (weather, currency)
- A custom CRM with an external API
- Webhooks for real-time data input
Module 8 - Capstone projects
- Automated invoice generator
- Employee attendance system
- Task tracker with auto e-mail alerts
- Student marksheet with dynamic report cards
Final assessment and certificate
- Capstone project
- Q and A
- Viva
- Feedback and certification
COURSE DETAILS
| Duration | 40 hours |
|---|---|
| Level | Advanced |
| Class time | Mon to Fri: 1 hour daily, or Sat and Sun: 2-hour classes |
| Batch size | 1 to 3 students (one-to-one or small group) |
| Mode | Live online on Google Meet |
| Language | Hindi or English |
| Certificate | Yes, with real project work |
| Support | Phone and Google Meet doubt support |
| Demo | Free 3-4 day demo class |
| Fees | Contact Sujeet Sir: +91 88025 79388 |
HOW IT IS TAUGHT
Live on Google Meet by Sujeet Sir in Hindi or English, with real company examples, projects, a certificate and doubt support on phone after the course.
Join a free demo
Questions about this course
What is the fee of the Google Sheet with Scripts course?
Fees depend on one-to-one or group batch. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.
Is there a free demo?
Yes. Join the 3-4 day free demo before you pay.
Which language is it taught in?
Hindi or English, as you prefer.