Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

Google Apps Script Essential Training

Google Apps Script is a powerful tool to automate your Google G Suite apps such as Google Docs, Sheets, Gmail, Calendar, and Drive. This JavaScript-based platform allows you to access data from the Google cloud, edit files, automate tasks, and extend apps' power. You can even share your scripts with others in the form of add-ons. Interested in learning more?  This Google Apps Script course will show you how to use simple scripts to edit documents and spreadsheets, work with files in Drive


Topics include:

  • What is Google Apps Script?
  • Google Script for Sheets
  • Google Script for Slides
  • Google Script for Doc
  • Google Script for Calendar
  • Google Script for Drive
  • Triggers
  • Create Auto Email Alert

After your registered for the course, you can apply SSG grants below

Click here to apply SkillsFuture Credit for Individual

Click here to apply WSG Absentee Payroll for Company
Course Code: CRS-N-0040152

Course Booking

$298.00 (GST-exclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

Course Details

Module 1. Getting Started

  • What is Google Apps Script
  • Google Apps Script Editor
  • Write Your First Google Apps Script
  • Mail Service
  • Run You Script

Module 2. Google Sheet Script

  • Spreadsheet Service
  • Sheet Methods
  • Range Methods
  • Get and Change Cell Values
  • Apply Formula

Module 3. Google Doc Script

  • Document Service
  • Document Methods
  • Body Methods
  • Text Methods
  • Modify and Append Text

Module 4. Google Slide Script

  • Slide Service
  • Presentation Methods
  • Slide Methods
  • Modify Slide Font

Module 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

Module 6. Google Drive Script

  • Drive Service
  • Create Folder and File

Module 7. Triggers

  • What is Trigger
  • Time Driven Trigger
  • Setup an Auto Email Alert

Who Should Attend

Prerequisite

The following prerequisite is assumed:

  • Basic Google G Suite knowledge
  • Basic Javascript knowledge;

Software Requirement

Prerequisite

Nil

Trainers

Google  Apps Script TrainerDr. Sarita Singh received her Ph.D. degree for her work done in the area of Information Security. She is the recipient of the prestigious Infosys fellowship for pursuing her Ph.D. Programme. She has more than twenty-five years of teaching and research experience in Singapore, Malaysia and India in the field of Programming, Information Security, Web-application Development, Computer Networks and Engineering related modules.

She has presented papers at several National and International Conferences and has written articles for magazines. She has authored text-books for Engineering courses as well.

Google Apps Script TrainerCarey is an undergraduate at the Singapore University of Technology and Design (SUTD). He has previously interned at DSO National Laboratories, where he co-wrote a research paper on differential cryptanalysis on block ciphers. As an avid game developer, he has clinched 1st-runner twice consecutively at the Singapore Games Creation Competition.

Besides having a vested interest in machines, he tries in his capacity to make a difference in society. In 2014, he co-wrote a research paper pinpointing the location of various civil unrests in Singapore, and advocated for the importance of civil unrest commemorative markers at the Anatomy of a Riot conference organised by the Singapore Heritage Society. Thereafter, he was invited to intern at the Ministry of Home Affairs to finetune the research. If one pays attention when crossing the junction of Alexandra Road and Tanglin Road, one can spot a blue rectangular marker commemorating the 1955 Hock Lee Bus Riots. The commemorative marker was established by the National Heritage Board after consultations with his team and the Ministry of Home Affairs.

When he is not trying to meet the demands of being an undergraduate in Singapore, he might be taking solitary walks in parks, or working on his pet projects involving Arduino or Raspberry Pi microprocessors.

Google Apps Script TrainerDr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 1997 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.

Customer Reviews (1)

Will RecommendReview by Jennifer
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
Some after-course support will be good.

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're reviewing: Google Apps Script Essential Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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
  • Reload captcha

Tags

Other people marked this product with these Subjects:

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

Google G Suite Essential Training

Google G Suite Essential Training

28 Review(s)
$248.00 (GST-exclusive)
Advanced Google G Suite Training

Advanced Google G Suite Training

1 Review(s)
$298.00 (GST-exclusive)
Advanced Google Apps Script Training

Advanced Google Apps Script Training

$298.00 (GST-exclusive)