You have no items in your shopping cart.
Course Details
Topic 1. Getting Started
- What is Google Apps Script
- Google Apps Script Editor
- Write Your First Google Apps Script
- Mail Service
- Run You Script
Topic 2. Google Sheet Script
- Spreadsheet Service
- Sheet Methods
- Range Methods
- Get and Change Cell Values
- Apply Formula
Topic 3. Google Doc Script
- Document Service
- Document Methods
- Body Methods
- Text Methods
- Modify and Append Text
Topic 4. Google Slide Script
- Slide Service
- Presentation Methods
- Slide Methods
- Modify Slide Font
Topic 5. Google Calendar Script
- Calendar Service
- Event Methods
- Recurrence Methods
- Create Calendar Events
- Create Recurrence Events
- Module 6. Google Drive Script
- Drive Service
- Create Folder and File
Topic 6. Google Drive Script
- Drive Service
- Create Folder and File
Topic 7. Triggers
- What is Trigger
- Time Driven Trigger
- Setup an Auto Email Alert
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: 21-65 years old
Minimum Software/Hardware Requirement
Software: NIL
Sign up for free Google account
Hardware: Windows or Mac Laptops
SSG Training Grant
SSG TG is $15 per pax. Net fee after SSG TG is $309.82. Absentee Payroll is not eligible.
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
Get Additional Course Fee Support Up to $500 under UTAP
The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).
For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
Steps to Apply UTAP
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount will be paid to training provider first and claimed after end of class by learner.
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
Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.
Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.
Truman Ng: Truman Ng is a ACTA certified trainer that graduated with Bachelor Degree in Electrical Engineering from NUS in year 2002. He designed Artificial Intelligence (AI) controller for DC-DC Power Convertor by using Fuzzy Logic and Neural Network (NN) as his university Final Year Project.
Truman has over 15 years project experiences across Database & Web Design, PLC machinery, Data Center Design , Structure Cabling System(SCS) and Enterprise Network Design and Implementation. He used to be a network architect for Hewlett Packard, working with a group of virtual team from the US in handling network design and projects in the States.
Truman is the founder of Nexplore (S) Pte Ltd. He provides solutions of Cloud SaaS, IaaS & PaaS and Software Defined Network (SDN), VoIP and Internet Security. He was engaged by Huawei Global Training Center to provide 60+ consultations and trainings for Internet Service Providers(ISP) from Malaysia, Singapore, Brunei, Philippines, Australia, Poland, Iran, South Africa, Swaziland, Cote Dlvoire, Syria, Uzbekistan, New Zealand and countries over the world.As achievement, Truman has successfully completed 100+ IT network projects for Bank, Hotel and Factory within 5 years.Truman is certified in PMP, Cisco CCNP, CCIP, CCDP, HP Ase and Huawei HCNP, HCIE R&S, HCNA Cloud, HCNA Security, etc.
Terence Ee: Terence Ee is a ACTA certified trainr that has delivered IT training in Singapore and Myanmar. He has also facilitated faith formation courses for Christians in Singapore and Myanmar. As a trainer, his mission is to co-create insightful and actionable learning experiences with his learners.His current areas of focus include project management, information security management, quality management and office productivity applications.
Terence has more than 25 years of corporate IT experience. He has held senior management roles in the public and private sectors. He holds a Master of Science in Technology Management, a Bachelor of Science in Computer and Information Sciences, a Diploma in Family Education, and the Advanced Certificate in Training and Assessment (ACTA). Part of his spare time goes towards tutoring his children in their studies (while learning a thing or two along the way). He is also imparting to them the essential skills for thriving in a digital world.
Fritz Lim: Fritz is ACTA-certified, as well as a registered MOE instructor, and a graduate of the 2018 ConsenSys Blockchain Developer Program, with a Bachelor in Electrical and Electronic Engineering (Computer Specialisation) from Nanyang Technological University.
With more than 10 years of experience teaching at a local polytechnic, Fritz is passionate about imparting knowledge to teens, adults, and children. He believes that an education in technology and in how things work is essential for everyone, so that they can harness and invent the technologies of the future. He is excited about exploring anything related to computers and IT, with a keen interest in electronics and native cross-platform mobile app development so that our ubiquitous mobile phones can be conveniently used to control and interact with devices wirelessly and over the Internet.
Leon Ye Jin Hong: Leon Ye Jin Hong is a ACTA certified trainer. He have exprience in RPA Architect, Test Automation lead, Coach and Trainer, Cloud Engineer(Azure) and Data Analysis. The Automation solutions have benefited Land Transport Authority, MINDEF Singapore, Ministry of Education(MOE), Ministry of Development(MND) Singapore Press Holdings(sph),ST Engineering, Accenture, Defence Science & Technology Agency(DSTA) and Singapore Exchange. Some Robotic Process Automation that he experience in: Automated Booking System(Customer Service), Finance Invoice Processing, HR Recruitment, HR onboarding & Offboarding and Automated Data Exchange & Reporting Generation.
Customer Reviews (14)
- will recommend Review by Course Participant/Trainee
-
A lot of information1. 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
Very interactive
Teacher share knowledge (for real life scenario) (Posted on 10/31/2023) - will recommend Review by Course Participant/Trainee
-
. (Posted on 10/31/2023)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 - will recommend Review by Course Participant/Trainee
-
I feel small class like this is very nice. (Posted on 10/31/2023)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 - will recommend Review by Course Participant/Trainee
-
Very knowledgeable trainer, Man Guo Chang. Thank you. (Posted on 12/28/2022)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 - might recommend Review by Course Participant/Trainee
-
Slides should be printed out in hard copy for participants.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
Also your venue is super far in the ulu part of the island so although course was good and Ms Tan your staff is very helpful, hard for me to recommend to my friends because it’s hard to reach(I took more than one and half hour just to get to training centre) (Posted on 9/17/2022) - will recommend Review by Course Participant/Trainee
-
. (Posted on 9/13/2022)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 5/15/2022)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 - will recomemdn Review by Course Participant/Trainee
-
Intro to web app might be useful (Posted on 11/27/2021)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 - might recommend Review by Course Participant/Trainee
-
More preparation from the trainer and more in depth use cases for the coding (Posted on 4/14/2021)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 - will recommend Review by Course Participant/Trainee
-
Teacher had much Q&A time and answered many questions.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
I was happy to attend this class. (Posted on 2/25/2020) - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/25/2020)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 - Will Recommend Review by Course Participant/Trainee
-
. (Posted on 8/23/2019)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 - Will Recommend Review by Course Participant/Trainee
-
. (Posted on 8/23/2019)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 - Will Recommend Review by Course Participant/Trainee
-
Some after-course support will be good.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
Can consider asking participant if there is anything specific they want to learn beforehand and customise part of the course. (Posted on 10/27/2018)
Write Your Own Review
You May Be Interested In These Courses
Master Google Ads Basics to Maximize Revenue, Conversion and Boost ROI
$300.00 (GST-exclusive)
$327.00
(GST-inclusive)
WSQ - Robotics Process Automation (RPA) for Beginners
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
WSQ – Software Automation with Excel VBA Programming
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
WSQ - Microsoft Power Automate RPA Developer Associate Exam Prep (PL-500)
$1,500.00 (GST-exclusive)
$1,635.00
(GST-inclusive)
WSQ - Applications Integration with Robotic Process Automation (RPA)
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
