Course Details
Course Details
What You'll Learn
LU1: Foundations of Google Apps Script and Basic Automation
Topic 1: Getting Started with Google Apps Script
Overview of Google Apps Script and its capabilities
Navigating and utilizing the Google Apps Script Editor
Creating and running basic scripts
Understanding Mail Service and basic automation scripts
Topic 2: Automating Google Sheets with Script
Introduction to Spreadsheet Service
Utilizing Sheet and Range Methods for automation
Manipulating cell values and applying formulas programmatically
LU2: Google Apps Script Functions and Integration
Topic 3: Scripting for Google Docs and Google Slides
Utilizing Document and Slide Services for automation
Scripting methods for text manipulation and slide modification
Integrating Google Docs and Slides with other Google services
Topic 4: Google Calendar and Google Drive Scripting
Automating tasks with Calendar Service, including event creation
Leveraging Drive Service for file and folder management
Implementing API-level integrations with Google Drive and Google Calendar
LU3: Trigger Management and Data Handling
Topic 5: Working with Triggers and Data Management
Setting up Time-Driven Triggers and auto-email alerts
Managing data across Google Apps Script services
Automating file duplication and folder sharing
Topic 6: HTML Services and Web App Development
Utilizing HTML Services for web app creation
Communicating with server functions and deploying web apps
Integrating Google Sheets data into HTML web apps
LU4: Customization and Optimization in Google Apps Script
Topic 7: Custom Menu, Dialogs, and Sidebars
Developing Bound Scripts and Custom Menus in Google Workspace
Utilizing Dialogs and Sidebars for user interaction
Implementing OnOpen Triggers for automation
Topic 8: Creating and Utilizing Custom Functions
Designing custom functions for specific tasks
Troubleshooting and optimizing custom scripts for performance
Addressing compatibility and technical issues in script integration
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
TBD
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Google Apps Script Developer
- IT Automation Specialist
- Technical Project Manager
- Systems Analyst
- Business Process Engineer
- Cloud Solutions Architect
- Data Analyst
- IT Support Specialist
- Workflow Automation Engineer
- Application Developer
- Integration Specialist
- Database Administrator
- Information Systems Manager
- Enterprise Software Developer
- IT Consultant
- Quality Assurance Tester
- Technical Trainer
- DevOps Engineer
- User Experience Designer
- Software Engineer
Trainers
Trainers
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (7)
- Very informative Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 5/27/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Clear and easy to follow Review by Course Participant/Trainee
-
Excellent delivery and good balance between theory and practice. Learned a lot in a short time. (Posted on 4/26/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Great practical training Review by Course Participant/Trainee
-
Excellent delivery and good balance between theory and practice. Learned a lot in a short time. (Posted on 11/17/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Fantastic experience Review by Course Participant/Trainee
-
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 11/5/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Worth every cent Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 8/17/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses